I have some weirdness going on at a client site with their Inventory Trial Balance. The last couple months we have been off by about $140k per month from G/L Inventory Account to the Inventory Trial balance. In digging in I see that the ending balance of January's inventory trial balance report is about $140k off from the beginning balance of February's inventory trial balance report. Shouldn't these reports tie from ending prior month to beginning of current month? This is my discrepancy but what in the heck would be causing this? It is giving their CPA and I fits over the last few months. They are using FIFO inventory and are on MAS 4.4.0.6. Any ideas? It is like their inventory on the trial balance is growing $140k higher than the G/L the last couple months. I even checked for and G/L adjustments done directly to the inventory G/L account and there were none.
Thanks in advance.