Inventory: Parts Stock Valuation Reports

Parts Stock Valuation Reports

Reference Contents > Inventory > Parts Stock Valuation Reports

This report setup window provides you with the ability to choose a range of selections, sort order and report types.

You can drag and drop onto the Print Report button from the Parts ScratchPad to obtain a report of selected parts only.

NOTE: This window contains fields introduced with version 5 that enable additional search (and sometimes sort controls), such as Adhoc extra where. For more help on their use and examples see the Client-Server SQL Introduction help.

Valuation reports of Parts in stock and kitted (WIP) can be produced either based on CURRENT COST or STANDARD COST. In addition, you can obtain a report on Outwork material issued to suppliers, a valuation of Quarantine stock and a full Work-in-process valuation.

Physical

Provides valuation of Physical quantity and Kitted in WIP and provides for all of the checkbox options. The report will mark any errors (zero costs and negative stock or WIP) and will provide a breakdown of total components of cost valuation.

The report normally will exclude items with both zero physical and zero Kitted WIP quantities. However, you may check the Include zero quantity parts checkbox if desired.

There is an option to add subtotals at each change of the selected sort field. Use the Show subtotals on sort field checkbox to effect this option, however, it is not available for the Part number sort option.

Outwork

Provides for the valuation of the items issued to suppliers to process outwork assemblies. The only option available is to limit the valuation to the Material cost element only.

Quarantined

Provides for the valuation of the items stored in multi-locations designated as Quarantined. The only option available is to limit the valuation to the Material cost element only.

Work-in-Process

This provides a current real Work-in-Process valuation. No options are available. All costs are as applied at the time of Work Order kitting or logging actual hours to the Work Order. If no actual hours are recorded, Process Route times are applied where history is logged. Kit Materials costs applied to the Work Order includes bulk items but not Shortages. Backflushed Work Orders do not include any kit material costs as they remain in stock. Costs of completed partial batches received into stock from Work Orders are not included.

Bonded SO Items

Provides for the valuation of Sales Order items that have been Bonded. Remember that such items will have been removed from physical stock but will not have been dispatched, and therefore invoiced, to customers. These items are, in accountancy terms, still in the company’s inventory and should be valued at cost, rather than Sales Order price. The only report option available is to limit the valuation to the Material cost element only. The report is always sorted by Part Number.

NOTE: The valuation report of Bonded items will include any ‘N’on-stock type part items but will not include any non-part SO items.

Select from one of the two radio buttons at the bottom to use either Standard or Current costs for the valuation.

NOTE: N-type Non-stock parts are always omitted from the above reports.

Compiled in Program Version 5.10. Help data last modified 3 Jan 2015 10:46:00.00. Class wValuePrint last modified 17 Oct 2017 04:29:57.

Reference Contents > Inventory > Parts Stock Valuation Reports