Announcements
No record found.
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
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.).
I want to show Received and remaining quantity after purchase order receiving , where can i get these fields ??
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?
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 521 Super User 2026 Season 1
Giorgio Bonacorsi 438
Adis 261 Super User 2026 Season 1