 |
|
| Our Products |
 |
| More Open Source |
|
xTuple ERP 3.0 won the LinuxWorld product excellence award for best Business Application! Read more here!
| Our Community |
|
| Industry case studies |
|
| Free Demo Download |
|
|
|
Costing reports are found in this section.
Costed BOM Reports.
2.6.6.1.1.
Costed Single Level BOMTo 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.
- 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.
- PRINT
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:
-
Maintain Item Costs
Select to maintain Costs for the specified Item.
-
View Item Costing
Select to view detailed Costing information for the specified
Item.
-
Export the data displayed on the screen into a plain-text,
TAB-delimited file. This file may subsequently be imported into a
spreadsheet or other office tool.
2.6.6.1.2.
Costed Indented BOMThe 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.
- 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.
- PRINT
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:
-
Maintain Item Costs
Select to maintain Costs for the specified Item.
-
View Item Costing
Select to view detailed Costing information for the specified
Item.
-
Export the data displayed on the screen into a plain-text,
TAB-delimited file. This file may subsequently be imported into a
spreadsheet or other office tool.
2.6.6.1.3.
Costed Summarized BOMA 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.
- 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.
- PRINT
Runs the report associated with this screen.
Item Cost Reports.
2.6.6.2.1. Item Costs by Class CodeTo 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, as described in Section 1.2.9, “Topic: Pattern Matching with 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.
- 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.
- PRINT
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:
-
View Item Costing Summary
Select to view summarized Costing information for the
specified Item.
-
Update Actual Costs
Select to update Actual Costs for the specified Item.
-
Post Actual Costs
Select to post Actual Costs to Standard Cost for the specified
Item.
-
Export the data displayed on the screen into a plain-text,
TAB-delimited file. This file may subsequently be imported into a
spreadsheet or other office tool.
2.6.6.2.2. Item Costs SummaryTo 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.
- PRINT
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.
-
View Costing Detail
Select to view detailed Costing information for the specified
Item.
-
Export the data displayed on the screen into a plain-text,
TAB-delimited file. This file may subsequently be imported into a
spreadsheet or other office tool.
2.6.6.2.3.
Item Costs HistoryThe "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.
- PRINT
Runs the report associated with this screen.
|
 |
|
