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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to get Purchase Or...
Microsoft Dynamics AX (Archived)

How to get Purchase Order list vendor wise

(0) ShareShare
ReportReport
Posted on by Safeer PS 507

Hi All,

I believe I can get majority of data from PurchLine Table and using Table browser I can make the report. But my doubt is does the Line Amount column in purchline Table include charges ( Frieght, other,Vendor Charges,Discount).

Does Sum(Line Amount ) will give me the Total PO Amount ???

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,443 Super User 2026 Season 1 on at

    Hi Safeer,

    The Line amount is excluding the charges. To get charges, you also need to get data from the MarkupTrans table.

    The sum of the line amount is also not including the charges.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,679 Super User 2026 Season 1 on at

    Using PurchTotals (class) can be useful to get such amounts, as it brings results how ax is supposed to do, as compared to doing manual select sum(field)

  • Safeer PS Profile Picture
    Safeer PS 507 on at

    Can any one guide me on how to create that report.

    If I create a query with join of two tables and create a report on that query will it work OR

    is there any class or method that can directly give my required result.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,679 Super User 2026 Season 1 on at

    If your original question was about Report development, you should had motioned it clearly.

    Kindly create a new thread ad report development is different topic, as compared to subject of this thread.

  • Safeer PS Profile Picture
    Safeer PS 507 on at

    I am amazed to see that for a simple requirement How complex the development work is . Any simple way to get the PO list vendors wise with total amount  

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Since we are now talking about SSRS development for your requirements to answer your question: yes you need to develop in AX and/or in Visual Studio to get it done. The first one is simpler to do, in the AX Data Provider class of your SSRS report you could calculate the total amount using the above mentioned PurchTotals class to include markup, and save it to the temp table that the reporting datasource will be based on.

    As for your comment on the work, that is the reason why there is a high demand for good AX developers, but that is the case with any other ERP systems as well.

  • Safeer PS Profile Picture
    Safeer PS 507 on at

    I can get if from Procurement && Sourcing >> Purchase Register right ??

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans