I want to show last two order of customer in the report in nav

(1) Share

Report

Posted on by AjayPandey

133

can you please check this code where i do mistake.

/Sales Header/.SETCURRENTKEY(/Document Date/,/Document Type/);
/Sales Header/.SETRANGE(/Document Type/,/Sales Header/./Document Type/::Order);
/Sales Header/.CALCFIELDS(Amount);
/Sales Header/.SETFILTER(Amount,'<>0');
/Sales Header/.SETASCENDING(/Document Date/,TRUE);
LastTransactionCount:=0;
IF /Sales Header/.FIND('-') THEN BEGIN
REPEAT
LastTransactionCount:=LastTransactionCount+1
UNTIL (LastTransactionCount=2) OR (/Sales Header/.NEXT(-1)=0);
END;

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 96,266 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, I have seen similar discussions in the forum, hope the following information can give you some hints.

Dynamics Community Forum Thread Details

Thanks.

ZHU

Was this reply helpful? Yes No