How to get Purchase Order list vendor wise

(0) Share

Report

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)

All responses (7)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report

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

Was this reply helpful? Yes No