Aged Accounts Receivable in v4.0 sp3 - Not Due

raven44
raven44 Member Posts: 85
edited 2007-03-02 in NAV/Navision Classic Client
Hi,

The Aged Accounts Receivable report in Nav v4.0 sp3 does not specify figures in the Not Due column.

Scenario below:

Posting Date Due Date Amount
01/03/07 02/03/07 10,000.00
01/03/07 30/04/07 100,000.00
01/03/07 01/03/07 1,000.00


Without Fix (By Due Date)
Balance Not Due 1-30 Days
1,000.00 0.00 1,000.00

Without Fix (By Posting Date)
Balance 1-30 Days
111,000.00 111,000.00


Possible Fix:
OpenCustLedgEntry - OnAfterGetRecord()

CASE AgingBy OF
AgingBy::"Due Date":
//>> Insert Temp records for Due Date records (Not Due)
BEGIN
CALCFIELDS("Remaining Amount");
IF "Remaining Amount" = 0 THEN
CurrReport.SKIP;
END;
//<<


TempCustLedgEntryLoop - OnAfterGetRecord()
UNTIL DetailedCustomerLedgerEntry.NEXT = 0;

CustLedgEntryEndingDate.CALCFIELDS("Remaining Amount"); //Obtain Remaining Amount for Due Date records (Not Due)
IF CustLedgEntryEndingDate."Remaining Amount" = 0 THEN
CurrReport.SKIP;


With Fix (By Due Date)
Balance Not Due 1-30 Days
111,000.00 110,000.00 1,000.00

With Fix (By Posting Date)
Balance 1-30 Days
111,000.00 111,000.00

Note: Still need to work on the Totals (LCY)

Does anyone have any comments on the above?
(If you run the v4.0 sp2 report, you get the values as per the fix)

Answers

  • raven44
    raven44 Member Posts: 85
    TempCustLedgEntryLoop - OnAfterGetRecord()
    UNTIL DetailedCustomerLedgerEntry.NEXT = 0;

    CustLedgEntryEndingDate.CALCFIELDS("Remaining Amount"); //Obtain Remaining Amount for Due Date records (Not Due)
    IF CustLedgEntryEndingDate."Remaining Amount" = 0 THEN
    CurrReport.SKIP;

    Dont think this is correct, as the "Remaining Amount" is actually calced above.
    Figured it out.
    Got the report using all columns as it should be in v4.0 sp3.
    New Integer dataitem and some coding.

Categories