1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Periodical stock valuation printout...

Periodical stock valuation printout (DMR63501)

Related topics

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 codes

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.