Statement (Report 116) Aging By Document Date

julkifli33

Hi all..
NAV Standard report 116 (Statement) have aging band by Due date & Posting Date
can we add by Document Date?
please advice how to do that
thanks

mohana_cse06

1) add Document date option to DateChoice global variable

2) Add new parameter document date in function

GetDate(PostingDate : Date;DueDate : Date) : Date

and Change code to

IF DateChoice = DateChoice::"Posting Date" THEN
  EXIT(PostingDate)
ELSE
  IF DateChoice = DateChoice::"Due Date" THEN 
    EXIT(DueDate)
  ELSE
    EXIT(DocumentDate);

3) in CustLedgEntry2 - OnAfterGetRecord() Change the below code to

UpdateBuffer(Currency2.Code,GetDate("Posting Date","Due Date"),"Remaining Amount");

UpdateBuffer(Currency2.Code,GetDate("Posting Date","Due Date","Document Date"),"Remaining Amount");

julkifli33

Thanks
but the datechoice must have 3rd parameter is it?
because i have error message saying the current value is 3
the permitted range is 1 until 2
thanks

mohana_cse06

mohana_cse06 wrote:

1) add Document date option to DateChoice global variable

Add it in requeest form Datechoice OptionCaption also.

julkifli33

mohana_cse06 wrote:

mohana_cse06 wrote:

1) add Document date option to DateChoice global variable

Add it in requeest form Datechoice OptionCaption also.

for this one i already added previously
but when i want to preview, it will prompt me an error like i said before

mohana_cse06

Check with debugger..where you are getting error

julkifli33

i found it
beside global variable
we should add document date at text013

Name ConstValue
Text013 Due Date,Posting Date,Document Date

Thanks