Hi, our company recently upgraded from GP 10.0 to GP 2015. Everything went smooth, we thought, until we tried to balance our Inventory Valuation report to our Inventory account.
- The bottom line of the inventory valuation (including discontinued items) is out from the inventory GL account by over $2,000! We are aware of a few different ways this can occur, but can't narrow it down to anything specific. We balanced March 31st after a small adjustment (we always have to adjust to balance), then did this upgrade 3 months later. We do not sell products, we issue them out to be used in the building. We have less than 1000 stock items, none of very high value. We are trying to figure out if we need to change our valuation method (we use FIFO Periodic) or if it's the price method (most items are % Markup-Standard Cost, but a handful of them are Currency Amount) or something completely unrelated?
- While trying to balance to the inventory GL account we noticed that we have many items with negative amounts on hand - our system does not allow this, and it looks as if some of the negative quantities began in 2012, which also isn't possible. We think the Units of Measure might have somehow been transferred incorrectly during the upgrade. Has anyone heard of this happening? The values of items negative quantities do not add up to the difference between the Inventory Valuation and Inventory GL account.
- Is there a better report to use when balancing to the GL or is it our valuation or price method that makes it so that we never balance?
*This post is locked for comments
I have the same question (0)
