Costing reports are found in this section.
Costed BOM Reports.
To view Costs for a single level Bill of Materials, select the "Costed Single Level BOM" option. The following screen will appear:
When displaying Costs for a single level Bill of Materials, you are presented with the following options:
- Item Number
Enter the Item Number of the manufactured Item whose associated Costs you would like to view using a single level Bill of Materials.
- UOM
Inventory Unit of Measure.
- Revision
-
If Revision Control is enabled at your site, specify the Bill of Materials Revision Number you want to view. If none exists, simply enter a value to create one. The status of the Revision will also be displayed. The following statuses apply to Revisions:
- Active
This is the current, default Revision used for costing and Material Requirements Planning (MRP). Only one Revision can be active at the same time. Active Revisions may be modified. However, once a Revision becomes inactive, it may no longer be changed.
- Use Standard Costs
Select to display Standard Costs for the specified Item. Both the Unit Cost and Extended Cost for each component Item, expressed in terms of Standard Cost, will display—assuming Standard Costs have been defined for each component Item.
Tip
When Labor and Overhead are posted to the General Ledger, they are posted using their Actual Cost. This is a departure from the rule which governs materials—namely, that materials are always posted using their Standard Cost. Differences between Actual and Standard Labor and Overhead Costs will be reflected in Inventory Cost Variances when Work Order Production or Operations are posted. You can address these variances if and when they occur by posting your Actual Costs to Standard.
- Use Actual Costs
Select to display Actual Costs for the specified Item. Both the Unit Cost and Extended Cost for each component Item, expressed in terms of Actual Cost, will display—assuming Actual Costs have been defined for each component Item.
Note
The totals displayed on the screen are derived as follows:
- Total Cost
This total is pulled from the Extended Cost column. The total may vary, depending on whether "Use Standard Costs" or "Use Actual Costs" is selected.
- Actual Cost
This value represents the Actual Cost for the parent Item whose Costed Indented BOM is being displayed.
- Standard Cost
This value represents the Standard Cost for the parent Item whose Costed Indented BOM is being displayed.
- Costed Bill of Materials
Display lists Costed Bill of Materials components, using the specified parameters. The Total Cost, Actual Cost, and Standard Cost will be calculated automatically at the bottom of the display.
To the far right of the screen, the following buttons are available:
- CLOSE
Closes the screen, returning you to the application desktop.
Runs the report associated with this screen.
Right-clicking on a component in the Costed Bill of Materials list enables you to select from the following menu options:
The difference between the indented view and the single level view is that the indented view displays Costs for all subcomponents if there is a manufactured component listed on the Bill of Materials list. To view associated Item Costs using an indented Bill of Materials, select the "Costed Indented BOM" option. The following screen will appear:
When displaying Costs for an indented Bill of Materials, you are presented with the following options:
- Item Number
Enter the Item Number of the manufactured Item whose associated Costs you would like to view using an indented Bill of Materials.
- UOM
Inventory Unit of Measure.
- Revision
-
If Revision Control is enabled at your site, specify the Bill of Materials Revision Number you want to view. If none exists, simply enter a value to create one. The status of the Revision will also be displayed. The following statuses apply to Revisions:
- Active
This is the current, default Revision used for costing and Material Requirements Planning (MRP). Only one Revision can be active at the same time. Active Revisions may be modified. However, once a Revision becomes inactive, it may no longer be changed.
- Use Standard Costs
Select to display Standard Costs for component Items in the specified Item's Bill of Materials. Both the Unit Cost and Extended Cost for each component Item, expressed in terms of Standard Cost, will display—assuming Standard Costs have been defined for each component Item.
Tip
When Labor and Overhead are posted to the General Ledger, they are posted using their Actual Cost. This is a departure from the rule which governs materials—namely, that materials are always posted using their Standard Cost. Differences between Actual and Standard Labor and Overhead Costs will be reflected in Inventory Cost Variances when Work Order Production or Operations are posted. You can address these variances if and when they occur by posting your Actual Costs to Standard.
- Use Actual Costs
Select to display Actual Costs for component Items in the specified Item's Bill of Materials. Both the Unit Cost and Extended Cost for each component Item, expressed in terms of Actual Cost, will display—assuming Actual Costs have been defined for each component Item.
Note
The totals displayed on the screen are derived as follows:
- Total Cost
This total is pulled from the Extended Cost column. The total may vary, depending on whether "Use Standard Costs" or "Use Actual Costs" is selected.
- Actual Cost
This value represents the Actual Cost for the parent Item whose Costed Indented BOM is being displayed.
- Standard Cost
: This value represents the Standard Cost for the parent Item whose Costed Indented BOM is being displayed.
- Costed Bill of Materials
Display lists Costed Indented Bill of Materials components, using the specified parameters. The difference between the indented view and the single level view is that the indented view displays all subcomponents if there is a manufactured component listed on the Bill of Materials. The Total Cost, Actual Cost, and Standard Cost will be calculated automatically at the bottom of the display.
To the far right of the display are the following buttons and display fields:
- CLOSE
Closes the screen, returning you to the application desktop.
Runs the report associated with this screen.
Right-clicking on a component in the Costed Bill of Materials list enables you to select from the following menu options:
A summarized Bill of Materials shows all the material requirements for an Item. The components for subassemblies are included in this view; however, the top-level subassemblies themselves are excluded. To view a Costed summarized Bill of Materials, select the "Costed Summarized BOM" option. The following screen will appear:
When displaying a Costed summarized Bill of Materials, you are presented with the following options:
- Item Number
Enter the Item Number of the manufactured Item you would like to view a Costed summarized Bill of Materials for.
- UOM
Inventory Unit of Measure.
- Revision
-
If Revision Control is enabled at your site, specify the Bill of Materials Revision Number you want to view. If none exists, simply enter a value to create one. The status of the Revision will also be displayed. The following statuses apply to Revisions:
- Active
This is the current, default Revision used for costing and Material Requirements Planning (MRP). Only one Revision can be active at the same time. Active Revisions may be modified. However, once a Revision becomes inactive, it may no longer be changed.
- Show Expired Components
-
Select to cause expired components to be listed in the "Bill of Materials" display.
- Threshold Days
Select a number using the arrow buttons, or manually enter a value up to a maximum of 999. Components that have been expired from the Bill of Materials within the specified number of days will be included in the display.
- Show Future Components
-
Select to cause future components to be listed in the "Bill of Materials" display.
- Threshold Days
Select a number using the arrow buttons, or manually enter a value up to a maximum of 999. Components that will be added in future to the Bill of Materials within the specified number of days will be included in the display.
- Use Standard Costs
Select to display Standard Costs for the specified Item.
Tip
When Labor and Overhead are posted to the General Ledger, they are posted using their Actual Cost. This is a departure from the rule which governs materials—namely, that materials are always posted using their Standard Cost. Differences between Actual and Standard Labor and Overhead Costs will be reflected in Inventory Cost Variances when Work Order Production or Operations are posted. You can address these variances if and when they occur by posting your Actual Costs to Standard.
- Use Actual Costs
Select to display Actual Costs for the specified Item.
- Bill of Materials
Display lists summarized Bill of Materials components, using the specified parameters.
To the far right of the screen, the following buttons are available:
- CLOSE
Closes the screen, returning you to the application desktop.
- QUERY
Select to generate the display, using the specified parameters.
Runs the report associated with this screen.
Item Cost Reports.
To view Item Costs by Class Code, select the "Item Costs by Class Code" option. The following screen will appear:
When displaying Item Costs by Class Code, you are presented with the following options:
- All Class Codes
Select to display Item Costs for all Class Codes.
- Selected
Specify Class Code whose Item Costs you want to display.
- Pattern
Enter a Class Code pattern to select a range of Class Codes. Refine your search using Regular Expressions.
- Only Show Zero Cost Items
Select to include only Items with zero Cost in the display. Use this option to identify Items having no Costs associated with them. The zero Costs view can be helpful when trying to determine why no General Ledger (G/L) transactions are being generated when certain Items are involved. Items must have Standard Costs associated with them if transactions involving them are to be recorded in the G/L. If an Item has no Standard Cost, no G/L records for that Item will be created.
- Only Show Items where Actual and Standard are different
Select to include in the report only those Items whose Actual and Standard Costs are not the same.
- Items
Display lists Item Costs by Class Code, using the specified parameters.
To the far right of the screen, the following buttons are available:
- CLOSE
Closes the screen, returning you to the application desktop.
- QUERY
Select to generate the display, using the specified parameters.
Runs the report associated with this screen.
Right-clicking on an Item in the list of Items displayed by Class Code enables you to select from the following menu options:
To view a summary of Item Costs, select the "Item Costs Summary" option. The following screen will appear:
When displaying a summary of Item Costs, you are presented with the following options:
- Item Number
Enter the Item Number of the Item you would like to view summarized Costs for.
- UOM
Inventory Unit of Measure.
- Costing Elements
Display lists an Item Costs Summary, using the specified parameters.
To the far right of the screen, the following buttons are available:
- CLOSE
Closes the screen, returning you to the application desktop.
Runs the report associated with this screen.
Right-clicking on a Costing Element in the Costing Elements list enables you to select from the following menu options. If the Costing Element does not contain lower level Costs, you will not be given the option to view Costing detail.
The "Item Costs History" display features an historical record of Costs per Item, sorted by Costing Elements. To view the history of Costs associated with an individual Item, select the "Item Costs History" option. The following screen will appear:
When displaying the history of Costs associated with an Item, you are presented with the following options:
- Item Number
Enter the Item Number of the Item whose Cost history you would like to view.
- UOM
Inventory Unit of Measure.
- Costing History
Display lists an Item's Cost History, using the specified parameters.
To the far right of the screen, the following buttons are available:
- CLOSE
Closes the screen, returning you to the application desktop.
Runs the report associated with this screen.