When a broker order line is processed, the inventory item in the sales order line is used only as a place holder, and the information about the actual item being processed is stored in other fields in the sales order line and in special AIC Comments that are created for the sales order line. The information that is stored for each broker sales order line includes the following.
• Manu Item No: The Manufacturer Item number for the item. The manufacturer item number is stored in the Manu Item No field in the Sales Order Temp file and the Sales Order Line Item file. The field is an ascii 15 character field. The Manufacturer Item in each Broker sales order line item is carried into any purchase order requisitions or purchase order lines that are created by the system for the sales order line.
• ManuAccount: The Manufacturer Account Number for the manufacturer of the item. This manufacturer account number must exist in the system (if the manufacturer for the item does not exist in the system, the manufacturer information can still be specified, so that the company can be set up in the manufacturer file by Purchasing or Product Management. The Manufacturer Item in each Broker sales order line item is carried into any purchase order requisitions or purchase order lines that are created by the system for the sales order line.
• Manufacturer Information if not on file: This is used if the Manufacturer for the item is not already set up in the system. If the manufacturer for the item being ordered is not set up in the system, the operator can add information about the manufacturer to the order line. The information that is prompted for by the system and which is stored in the comment is controlled by a Textdata record and typically includes the Manufacturer name, address information, contact information and phone and website information. When this information is specified by the operator it is saved to an AIC (Additional Information Comment) comment attached to the sales order line. This comment information is also carried into or copied to a comment for any po requisitions or purchase order lines that are created for the broker sales order line.
• Item Description. Since the broker item is a generic item number or placeholder, the description in the broker item itself is not useful for processing the order. StreamV therefore allows the operator to key in the actual description for the item being ordered during the entry of the broker line item. The description entered by the operator is saved to an AIC comment that is attached to the sales order line. This comment information is also carried into any po requisitions or purchase order lines that are created for the broker sales order line.
• Vendor Item#: The Vendor Item Number for the item being ordered, based on the vendor specified in the line. The Vendor Item Number field is stored in the sales order line and it is also copied into any purchase order requisitions or po lines that are created for the sales order line.
• Vendor Account: The Vendor Account Number for the vendor the item should be purchased from. This vendor account number must exist in the system (if the vendor for the item does not exist in the system, the vendor information can still be specified, so that the vendor can be set up in the Vendor file by Purchasing or Product Management. The Vendor Account in each Broker sales order line item is used to identify the vendor to be used when the system creates a po requisition line for the sales order line. If the Vendor Account is not specified, the system will use the default vendor for the broker item when creating a po requisition for the line.
• Vendor Information if not on file: This is used if the Manufacturer for the item is not already set up in the system. If the manufacturer for the item being ordered is not set up in the system, the operator can add information about the manufacturer to the order line. The information that is prompted for by the system and which is stored in the comment is controlled by a Textdata record and typically includes the Manufacturer name, address information, contact information and phone and website information. When this information is specified by the operator it is saved to an AIC (Additional Information Comment) comment attached to the sales order line. This comment information is also carried into or copied to a comment for any po requisitions or purchase order lines that are created for the broker sales order line.
• Purchase Cost: The vendor price for the item being ordered. This price is used by the system when creating a po requisition for the order line and it is also used to calculate the commission cost and gpm% for the line.