Export a last 6 months records.

Jacob1227

Hi All,
I have created a Dataport with 'Cust. Ledger Entry'.I want to export the last 6-month invoice records.
Can you please suggest me some code to retrieve last 6 months records.

Thanks in advance,
Jacob A.

TallyHo

OnPreDataItem()
setrange("Entry Type",Entry Type::sale);
setrange("Source Type",Source Type"::customer);
setrange("Posting Date",calcdate('<-6M>',WORKDATE),WORKDATE);

Or use the "Document Date" for date filtering.
If you mean the last six months invoice records created, this is only possible if you add
a creation date to the table.

TallyHo

OnPreDataItem()
setrange("Entry Type",Entry Type::sale);
setrange("Source Type",Source Type"::customer);
setrange("Posting Date",calcdate('<-6M>',WORKDATE),WORKDATE);

Or use the "Document Date" for date filtering.
If you mean the last six months invoice records created, this is only possible if you add
a creation date to the table.

Jacob1227

Thanks, TallyHo ... Big Smile.

TallyHo

You're welcome