Supplier Balances & Ageing
  • Nev
    Supplier Balances & Ageing

    by Nev » Fri Feb 23, 2007 4:32 pm

    Strange one:

    Check a Suppliers Balance from the Suppliers Record. (Statistics) and there is only a current and 30 Day Balance.
    Print out the Report 302 Account Balances and there is a neg amount in 90 days Plus.

    Have done a Suppliers Recalc and comes up with a Foreign Exchange error on one Transaction (3 Years old).

    Check the transaction and Payment and all seems correct. Payment and Invoice fully allocated no Balance remaining.
    NO Crossed Links.

    All help and advice appreciated.
    N
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Fri Feb 23, 2007 4:34 pm

    The statistics screen by default shows the account status as of "now" and an account balances report shows the account status as of the end of last month. They are not showing the same aging.

    Let's say you have a $100 payment dated 4 months ago. And an invoice for $100 paid in the current month using that payment.

    If you run the report you'll see -$100 in 90 days because the invoice it pays does not exist as per the cut off date of the report. (The account is technically in credit, if you look only at the transactions up to the end of the last period.) This is something you will see when the date of the payment is put through before the date of the invoice it pays.

Who is online

Users browsing this forum: No registered users and 28 guests