Need Aging Report in Navision BA client

kumartnav

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

dheerajnavisionwala

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

Hi Dheeraaj,

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

Regards,
Kumar