Dynamics NAV - Modify Customer Statement

R116 - Statement
T47 - Aging Band Buffer

• Remove bank info
• Customer balance aging on footer
• Add Invoice numbers
• The posting date should be invoice date 

Add default report options in request page CAL

StartDate := 010105D;

EndDate := TODAY;

IncludeAgingBand := TRUE;

DateChoice := DateChoice::"Posting Date";

Add additional aging bucket and labels

T47 - Add column for additional buckets

Add UseAgingLabels Variable to request page
Add new rows in aging bucket header, show/hide based on UseAgingLabels value

CurrAgingDate := AgingDate[6];

AgingLabel[6] := FORMAT(CurrAgingDate - AgingDate[5]) + ' days';
AgingLabel[5] := FORMAT(CurrAgingDate - AgingDate[4]) + ' days';
AgingLabel[4] := FORMAT(CurrAgingDate - AgingDate[3]) + ' days';
AgingLabel[3] := FORMAT(CurrAgingDate - AgingDate[2]) + ' days';
AgingLabel[2] := FORMAT(CurrAgingDate - AgingDate[1]) + ' days';
AgingLabel[1] := 'Over ' + FORMAT(AgingDate[6] - AgingDate[1]);