This subtask displays all vendor quote, purchase order line, and PO line history information that exists for the selected component part row in the main screen. For example, if a PO line (from Costpoint Purchasing) or vendor quote (from Costpoint Procurement Planning) exists for the selected row's part, it will appear in the Material Cost Worksheet table window, and you can set the applicable rows' Add to Proposal Costs column to "Y" (Yes) to add the Minimum Quantity, This Level Material Unit Cost, and cost source data columns to the Proposal Item Costs subtask. All standard functions in the Line menu are disabled in this subtask.
Vendor quote lines that appear in this screen's table window must meet the following criteria:
The quote does not have an expiration date or it has not yet expired, or
The quote has expired, but the Include Expired Vendor Quotes checkbox is selected in the Details subtask of the Maintain Proposal Master screen, and the quote's expiration date has not exceeded the date in the Quote Expire Date Cutoff field (if populated) in the Details subtask of the Maintain Proposal Master screen.
Similarly, purchase order lines (with standard parts) that appear in this screen's table window must meet the following criteria:
The PO line's order date has not exceeded the PO Order Date Cutoff field (if populated) in the Details subtask of the Maintain Proposal Master screen.
The PO line's Source Net Unit Cost is greater than zero or the Ord Ref Type for the PO line (in the Enter POs screen in Costpoint Purchasing) is not "R" (Vendor Return).
PO history lines (with standard parts) that appear in this screen's table window must meet the following criteria:
The Include Archived PO History checkbox is selected in the Materials Estimating Settings screen.
The PO history line's order date has not exceeded the PO Order Date Cutoff field (if populated) in the Details subtask of the Maintain Proposal Master screen.
The PO history line's Source Net Unit Cost is greater than zero or the Ord Ref Type for the PO history line (originally entered in the Enter POs screen in Costpoint Purchasing) is not "R" (Vendor Return).
These fields default from the main screen.
These fields default from the main screen table window for the selected item line.
These fields default from the main screen table window for the selected item line. Each calculated value in the proposal quantity break field will default in the appropriate field in this group box.
The default sort order for the table window is Cost Source Type, Cost Source ID, Cost Source Release, and Cost Source Line.
Use this field to load this cost information into the Proposal Item Costs subtask. The default for this drop-down box is "N" (No); however, if you change it to "Y" (Yes) and save the record, a new Proposal Item Cost row will be populated with quantity cost and cost source information.
Enter the minimum quantity of items for which this cost is intended. If you change the Add to Proposal Costs field to "Y" (Yes) and tab to this field, the Minimum Quantity field will default with the value in the Quantity (Part U/M) field (if populated), or from the Quote/Order Quantity field if the Quantity (Part U/M) field is zero or null. You can change the Minimum Quantity on the line, but it will load into the Proposal Item Costs subtask only if the Add to Proposal Costs field is "Y" and you save the record.
Enter the incremental materials unit cost for the item at the specified Minimum Quantity. If you change the Add to Proposal Costs field to "Y" (Yes), this field will default with the value based on the following:
If the Rollup Purchasing Line Charges in Unit Costs checkbox is selected in the Materials Estimating Settings screen, this field is calculated as follows:
Net Unit Cost + (Extra Charges/Minimum Quantity)
If the Rollup Purchasing Line Charges in Unit Costs checkbox is not selected in the Materials Estimating Settings screen, this field will display with the Net Unit Cost. You can change this field to represent the incremental material unit cost for the item at the specified Minimum Quantity. The value in this field will load into the Proposal Item Costs subtask only if the Add to Proposal Costs field is "Y" and you save the record.
There are nine different items that can be loaded in the Cost Source Type column, depending on whether the line is from a purchase order, blanket order, item/vendor quote, or purchase order history. The following table outlines the nine valid Cost Source Type values:
|
Cost Source Type |
Details |
Notes |
|
QT (Item or Vendor Quote line) |
The Enter Quotes by Item screen or Enter Quotes by Vendor screen in Costpoint Procurement Planning |
|
|
PO (Purchase Order line) |
The Type drop-down box is "Purchase Order" in the Enter POs screen in Costpoint Purchasing. |
|
|
PE (Blanket Release Order line) |
Created in the Create Blanket Releases screen in Costpoint Purchasing for an existing Blanket Order (in the Enter POs screen). The Type drop-down box in the Enter POs screen is "Release Order." |
Release Order has been created for the Blanket Order. Release number is 1 or greater for the existing Blanket Order. |
|
PA (Blanket Order line) |
The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Blanket Order." |
Blanket Order. Line's Purchase Agreement code is "A" or "S." |
|
PB (Blanket Order line) |
The Type drop-down box in the Enter POs screen in Costpoint Purchasing is "Blanket Order." |
Blanket Order. Line's Purchase Agreement code "A" or "S." |
|
HO (PO History line) |
The Archive Purchase Orders screen and the Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen is "Purchase Order." |
|
|
HR (PO History line) |
The Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen is "Release Order." |
Release Order has already been created for the Blanket Order. Release number is 1 or greater for the existing Blanket Order. |
|
HA (PO History line) |
The Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen is "Blanket Order." |
Blanket Order. Line's Purchase Agreement code is "A" or "S." |
|
HB (PO History line) |
The Create PO Change Orders screen in Costpoint Purchasing. The Type drop-down box in the Enter POs screen is "Blanket Order." |
Blanket Order. Line's Purchase Agreement code is not "A" or "S." |
This field displays the description of the cost source type (i.e., Quote, PO, Blanket Order) that was used to determine the unit costs for this part at this quantity breakpoint. You can view additional cost source details in the Proposal Item Costs subtask. You establish cost source types and descriptions in the ME Cost Source Types screen.
This field displays the PO, blanket, or quote ID from which the item appears for the selected line.
This field displays the release number for the PO, blanket, or quote ID.
This field displays the line number in which the item appears in the cost source.
This field displays the unit of measure for the item as it appears in the cost source.
This field displays the gross unit cost for the item as it appears in the cost source.
This field displays the volume discount percentage for the item as it appears in the cost source.
This field displays the net unit cost for the item as it appears in the cost source. This field is derived from the cost source's Gross Unit Cost and Volume Discount, if applicable.
If the source unit of measure is the same as the part's default unit of measure (in Costpoint Product Definition), this field is populated with the source Net Unit Cost, and the Quantity (Part U/M) field with the Quote/Order Quantity. If the source unit of measure and part's default unit of measure are different, the system searches for a matching unit of measure conversion in the Maintain Parts screen (for standard parts) or the Units of Measure screen in Costpoint Product Definition (for both standard and provisional parts). If a matching conversion factor exists, the system will populate the Net Unit Cost (Part U/M) field and Quantity (Part U/M) field with the converted cost and quantity, respectively. However, if no matching unit of measure conversion exists, both fields will be null.
For example, part "A" has a U/M of "EA" (Each) in the Maintain Parts screen in Costpoint Product Definition, and a U/M of "Box" on a PO line in the Enter POs screen in Costpoint Purchasing (i.e., 12 units each of part "A" are in one box). On the PO line, there are 3 boxes of part A, with a source Net Unit Cost of $30.00. In the Units of Measure Conversion subtask of the Maintain Parts screen, you would enter "Box" in the U/M From column, "EA" in U/M To, "12" in the Conv Factor column, "M" in Direction, with no rounding enabled (Rounding Type is "N"). If no conversion factor is found for part “A," the system will look for the correct conversion factor set up in the Unit of Measure application.
Using this conversion factor, the system will multiply the value in the Quote/Order Quantity field (3 boxes) by the Conv Factor (12) to obtain a Quantity (Part U/M) of 36. The system calculates the Net Unit Cost (Part U/M) field by dividing the source Net Unit Cost ($30.00) by the Conv Factor (12) to obtain a $2.50 net unit cost for each unit of part A.
The vendor and vendor name display for the item as they appear in the cost source. The Approved/Preferred field displays "Y" (Yes), "N" (No), or "P" (Preferred), as entered in the Appr field in the Assign Vendors screen in Costpoint Product Definition.
If the vendor is flagged as a payroll vendor, or has an Approval Code of "Not Approved" or "Pending," the quote or purchase order is excluded. If the vendor has an Approval Code of "Pending," you will receive a warning.
This field displays the vendor's order address code that applies to the line's cost information as it appears in the cost source. This field will be null if the line is from a vendor quote.
This field displays the vendor lead time for the item as it appears in the cost source. This field will only display if the line is from a vendor quote.
This field displays any charges from the PO or Quote's Line Charges subtask in their respective screens. In the Add Vendor Quotes subtask, you can manually enter extra charges before saving the quote line, and they will default into this field.
If the Extra Charges field is populated, enter, or use Lookup to select, the line charge type that is assigned to the PO or vendor quote. You can establish charge type information in the PO Line Charge Types screen in Costpoint Purchasing.
This field displays the order date (from the PO line) or quote date (from the vendor quote) for the item as it appears in the cost source.
This field displays the order quantity (from the PO line) or quote quantity (from the vendor quote) for the item as it appears in the cost source.
If the source unit of measure is the same as the part's default unit of measure (in Costpoint Product Definition), the Net Unit Cost (Part U/M) is populated with the source Net Unit Cost, and the Quantity (Part U/M) field with the Quote/Order Quantity. If the source unit of measure and part's default unit of measure are different, the system searches for a matching unit of measure conversion in the Maintain Parts screen (for standard parts) or the Units of Measure screen in Costpoint Product Definition (for both standard and provisional parts). If a matching conversion factor exists, the system will populate the Net Unit Cost (Part U/M) field and Quantity (Part U/M) field with the converted cost and quantity, respectively. However, if no matching unit of measure conversion exists, both fields will be null.
For example, part "A" has a U/M of "EA" (Each) in the Maintain Parts screen in Costpoint Product Definition, and a U/M of "Box" on a PO line in the Enter POs screen in Costpoint Purchasing (i.e., 12 units each of part "A" are in one box). On the PO line, there are 3 boxes of part A, with a source Net Unit Cost of $30.00. In the Units of Measure Conversion subtask of the Maintain Parts screen, you would enter "Box" in the U/M From column, "EA" in U/M To, "12" in the Conv Factor column, "M" in Direction, with no rounding enabled (Rounding Type is "N"). If no conversion factor is found for part "A," the system will look for the correct conversion factor set up in the Unit of Measure application.
Using this conversion factor, the system will multiply the value in the Quote/Order Quantity field (3 boxes) by the Conv Factor (12) to obtain a Quantity (Part U/M) of 36. The system calculates the Net Unit Cost (Part U/M) field by dividing the source Net Unit Cost ($30.00) by the Conv Factor (12) to obtain a $2.50 net unit cost for each unit of part A.
This field displays the period of performance end date (from the PO line) or expiration date (from the item/vendor quote) for the item as it appears in the cost source.
This field displays the buyer ID for the PO/quote as it appears in the cost source.
This field displays the project ID for the PO/quote as it appears in the cost source.
This field displays up to 254 alphanumeric characters of notes associated with the line item as they appears in the cost source.
This field displays "Y" (Yes) if the PO line or PO line history item has been issued to the purchase order (via the Enter Issues screen in Costpoint Inventory). This field displays "N" (No) if the line is a quote or has not been issued to a purchase order.
This field displays "Y" (Yes) if the PO line is a from subcontract purchase order (i.e., the Ord Ref Type is "M" (Manufacturing Order) in the Enter POs screen in Costpoint Purchasing). This field displays "N" (No) if the PO line (or PO line history) does not have an Ord Ref Type of "M" or if the line is a quote.
This field displays "Y" (Yes) if the PO line is from a vendor return (i.e., the Ord Ref Type is "R" (Vendor Return) in the Enter POs screen in Costpoint Purchasing) that was entered in the Enter Vendor Returns screen in Costpoint Receiving. This field displays "N" (No) if the PO line (or PO line history) does not have an Ord Ref Type of "R" or if the line is a quote.
This field displays the vendor's Approval Code that was set in Accounting » Accounts Payable » Vendor Info » Approve Vendors. This is "A" if the vendor is approved, "N" if the vendor is not approved, or "P" if the vendor's approval status is pending.