Use this screen to prioritize cost sources before entering material issues or invoices.
Sales order line types designated as "DRP" (Dropshipment), "INT" (In-Transit), "REC" (Recurring), and "INO" (Invoice) have associated costs derived from this pre-established system screen.
Sales order items that require an issue transaction, INT and DRP line types, are assigned a unit cost at issue based on the system search of cost types, which can be changed in the Enter Sales Order Inventory Issue screen. The search is done in the user-selected sequence established in this screen.
For sales order items that require an invoice transaction, INO and REC line types, the Create Invoices and Maintain Invoices screens will search the Sales Order Cost Types table to determine appropriate item unit costs. The cost search is done in user-defined sequence from the lowest to highest number. You can override the unit cost amount selected in one of the invoice screens for these two types of items.
You must set up this screen when you initialize Costpoint Sales Order Entry and before processing issues and invoices.
This field displays the two-character system-defined cost type code, which cannot be edited. Valid cost types are:
"CS"- Cost Schedule/Pct of Sales: The appropriate product cost schedule is determined in the sales order by the pricing project or the pricing catalog. The system derives the unit cost by comparing the sales order's order date to the product's start and end date in the Project Cost Schedule and then comparing the order quantity to the designated quantity breakpoints. It is important to note that the order quantity, rather than the issue quantity, will determine the item's breakpoint unit cost.
"IL" - Item Last Cost: The system maintains this cost field. It is updated when a receiving transaction is recorded for a sales order item. The receiving transaction is preceded by entry of a requisition and purchase order.
"IR" - Item Reference Cost: This value indicates that the item cost will be from the Maintain Item Cost screen for reference cost types.
"IS" - Item Standard Cost: This value indicates that the item cost will be from the Maintain Item Cost screen for standard cost types.
"PL" - Project/Item Last Cost: The system maintains this cost field. It is updated when a receiving transaction is recorded for a sales order item that was charged to the corresponding project. The receiving transaction is preceded by entry of a requisition and purchase order.
"PO" - Purchase Order Cost: You can generate an approved sales order into a purchase requisition, which in turn can become a purchase order. This cost type looks up the purchase order created for the associated sales order. The sales order number is stored along with the requisition and purchase order line numbers and the information flows through Costpoint. When the ordering unit of measure differs from the selling unit of measure, the system will convert the unit cost accordingly.
"PR" - Project/Item Reference Cost: This value indicates that the item cost will be from the Maintain Project Item Cost screen for reference cost types. Each item can have a different cost associated with it for a given project.
"PS" - Project/Item Standard Cost: This value indicates that the item cost will be from the Maintain Project Item Cost screen for standard cost types. Each item can have a different cost associated with it for a given project.
This field displays the description of the two-character cost type code.
Enter the sequence in which you want the cost types to be searched to determine item costs when material issue and invoice transactions are recorded. Rank the cost types by entering numbers between one and eight; enter zero if a cost type should not be searched. The cost types will be accessed sequentially, starting with one.
The system will search until a cost greater than zero is located. A zero unit cost will be used only after all of the cost types have been checked and also found to be zero. The system multiplies the unit cost by the material issue quantity or, when appropriate, the invoice quantity, to determine the extended cost.