Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Show ReceiveNow Field From PurchPArmLine Table In Report AX 2012

Posted on by 95

Hi experts,

I am Creating Purchase Status Report in which I have used 2 tables "PurchTable", "Purchline" 

But I want to Show Two More  fields From table  "PurchParmLine"  (ReceiveNow, RemainAfterInvent) How to get Data From this Table in this report 

I am using AX 2012 

Please guide me 

  • Suggested answer
    Austin Shen Profile Picture
    Austin Shen on at
    RE: Show ReceiveNow Field From PurchPArmLine Table In Report AX 2012

    Hi AXx,

    Purchase order line table has a method to get its received quantity, also a separate field called delivery remainder for remaining quantity. Generally, you could check the implementation of Line quantity of purchase order to check how you may get details of a purchase order line. Thank you.

    Best Regards,

    Austin Shen

  • Martin Dráb Profile Picture
    Martin Dráb 225,610 Super User on at
    RE: Show ReceiveNow Field From PurchPArmLine Table In Report AX 2012

    When you receive items, the change is tracked in InventTrans table.

    Regarding remaining quantity, don't you already have the right value in RemainPurchPhysical on PurchLine?

  • AXx Profile Picture
    AXx 95 on at
    RE: Show ReceiveNow Field From PurchPArmLine Table In Report AX 2012

    I want to show Received and remaining quantity after purchase order receiving , where can i get these fields ??

  • Martin Dráb Profile Picture
    Martin Dráb 225,610 Super User on at
    RE: Show ReceiveNow Field From PurchPArmLine Table In Report AX 2012

    Why? A PurchParmLine record serves merely as input parameter for posting - it doesn't exist before opening a posting dialog and can be deleted when posting is done. You should rather take data from journals created by posting (confirmation, invoice etc.).

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,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans