Notifications
Announcements
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 836 Super User 2025 Season 2
André Arnaud de Cal... 452 Super User 2025 Season 2
Martin Dráb 349 Most Valuable Professional