Produce a periodical stock valuation report

Related topics

The periodical stock valuation process provides functionality through the Inventory transaction enquiry for an accurate reconciliation between Distribution and Financials. All stock events that are generated in Distribution that affect the stock value but not the stock quantity, such as item cost changes, are logged in the Inventory transaction file. The transactions are retrieved per accounting period and updated in the transaction balances. The stock balances are stored in the balance files in the Business Information Warehouse (BIW).

Note: Differences may appear between Distribution and Financials in the stock valuation if the Currency table is set up with different number of decimals for amount and cost respectively.

See Stock valuation – technical description for a detailed technical description of the process.

The following describes how to produce and print a periodic stock valuation report for a specified accounting period listing the opening balances, net change details and closing balances for the period for both stock value and quantity.

Do as follows:

Select the Periodical stock valuation printout menu item.
On the initial panel, you define the sequence and selection parameters. Complete the following fields:

Sequence
Leave the defaulted sequential and sub-total definitions to print the report in item within warehouse sequence and to include sub-totals.

Selection
Complete the following fields:

Period: Enter a period.
Item group: Enter an item group, single value 1.
Stock acc trans typ: Enter a transaction type, single value 1. The stock account transaction type defines the type of stock that you are analysing, for example:

Specification

Print details: Set this field to YES to include inventory transaction details for the selected period in the printout.

Leave the remaining fields as defaulted.

Click OK. You will be prompted to enter your print details. Click OK to print the report.