Hey I need to add the received Qty to my report which AOT field can I get that from or which EXPR would work for that. I doing a PurchPurchaseOrder report.
Hey I need to add the received Qty to my report which AOT field can I get that from or which EXPR would work for that. I doing a PurchPurchaseOrder report.
Are you working on AX, you mentioned AOT.
This is dynamics GP forum.
I'm using visual studio
Hey Robyng,
Thank you for your post!
Which SSRS report are you leveraging and which build of GP/SQL?
When reviewing my GP 2018 18.2 build I do not see a report called PurchPurchaseOrder report.
I do see Purchase Order History and Purchase Order Status, where either of these the ones you were leveraging?
Either way...
You'll need to open the report via Report Builder and then within Report Builder you should see the Datasets on the left Report Data section.
You can right click and go to Dataset Properties and within there under the Fields menu add more fields.
This is a very high level guidance, but hopefully it's enough to get you going.
Please reply either letting us know if you have further questions or whether the information offered has answered your question.
Wishing you a splendid rest of your day!
Nicole Fiskum
ssrs report it's a PO purchase order.I need to know what I'm looking for in the AOT ( data model ) to pull those fields to add to my tale extensions. I need fields for buyer, FOB, and Shipvia.
Hi Robyn,
Sorry if I can't see the exact details.. what kind of report is this ? SSRS ? Word Template ? Excel ?
What is the underlying data source you're using ?
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,403
Most Valuable Professional
nmaenpaa
101,156