Skip to main content

Notifications

Announcements

No record found.

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:
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,006 User Group Leader on at
    RE: Fields to my report

    Are you working on AX, you mentioned AOT.

    This is dynamics GP forum.

  • Robyng Profile Picture
    Robyng 70 on at
    RE: Fields to my report

    I'm using visual studio

  • Suggested answer
    Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: Fields to my report

    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
    Robyng 70 on at
    RE: Fields to my report

    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

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Fields to my report

    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 ?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans