Aged Accounts Receivable

CindyPret

Is there any documentation explaining why the Aged Accounts Receivable balance will not be the same as the General Ledger balance for Debtors control. I do know that the application of payments does influence this balances.

Carol_Cintron

Typically the reason for this is direct journal postings to the A/R Account. Search for G/L Entries to A/R Accounts with source GENJNL.

AdamRoue

Also check you are comparing like for like date periods.

themave

there is a bug in the report, at least in my 4.0 version and earlier,

if you run it on the month end (actual day) everything will match, if a few weeks later you run it using the prior month end date, it will be different.

the fix for me was to edit the report 10040 Aged Accounts receivable

Data item
Cust.ledgerEntry

DataItemTableView

SORTING(Customer No.,Open,Positive,Due Date,Currency Code) WHERE(Open=CONST(Yes))

remove the Open=CONST(Yes)

The report runs much much much slower but it is accurate

Here is my g/l balance for A/R 3/31/08 $463,120.90

running the standard navision report as of date 3/31/08 $462,935.68

if I make the change above and run the same report again with an
as of date 3/31/08 $463120.90

these two reports give different results, the second with my change gives the correct results, the first standard navision report does not.

My guess is it has something to do with unappling a payment in a prior period, and the standand navision report not being able to handle that.