I have taken over a system set up by someone else. It is a small bar. They use AccuPos as their POS. The flaw in the way things were setup is that the UOM are all screwed up which results in things like -1.24mil being in a draught beer item. I have uncovered the issue and have created all new inventory and service items to work with the accupos system. where I am stumped is how to deal with all the erroneous inventory currently in the system. For the time being I have simple started putting all the bogus inventory into an adjustment writeoff account and then am planning on trying to post it into the proper places as I know that not everything will make sense. One issue is that not only are the numbers jacked but in some instances it is almost impossible to tell how much of something was actually taken.
We are using the following accounts for beer as an example:
Asset - 1550 inventory
Rev - 4020 sales
COGS - 5010 purchases
Var - 5011 adjustments
the 1550 numbers are kind of okay as she was entering them as a keg and the price was per keg. The sales numbers are okay as the "price" was put in correctly and accupos was posting the proper sales. It is the 5010 account where it seems the issue is. It will say $24,000 in beer was sold. It seems that since it was setup so that it was a 1-1 ratio on Buy/Stock/Sell and AccuPos was told to take out 14 units from inventory that it was taking 14 kegs per beer. I am just trying to figure out the simplest and cleanest way of clearing this up. So far we figure we just need to clear out everything and pick a new starting date for inventory and largely ignore everything up to now. This started in April of 2017, so it is not worth trying to unravel this all and fix it properly.