Statement of accounts not in balance

  • steggur

    I have 2 years 2006 and 2007 defined in Compiere.
    When I run Statement of Accounts in Financial Reporting with fields Accounting Schema: HABS Posting Type Actual and Organization: Morkin 6, all other fields blank. Update balances selected.
    When the report shows with these selections account credit is 248868 lower and debit/credit not in balance.
    IF I do the same run but only selecting Account Date January 1 2006 to December 31 2007, everything balanaces out.

    Also when I run the Balance sheet in Financial Report selecting it to list sources it gives a balance of 248868 on account 21100.
    Then when I go to the account viewer it gives a balance of 0.

    If I do Statement of accounts on account 21100 it gives a balance of 248868.
    Then if I do the same thing using dates Jan 1 2006 to Dec 31 2007 the account balances out as in the account viewer.

    Using Compiere 2.6.1

    Any suggestion how we can get this to work correctly?

    • Kathy Pink
      Kathy Pink

      I would validate the balances by running the accounting fact balances report.