Need Aging Report in Navision BA client

kumartnav
kumartnav Member Posts: 3
edited 2012-02-03 in NAV/Navision Classic Client
Where should I write a code in NAVISION BA client and how to declare variables to display calulated values?

Ex; Creation of Customer Aging reports in NAVISION BA client.

How to create a variable in BA to enter "As on Date".
Based on "As on Date" and "Due Date" report should display the invoice amount in columns " '1-30', '30-60', '60-90', '>90' ".

Regards,
Kumar

Comments

  • dheerajnavisionwala
    dheerajnavisionwala Member Posts: 1
    Try to user the arraya.

    sample code is below


    IF UseCustomLength THEN // with All Defined Periods
    BEGIN
    PeriodEndDate[1] := EndingDate;
    PeriodStartDate[1] := EndingDate - PerLength1;
    PeriodEndDate[2] := PeriodStartDate[1] - 1;
    PeriodStartDate[2] := PeriodEndDate[2] - PerLength2;
    PeriodEndDate[3] := PeriodStartDate[2] - 1;

    Dheeraj
  • kumartnav
    kumartnav Member Posts: 3
    Hi Dheeraaj,

    Is it possible to write a code in NAVISION Business Analytics Client?

    Regards,
    Kumar

Categories