It is important to understand some of the table structures.
To access valuation reports from previous months there is a special table that holds period end data. Once the period is closed this data cannot be amended.
This table is updated by :-
- Running Stock Valuation reports. (wbStock0200; 0210; 0220). Every time you run the one of these reports the table is updated until the period is closed.
- Closing the period to data in the Period Ends Table.
Answering no means that the table is not updated consequently period end values will not be available. Recommended to answer Yes.
Job Transaction and Stock Adjustment tables hold transactional data.
Inwadrs Goods table holds Stock Receipts.
The Stock Quantities table holds the current Quantity.
The Items table holds the unit cost rates.
Accurate Cut offs are required whether it is just a Month End or whether a Stocktake is included.
Process transactional data up to month end or Stocktake |
|
Run Prepare for Stocktake. This takes a snapshot of quantities and the cost rates applicable at that date. This will allow you to print Stocktake Count Sheets. |
|
Count the Stock |
|
Process transactional data up to cut off. |
|
Run Prepare for Stocktake again for Existing stock where transactional data relating to the preceding period has been processed after original Prepare for Stocktake. |
|
Enter Stocktake Counts |
|
Print Stocktake variance reports |
|
Generate Stock Counts Adjustments. This adjustment batch created adjusts the stock to the counted figures and any value adjustment will be at the snapshot rate per the valuation method. |
|
Create any other adjustments necessary. |
|
Run any Month End stock reports required |
|
Close Period Flag for Stock. |
|
...