web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Fields to my report

(0) ShareShare
ReportReport
Posted on by 70

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. 

Received-QTY-_2800_002_2900_.PNG

Categories:
I have the same question (0)
  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,061 Moderator on at

    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 ?

  • Robyng Profile Picture
    70 on at

    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.

    missing.PNG

  • Suggested answer
    Nicole Hellerud Profile Picture
    1,712 on at

    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.

    Purchase-Order-Status-Report-Builder.PNG

    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

  • Robyng Profile Picture
    70 on at

    I'm using visual studio

  • Suggested answer
    Almas Mahfooz Profile Picture
    11,009 User Group Leader on at

    Are you working on AX, you mentioned AOT.

    This is dynamics GP forum.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 681 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 598 Super User 2026 Season 1

#3
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 579

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans