Community Forum Portal/Portail du forum communautaire
I'm trying to do an inventory adjustment on a grain code. In the GL it's listed currently as 126 tons and $32000 of value, but when I open up the inventory adjustment tab it changes to 91 tons and $23000 of value (unit value stays the same).
I've looked at a few other grain codes and they all match, it's just this one that doesn't.
Any idea what I might be doing wrong?
Hi Ashley, the inventory adjustment tab is always the quantity and value of the inventory on hand as of now. The GL report can be generated for historical dates so can have any quantity or value that existed at any point in history. My guess is that there is a sale posted after the date for which the GL report is being generated. It makes adjusting historical inventory values tricky via the Value adjustment tab. So for me, when I'm adjusting something historical, like say I wanted the 126 tones valued at $30K instead of $32K I would do a general journal adjustment to credit the account by the $2,000 and leave the quantity blank. Offset that by debiting the grain inventory adjustment account (it will be a 4000 account, likely in the 4900's somewhere). Once you've done that, it will affect your "Now" unit value so you may want to at that point go into the Adjust Value tab in the inventory adjustment window and correct your unit value there if you want to make sure your grain inventory asset is valued correctly for the current day.