To change from a stock method to Period Average, the below steps must be followed to ensure a successful migration:
Pre-requisites:
Close Stock Period for the month you have just finished processing.
Change the Control Parameter Stock Cost method to Period Average method at the beginning of the new month before processing new stock transactions.
In summary, the unit costs and quantities for the last period must be reviewed, and updated if necessary, so that they can be used as the starting position for the new period. There is a utility to export this list, and a data import to import this revised file and be processed.
The process should be as follows:
Export stock item list to verify starting position:
Use the Utility Stock By Period Export to export the list of stock items to facilitate the reviewing of quantities on hand, and average unit cost per period/location/item.
This will export the data for the last closed period only.
May need a stock take to verify quantities. This is up to each client. If a stocktake is to be done, the last Closed Stock period must be reopened, process Stocktake, and closed again. This will ensure that the exported list to be revised includes the right quantities (which are coming from the Stocktake adjustments).Import Period Initialisation:
Review export (quantities and average on each item per location).
Use Stock By Period Reinitialisation data import as a starting point for the new Stock period that is about to start with the new stock method.
The format of the file exported is compatible with this import, so the file can be easily imported.It is important that you have changed the Control Parameter Stock Cost method to Period Average before the import is done to get the correct stock value in the StockByPeriod table.
Notes:
This import is designed to overwrite the last closed stock period, to get the right initialisation values.
The user must define what Year/Period this will be overwriting, which must be the last processed period.
The import executes the utility wbUpdateAllStockCosts to update all Average/Last stock values on ALL items.
Optional step:
Manually run utility wbRepriceTransactions to recost unexported STock issues in case any have been created for the new period.