Related topics
- About analysing inventory transactions
- About DC1 Contract Managed Inventory (CMI)
- About the stock ownership functionality
On this panel you enter the sequencing and selection criteria that you wish to use to produce a stock valuation report for a defined period. (See Produce a periodical stock valuation report for more information).
It is possible to include internally owned goods on the periodical stock valuation list, which is controlled by the warehouse set-up. Warehouses, defined with the following warehouse characteristic codes, are applicable for internally owned goods:
Warehouse characteristic | Definition |
---|---|
1 | Normal warehouse |
2 | Trade warehouse |
3 | Wholesaler Consignment Stock (WCS) |
4 | Wholesaler Deposit Stock (WDS) |
The possibility also exists to make a selection by owner (i.e. Cost centre) for the periodical stock valuation for internal owners. This is applicable if the STKOWNER (Stock Ownership) function is activated in the Function control file, and cost centre account part (in DC1 Financials) is activated. When selection is made by cost centre (internal stock), only the warehouses with the selected cost centres, and/or cost centre defined on Wholesaler Consignment Stock (WCS) and Wholesaler Deposit Stock (WDS) inventory contracts for internally owned stock (if the DC1 Contract Managed Inventory (CMI) application is activated and those types of contracts have been set up in your system) are included in the selection for printout.
This report displays opening and closing balances for quantity and amount together with the net change details. The stock account transaction type that you enter defines the type of stock you want to analyse (see Stock valuation – technical description for more information).
Sequence
At least one of the sequencing fields must be selected.
- Item
- Warehouse
- Item group
- Item account group
- Stock acc trans typ
Note: The system defaults 1 and 2 to sequence the values for Warehouse first and for Item second, but can be changed.
- Sub-total
- This field is mandatory for each of the sequence records. This field is set to YES by default for Item and Warehouse, but can be changed.
- Page break
- This field is mandatory for each of the sequence records.
Selection
- Period
Only one accounting period can be selected. - Item
- Warehouse
- Item group
- Item account group
- Stock acc trans typ
Only transaction types with the Stock account field set to YES in the Transaction type table will be included in the list. For this parameter, only the single value 1 is allowed in the first single character selection field. - Cost centre
This field is only displayed if the STKOWNER (Stock Ownership) function is activated in the Function control file and cost centre account part (in DC1 Financials) is activated. It is applicable for internally owned stock in your physical warehouse. Make a cost centre(s) selection if you want to perform a periodical stock valuation of internally owned goods by cost centre.
Specification
Enter, in the fields below, detailed information about the printout.
- Print details
- Indicate if inventory transaction details for the selected period should be included in the printout.
- Incl zero balances
- Indicate if items with zero balances and no transactions during the period should be included in the printout.