Related topics
On this panel you define what type of list to be printed. The stock valuation lists can be printed according to the principles of FIFO (first in first out), item unique costing, the average purchase cost or the standard cost, which you defined in the DIS control file.
It is possible to include internally owned goods on the 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 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.
Sequence
- Item
- Warehouse
- Item group
- Item account group
Note: You can only use sequence 1-3. In addition, you cannot enter a sequence for both Item group and Item account group.
Specification
In the fields below, specify the type of information you want included on the printout.
- List type
- Enter a code indicating the list type to be used for the printout.
Code Description 1 Average cost 2 Standard cost 3 FIFO 4 Accounting rules
- Batch
- This field is only displayed when defining information for the FIFO valuation list. Indicate if the listing shall contain detailed batch information. Note: Batch is only allowed with list type 3 (FIFO).
- Cost per warehouse
- Set this field to YES to use the item cost values defined in the Item file maintenance, Warehouses panel. Set it to NO to use the item cost values defined in the Item file maintenance, Inventory information panel.
Note: This field is only allowed with and applies to list type 1 (Average cost) and 2 (Standard cost). If the list type is 4 (Accounting rules), then the cost per warehouse is always retrieved from the DIS control file.
Stock valuation list printout (DMR60002)
On this panel you select the information to be included in the printout.
Selection
- Item
- Warehouse
- Item group
- Item account group
- Item class
Note: This field is only displayed if DC1 Manufacturing is installed and activated. - Item type
Note: This field is only displayed if DC1 Manufacturing is installed and activated. - Main supplier
- Cost centre
Note: 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.
- Include normal stock
- Indicate if the stock on hand balance for those items contained in the normal stock should be included in the selection.
- Include del not inv
- Indicate if items that have been delivered but not invoiced should be included in the selection.
- Include on IR order
- Indicate if the stock on hand balance for those items contained in the “goods in transfer” stock, (i.e. the pick list has been confirmed for this stock to be delivered to another warehouse on an internal replenishment order), should be included in the selection.
- Include fict item
- This field is only displayed for the average and standard cost valuation list selection panel. Indicate if fictitious items should be included in the selection.
- Include neg stock
- This field is only displayed for the average and standard cost valuation list selection panel. Indicate if the amount for the items with a negative stock on hand should be included in the selection.
- Include zero stock
- This field is only displayed for the average and standard cost valuation list selection panel. Indicate if products with nothing in stock should be included in the selection.
- Include service WIP
- Indicate if items transferred to service WIP should be included in the selection. Note: This field is only displayed if DC1 Service is installed and activated.