stock value adjustment

Leanne_6969527
Leanne_6969527 Member Posts: 5 Reckoner Reckoner

Stock value adjustments

We commenced a new clean data file for a small community supermarket store as at 1/7/14. We imported the stock but then learnt that the SOH does not get brought across. The stocktake taken (stock on hand) as at 30/6/14, has been manually entered into a new data file, however for some reason the values do not agree. something was amiss with a couple of average prices. We tried to then do a stock value adjustment whereby we manually compared the stock valuation report from 30/6/14 in old data file to stock valuation report as at 30/6/14 in new file and then entered the correct values where applicable into new data file as at 30/6/14, without adjusting the on hand stock. Then a stock valuation report was printed as at 30/6/14 and the "stock values" did not match. Can you advise if the adjustment is a straight dollar replacement as we have done? If so any clues as to why the values might not agree?

Comments

  • Graham Boast
    Graham Boast Accredited Partner Posts: 331 Accredited Partner Accredited Partner
    edited December 2017
    Hi Leanne

    It may be that some items that where on-hand at 30/6/14 have since been made inactive.  Reckon Accounts inexplicably (and incorrectly) does not include Inactive items in the Inventory Valuation Summary Report.  Are there any items you had on hand at 30/6/14 that are now inactive?  You will need to make these active again so the 30/6/14 report reflects their value.

    My approach to this whole job would be to generate this report and export to excel in both the old file and the new file, then use excel to do the hard work for you to identify which products have changed qty and/or values.  If you haven't got the expertise to do this, I can do it for you on a fee for service basis.  It's only a couple of hours work involved, but it could save you hours and hours work if you have a few thousand items.

    Graham Boast
    Reckon Accredited Consultant
    graham@reckonhelp.com.au
    www.reckonhelp.com.au/remotesupport.htm





    Graham Boast | 0409 317366 | graham@reckonhelp.com.au

This discussion has been closed.