Option to consolidate stock transactions
Make sure there is a backup of the current board library before using this report
Do not use this report if other users are currently using the software
This option removes the stock transactions and adjusts the stock total for each stock item to a new 'Opening balance'.
At the main screen:-
● Select: Stock - End of month / Year
The program warns that viewing this report removes the Audit trail (stock transactions)
Select the option you wish to use for your stock audit
If this option for stock boards and offcuts is selected, any offcuts in the board library are assigned an opening balance in the audit trail.
If the audit trail is off the program prompts:-
'There is no audit trail for current period'
(Not using transactions reduces the size of the material library file and may allow those stock operations which change many board records to complete in less time e.g 'Update stock from runs').
● Select: OK to confirm
or
● Select: Cancel to abandon the report
On selecting OK the current transactions are LOST
The 'End of Month / Year' report is displayed.
The report shows the stock transactions (before consolidation) - but note the consolidation has already taken place and cannot be cancelled at this point.
● Take a Print of the report so that there is a physical record of the stock transactions for the period.
The result is a set of new opening balances for all stock items.
Options
There are menu options to set up the printer and page. The other options are:-
File - Print - print report
File - Exit - close report
View - Toolbar - show or hide the toolbar
Notes
- Before compacting the file the program checks that the quantities of each board in the board library match the quantity calculated from the transactions for that board in the audit file. If the figures do not match a correction is added to the audit file so that the board quantity in the audit file matches the quantity in the board library.
The following rules are also observed when the audit is maintained for offcuts.
- Issue stock no longer deletes offcuts from the board library when their stock quantity is used up.
- Offcuts with zero quantity are deleted from the board library by the month/year end procedure.
- The Audit trail (stock transactions) are stored in the Board library (Access MDB table).
- The Board library can also be compacted (reduced in size) via File Management
- This report removes transaction records and compacts the Board library - it is useful to run this report on a regular basis to keep the Board library to a reasonable size.
