Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

In Purchase Agreement, Where Can I See The Received Lines of The Released Lines?

Posted on by 847

Hello awesome community! :)

In Purchase Agreements, What I want is similar to view the "Released Order Lines" of the purchase agreement.

For example, in this screen: 

18734.Capture.PNG

It views the Released Lines of The Purchase Agreement, what I want is to view the "Received Lines" of these released lines.

Because I want to display in an SSRS report the number of Received Lines.

I already did it for the "Release Lines" by getting the count() number of records in "PurchLine" Table where The PurchLine.MatchingAgreementLine == AgreementLine.RecId.

I'm just a beginner but I noticed that release lines are inserted in PurchLine Table, but what about Received Lines?

Thanks in advance!

  • Suggested answer
    Momochi Profile Picture
    Momochi 847 on at
    RE: In Purchase Agreement, Where Can I See The Received Lines of The Released Lines?

    I've done it using a counter with this condition:

    Counter receivedCounter = 0;
    while select purchLi where purchLi.MatchingAgreementLine == agreementLi.RecId && purchLi.ItemId == agreementLi.ItemId{ if(purchLi.invoicedInTotal() - purchLi.receivedInTotal() == 0){ receivedCounter++; } } reportLine.Received = receivedCounter;

    And the results are fine for now, I still need to test it more since I'm not sure, because I used "PurchLine.invoicedInTotal() - PurchLine.receivedInTotal()"

    Don't know how accurate is that. Once I confirm I will reply here.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans