I am using Simply Accounting by Sage Premium (Version 2010 Release D Update). Recently I tried to run a general ledger report of our inventory account (by selecting Report-->Financials-->General Ledger). But the current balance changes significantly depending on what I select as the start date in the General Ledger (see attached screen shots). If I select Feb 17 or earlier for starting date, and choose the current date as ending date, the general ledger will show the correct balance ( about $463K), but if I choose a day after Feb 17 as starting date, it will show as $803k. Does anyone have any idea why this is happening? Thank you very much. I believe our real inventory level is at about 463K.
By the way, the “Chart of Accounts” shows the inventory balance as about $803k, which is wrong. However, the “Inventory Summary” shows the balance as $490k which is almost right.
Any help would be appreciated.