Month End Procedures

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
Inwards Goods processes receipts up till stock take.
Job Purchase Invoices process average and last Cost values. (Note that processing a Job Purchase Invoice where the goods have not been receipted will automatically process the Job Receipt where it is a Stock Job). .
Stock Issues
Stock Adjustments

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.