Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Looping through Purcha...

Looping through Purchase line table

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am trying to loop through my purchase lines and want to add up the values in a field called Received Not Invoiced and put that figure into a variable called RecNotInv.

 IF PurchaseLine.FINDSET THEN
    REPEAT
      ReceivedNotInvoiced
    UNTIL PurchaseLine.NEXT = 0;
  MESSAGE('My Received Not Invoiced Amount is %1.',ReceivedNotInvoiced.COUNT);


Thanks!

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Amol Salvi 18,694 on at

Like (1)

Report

RE: Looping through Purchase line table

IF PurchaseLine.FINDSET THEN
    REPEAT
      ReceivedNotInvoiced+=PurchaseLine."Received Not Invoiced";
    UNTIL PurchaseLine.NEXT = 0;