hi all,
i have 1 purchase order which had multiple purchase receipt, in a report user will input original purchaser order document, and report will list down all related Purch. Rcpt. Line items and their information. so I tried to get all purchase receipt document no, and filter the documents using PurchRcptNoFilter = item ledger entry.document no.
(eg: PR001 | PR002 | PR005 | PR006 = item ledger entry.document no. )
PROBLEM: I tried to use STRSUBSTNO in following way:
PurchRcptHDR.setrange("order no.", POFilter);
IF PurchRcptHDR.FindSET THEN BEGIN
REPEAT
IF PurchRcptNoFilter = '' THEN
PurchRcptNoFilter := PurchRcptHDR."No." + '|'
ELSE
PurchRcptNoFilter := STRSUBSTNO('%1|%2, PurchRcptHDR."No.");
UNTIL PurchRcptHDR.Next=0;
END;
Output :
PR001 || PR002 || PR005 | PR006 ](*,)
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
You need to use 3 parameters if you have two placeholders in the string... %2 is replaced by nothing...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
thanks for replying.. its typo error.. :oops:
i check my code PurchRcptNoFilter := STRSUBSTNO('%1|%2,PurchRcptNoFilter, PurchRcptHDR."No.");
but still i got an error:
NOTE: The double '||' in the error message above is what I actually saw.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n