The Internal Supplier feature is used to automate sales order entry for vendor/customer relationships between two business entities in the same database. The feature can be used whenever a formal purchase order/sales order relationship is desired between entities.
The entities might be two different plants in the same manufacturing enterprise and financial enterprise, or they might belong to completely different enterprises.
This feature only automates the sales order entry function and does not include the shipping or receiving aspects of the sales order and purchase order.
For more information and setup, see the feature documentation.
New program for the maintenance of specific purchase order line information, including the item description, quantity ordered, current promise date, and purchase order line comments.
Modified to view buyer records by displaying program POBM, Buyer Maintenance, in query-only mode.
Added item description colors and PO value coloring based on the minimum purchase order and minimum freight values for the vendor.
Program POIK, PO / Item Kiosk, is used to aid in purchasing decisions for the future by providing planning, stock status, purchasing, quantity breaks, shipment history, and forecast information for an item. Items queried can be limited to those with an on hand quantity that is within a specified percentage of the reorder point.
The information returned includes:
Item planning information, including the preferred vendor, item number, stock unit of measure, buyer code, planner code, reorder point quantity, total lead time, on hand quantity, percentage above reorder point, forecast daily demand, days to reorder point, days to safety stock, safety stock quantity, minimum order quantity, order multiple, sales allocations, manufacturing allocations, and on order quantity.
Sales statistics information, calculated using the Sales Statistics Control Parameters, including the Service Z factor and Horizon values used to calculate the statistics. The values calculated include the population, mean quantity, standard deviation, maximum shipped quantity, calculated quantity, and year to date sales.
Open purchase orders for the vendor are displayed, including the purchase order number, buyer code, purchase order date, purchase order total, ship via code, and drop ship flag. When an open purchase order is selected, the open lines for the item on that purchase order are displayed.
Open purchase orders lines for the item are displayed for the selected purchase order, including the vendor number, purchase order number, purchase order line, quantity ordered, quantity received, due date, purchasing unit of measure, unit of measure conversion, unit cost, and price unit of measure. Purchase order lines can be added to existing purchase orders.
Pricing information, including the minimum quantity, unit price, discount percentage, marginal analysis quantity, marginal analysis cost, and marginal analysis unit cost. Press the [Legend] 
button to view the meaning of the colors for the pricing bracket records.
Black -- lower qty bracket, not pertinent
Blue -- current qty bracket for PO line
Brick -- higher qty bracket, higher unit cost than current purchase order line (unfavorable)
Green -- higher qty bracket, lower total cost ( most favorable situation ).
Purple -- higher qty bracket, lower unit cost, higher total cost
For alternate currency purchase orders, the general ledger account needs to be the same currency as the local enterprise because that is the currency in which the purchase order will be paid in program APVM, Voucher Entry/Maintenance.
Added item description colors. Items will have different color descriptions based on the type of item entered.
Red: kit items
Green: model items
Brick Red non-maintain on hand items
Blue non stock items
Black all other item types
Purple service and drop ship items
Added Line Weight to the purchase order lines on the Pricing Tab. The line weight comes from the item record in program ICSM, Inventory Sales Data Maintenance, for the item and purchase unit of measure. If no record exists for the purchase unit of measure, the stock unit of measure for the item is used.
The line weight for each line item is added up and displayed in the PO Weight field on the Codes Tab. If some of the item weights are not available, the words May be Incomplete are displayed to the right of the calculated weight.
GL Account field added to the Lines Tab.
Drop Ship Only flag added to the Lines Tab. The setting of this flag is taken from program ICMM, Inventory Master Maintenance, and cannot be changed in this program. When a drop ship only item is entered in a purchase order, the Drop Ship flag is set to on and cannot be set to off unless the drop ship only lines are voided.
Added Control No to Lines Tab.
Added [Recalc GL Account] button to the Lines Tab. Recalculates the general ledger account to which the purchase order line should be posted.
If the purchase order was created for a sales order line, the PO_COST_UPDATE_ALLOWED parameter in program MURM, Initialization Parameter Maintenance , determines if the sales order line cost should be updated when the purchase order price is changed.
Destinations pop-list on the Destinations tab is hidden if the purchase order is a drop ship purchase order.
Added Internal Supply SO, Line, and Enterprise fields for new Internal Suppliers feature.
Added Lines Receipts tab.
Reorganized fields on this screen. Users can enter the quantity in either stock units or purchase units. Depending on which one is entered, the other is calculated using the unit of measure conversion displayed on the screen.
New Auto Show Order Comments flag.
When this flag is set to on, and a line is selected in program POSE, Create Purchase Orders from Sales, that has sales order line comments assigned, the sales order line comments screen will be displayed.
When this flag is set to off, there is no indication that the sales order line has comments.
New Use active-managed table for POSE flag.
When this flag is set to off, the data in program POSE, Create Purchase Orders from Sales, is based on the standard view with real time data.
When this flag is set to on, the data in program POSE, Create Purchase Orders from Sales, is based on a materialized view, which is much faster but is only as accurate as the last refresh of that view.
If using the materialized view, a job queue refresh for the materialized view should be set up in program JOBQ, NDS Job Queue Management, by the system administrator.
Added display of quantity available to this program. Displayed in red when the quantity is negative.
When calculating the due date for the purchase order line, the requisition due date is considered. If the requisition due date is past due or if it is less than the current system date plus the purchasing lead time, the due date is adjusted to be the current system date plus the item's purchasing lead time. Requisition due dates that are not past due or within the purchasing lead time of the current system date will be preserved and applied to the purchase order line.
The purchasing lead time is determined as follows:
The lead time on the vendor quote for this item, purchase unit of measure, and vendor.
The lead time for the item in program ICRM, Item/Plant Planning Maintenance, for this plant.
The lead time for the item in program ICPM, Inventory Planning Data Maintenance, for this manufacturing enterprise.
If the current system date is 06-20-03 and the lead time for the item is 5 days, the following examples hold true:
Req Due Date PO Line Date
05-29-03 06-25-03
06-20-03 06-25-03
06-22-03 06-25-03
06-26-03 06-26-03
For the web version, the [Vendor Pricing] 
button does not change color. Instead, there is a red dot next to the button if there are multiple quantity breaks for the item. In both web and client server versions, this button is grayed out if there is one or less quantity break for the vendor quote.
Items are colored orange if the item exists on an open pull card in program IPSM, Inventory Pull Card Definition, where the from unit code and plant code are the same as the logged in unit code and plant code, and the to unit code and plant code are different than the logged in unit code and plant code.
New program to maintain the plant purchasing and receiving register numbers.
Modified to allow viewing of closed and open requisitions, instead of just open requisitions.
The data in this program is either based on a standard view with real time data, or is based on a faster materialized view that is only as accurate as the last refresh of that view. The setting of the Use active-managed table for POSE flag in program POPM, PO / Receiving Parameter Maintenance, determines which view is being used.
If the Auto Show Order Comments flag is set to on in program POPM, PO / Receiving Parameter Maintenance, and the sales order line has comments assigned, the sales order line comments screen will be displayed when the line is selected.
Added additional fields to this program. The information displayed includes the purchase order number, purchase order status, purchase order line number, purchase order line status, vendor number, item number, item description, unit of measure, quantity ordered, quantity remaining, work order number, operation sequence number, and destination.
When purchase order pricing is determined, if the purchase order date does not fall within the effective dates, the base price from the header will be selected.
When automatically shipping receipts, the standard cost after the receipt is used for the sales order line and general ledger posting.
When the purchase order has the Drop Ship flag set to on and the purchase order line is assigned to a sales order line as its destination, the purchase order line cannot be received in program REOM, One Step Receiver Entry/Maintenance, or program REEM, Receiver Entry/Maintenance, and must be shipped using program OESC, Shipping Confirmation.
New field: New Default flag. Set this flag to determine if the entered location should be the default location for the item in program ICEM, Item Plant Maintenance.
The default setting of this flag is determined by the RCVG_UPDATES_DEFBIN parameter in program MURM, Initialization Parameter Maintenance.
When set to YES, the flag defaults to on.
When set to NO, ZEROASK, and ASK, flag default to off.
When set to ZERO, the flag defaults to off unless the item does not have a quantity on hand in the plant, in which case the flag defaults to on.
New field: Reference Text. Enter any reference information to be written to the item transaction log.
Modified so that the invoice number is no longer required to be entered manually when using the [Receive PO] button to receive purchase orders. If the invoice number is not entered manually during receipt, the system will assign an invoice number to the vouchers for both manually and automatically received purchase orders.
Comments entered on the receiver line will be copied to the return to vendor transaction when the inventory is moved to a quarantine location from this program.
Added new Def flag. When set to on, if the entered location should be the default location for the item in program ICEM, Item Plant Maintenance.
The default setting of this flag is determined by the RCVG_UPDATES_DEFBIN parameter in program MURM, Initialization Parameter Maintenance.
When set to YES, the flag defaults to on.
When set to NO, ZEROASK, and ASK, flag defaults to off.
When set to ZERO, the flag defaults to off unless the item does not have a quantity on hand in the plant, in which case the flag defaults to on.
Added additional receiver information that was missing from this program.
When the ALLOW_RTV_INSERT parameter is set to Y in program MURM, Initialization Parameter Maintenance, discontinued items can be entered here, in the same way as non-stocked and non-maintain on hand items. The reason code assigned to these transactions is defined by the RTVM_DEFAULT_REASON_CODE parameter.
Added Inspect Only flag. Checkbox set to on or off indicates whether the items on this return to vendor transaction are being returned to the vendor for inspection only.
When set to on, and the RTV_HOLD_INSPECT parameter in program MURM, Initialization Parameter Maintenance, is set to Y, credit journals will not be written for the return to vendor transaction.
When set to off or when the RTV_HOLD_INSPECT parameter is set to N, credit journals will be written for the return to vendor transaction when the status is changed to Picked.
For return to vendor transactions that had this flag set to on¸ and the RTV_HOLD_INSPECT parameter is set to Y, when the user sets this flag to off, the credit journals will be written.
When the RTV_AUTO_PACK_PRINT parameter is set to Y in program MURM, Initialization Parameter Maintenance, the packing list will be printed for the return to vendor transaction, provided that the drill down record for program RTVPA, Return to Vendor Pack List, has been set up.
When the RTV_AUTO_CLOSE parameter is set to Y in program MURM, Initialization Parameter Maintenance, the status will change to Closed automatically after the voucher is created.
The Empty Wt, Gross Wt, and Net Wt fields in this program have been modified to use the new 5 decimal place weights and weight rounding. See Item Weight Rounding for more information.
New report requesting the vendor for authorization to return items. The report is printed for a single return to vendor transaction.
New program to display vendor history and vendor item history by vendor.
Added display for the status of the selection, the number of items selected, and the table to be updated are displayed in the upper right corner of the screen.
For example:
Set New Values For Selected Items
## Items Selected
Item Planning
Updated when the [Make Selection] and [Apply Changes] buttons are pressed.
Modified to access query-only versions of the main vendor information programs, including:
VEMM, Vendor Master Maintenance
APII, Invoice Inquiry
VEHI, Vendor History Inquiry
GLDM, Distribution Code Maintenance
VESM, Third Party Vendor Maintenance
VEQM, Vendor Quote Maintenance
VEPM, Preferred Vendor Maintenance
PORQ, Purchase Requisition Inquiry
Each of these programs is accessed using the appropriate button in program VEMI, Vendor Master Inquiry. When the button is pressed, the associated program is opened. If you entered query information in this program, then when the associated program is opened, it will be opened displaying only the matching information for the queried vendor in this program.
Added Internal Vendor flag and Int Enterprise field for new Internal Suppliers feature.
Multiple records can exist for the same minimum quantity, as long as they have different effective dates. When purchase order pricing is determined, if the purchase order date does not fall within the effective dates, the base price from the header will be selected.
The item description will be updated automatically when the item description is changed in program ICMM, Inventory Master Maintenance, if the VEQM_ITEM_DESC_SYNC parameter in program MURM, Initialization Parameter Maintenance, is set to Y. Otherwise, changes to the item description in program ICMM, Inventory Master Maintenance, will not affect the description here.
New report to print a report listing vendor check amounts for specific accounts payable accounts. The report is printed by accounts payable account number and date range.
Added new Update Preferred Vendor flag on the Maintain Template Tab. . When this flag is set to on, the preferred vendor in program ICPM, Inventory Planning Data Maintenance, or program ICRM, Item/Plant Planning Maintenance, will be updated to match the vendor in the vendor upload file.
Item planning updates through this program will only update one record. If the Upload File Tab has a plant entered, the item planning record in program ICRM, Item/Plant Planning Maintenance, for the plant will be updated. If there is no record in program ICRM, Item/Plant Planning Maintenance, for the plant, the item planning record in program ICPM, Inventory Planning Data Maintenance, for the logged in enterprise will be updated.
Added new Qty Breaks Tab to allow upload of vendor quote quantity breaks. Added effective from and through dates for the upload and for each quantity break record separately.
On the Maintain Template tab, in the Default Value field, you can enter a default value for the column that will be used when that column is null for an imported record.
If you want all records to default to the value then point the column to an empty column in the csv worksheet.
The field only allows entry of up to thirty characters.
Dates entered in this field must be in the format DD-MON-YY. For example if you want the ICSM Effective Date to default to November 18th, 2005, you would entered 18-NOV-05 in the default value field for that column. No quotes are necessary.
Added new fields to the Upload Zoom tab. Entries in the item comment section will be available from the [Comments] 
button in any of the item maintenance screens. Added Item Manufacturer information that will be entered in program ICMX, Mfgr Item / NDS Item Cross Reference.
Added new MURMS Tab, which allows the maintenance of parameters controlling the functionality of this program. These parameters are normally set up in program MURM, Initialization Parameter Maintenance, but can be maintained here, if desired. Documentation for the parameters is located in the Vendor Upload Parameter Setup section. New records cannot be entered here.
New File Location field that indicates whether the file will be uploaded from a directory on the web server or from a directory accessible from the local computer. Select Database if you are running NDS Applications in web mode. Select Client Server if you are running NDS Applications in client server mode. The […] button is only available if you are running in client server mode. In web mode, the directory from which the file will be uploaded is defined by the VUTM_UTL_DIR parameter in program MURM, Initialization Parameter Maintenance.