Why:
A new report has been created specifically for the Russian Market which has also been made available as a standard report in the base product.
The report is based on the Transaction History file (THF102) and is designed to provide a list of transactions for the selected criteria with an opening and closing balance of each parts and for the report as a whole.
From the Part View, select Parts > Reports > Stock Balance report.
How to Report on Stock Balance:
The report is security controlled and a new security item under Parts reports has been added. This is set to a default of Negative. The selection criteria include Branch selection, Part prefix, Part number Range from and to Or, Product code AND Date Range.
The report will also review archived data if selected.
The opening balance for each part will display the closing balance of the last transaction before the date range selected or if no date range is selected the oldest record on the file. The closing balance is the on hand quantity multiplied by the new average cost for the last transaction reported
The report also has two totals reported at the end of the report, Opening Balance and Closing Balance.
The Opening Balance is a total of all the opening balances and costs reported.
The Closing Balance is a total of all the closing balances and costs reported.
The report will list all transactions for the selection criteria irrespective of the effect on stock
The columns printed are defined as follows:
Column Name |
Purpose / Description |
Date |
Date of transaction movement |
Transaction Reference |
Transaction Analysis Code followed by the transaction description |
Reference |
This will vary according to the transaction type but will take the data from one of the following fields in the transaction history file; Miscellaneous Values, Order number, Invoice number and stock movement number. |
Vendor |
Supplier / Customer number this is dependant on transaction type. |
Quantity Before |
Calculation of the Effect on the Transaction Qty or + Stock Balance after. |
Operation Cost |
Calculation of Quantity before multiplied by the Cost. |
Operation Qty |
Movement Quantity for this transaction DXTRQY |
Cost Total |
Stock Balance after multiplied by the transaction cost. |
Balance after |
Stock Balance after transaction. |
Average cost |
New Average cost after transaction |