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.
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 IBS Manufacturing is installed and activated. - Item type
Note: This field is only displayed if IBS Manufacturing is installed and 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 IBS Service is installed and activated.