Cost Shares Breakdown Report

With the Cost Shares Breakdown report, you can print or view how cost is broken down in inventory, WIP, or COGS, according to:

Note

The report breaks down cost at a single BOM level, so that it does not roll up the costs from lower BOM levels. The report also cannot calculate the cost share from items that use the Average costing method.

If you want to include more information in the report, you can select additional fields that you want to include in the report. To do this, in the Field field in the Item or Production Order tab, press F3, click the AssistButton and then select the relevant field(s). You can set filters on any of the fields. If you do not set any filters, the report includes all your records.

To print the report, click the Print button. To see the report on screen, click Preview. If you want to save your report and print it later, click Cancel (the program automatically saves your report).

To run the report, fill in the request form tabs as follows:

Item tab

No.: Enter the item numbers or a filter on the item numbers that you would like to include in the report. If you leave this field blank, the report will include all items. To see the existing numbers, click the AssistButton in the Filter field.

Inventory Posting Group: Enter the inventory posting group or a filter on the inventory posting groups that you would like to include in the report. If you leave this field blank, the report will include all inventory posting groups.

Click the up-arrow in the lower left-hand corner of the window to see the table with the results of the filters you have set for the report.

Production Order tab

Status: Enter the production order status or a filter on statuses that you would like to include in the report. If you leave this field blank, the report includes all production order statuses.

No.: Enter the production order number or a filter on production order numbers that you would like to include in the report. If you leave this field blank, the report includes all production orders.

Options tab

Starting Date: Enter the first date from which you want the information in the report to be taken. If you leave this field blank, the program includes all information up to the ending date that you specify in the Ending Date field.

Ending Date: Enter the last date from which you want the information in the report to be taken. If you leave this field blank, the program includes all information from the starting date to the present time.

Print Cost Share: Select the category for which you would like to see a breakdown of costs. The options are Sales (for a breakdown of costs in COGS), Inventory, and WIP Inventory.

Show Details: Place a check mark in this field to see a detailed breakdown for each item of where the cost comes from. For inventory, this is a breakdown of the original inbound entries that still remain in stock as of the report date. For WIP, this is a breakdown of production order costs that have not been completely finished as of the report date. For COGS, this means a breakdown of individual sales costs as of the report date.



© 2009 Microsoft Corporation. All rights reserved.