Please note – This ONLY applies to Stocktakes that have been updated with the Zero Count. Do not use to reverse a standard stocktake with few errors
If a stock take has been run, and through an error in the selection parameters or another mistake, most of the stock has been zeroised out it may be necessary to reverse out or void the stock take. This will be when no backup is available or it would involve redoing too much work.
You need to do another stock take, dated the same as the last (incorrect one); you will import in a count which is the negative of what was taken out in the first stock take. These figures can be obtained from the PRODAUD records.
So in command mode you find the audit number of the first stock take – say it was 12345.
- Use PRODAUD
- Brow – at the end look for all the stocktake records.
- Copy to stkfix.xls xls for audit = 12345 - to create a spreadsheet of those records
Then in excel you open that stkfix spreadsheet – keep just the two columns CODE and QTY – delete all of the others.
Then make a third column =-b
ie in row 3, c3 will be ‘=-b3’, in row 4 c4will be ‘=-b4’. Then take column c and copy it – use paste special to put it in column d – and just paste the values.
You can now delete columns b and c – that leaves column a as the code, column b as the qty that was removed from stock by the first stock take.
Remove the first row which is headings.
Save that spreadsheet as STKTAKE.CSV – a csv type file
Back in Infusion, (with a new backup done) - create the second stock take – watch the date and the parameter selection are exactly as in the first stock take. In the new stock take you import in the count from the file created above. You can then save the stock take and update it.
This should reverse exactly what came out before.