Microsoft Dynamics AX (Archived)

Print Report History Purchase Quantity and Price in a year

(0) Share

Report

Posted on by benjamin84

2,075

Dear All,

I want to print report history oh my PO within 1 year,

I just need item key, name, quantity and prices.

does anyone know the location of the report,

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

benjamin84 2,075 on at

Like (0)

Report
Copy link

Link copied!

I can get data from purchase order lines and personalize its for price.

but user want to get it from report.

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (1)

Report
Copy link

Link copied!

Hi benjamin84

There are reports available within the Procurement and sourcing module that will give this information as well. If you navigate to Procurement and sourcing > Reports > Statistics > Vendor,

Item/Vendor statistics

Vendor/Item statistics

you can use this report also

Inventory management > Reports > Reports (China) > Item purchase history analysis.

but you must remove country code from AOT / menu items / outpout / InventItemPurchaseAnalysis_CN to show this report in your system

***also you can use this form ***

Product information management > Common > Released products

and set filter on item

1-Period Statistics

you can see a very basic summary

2-Transactions

You can filter by Reference > Purchase order, and you can also sort by date range. You can also always click Ctrl + t to export to Excel and manipulate your data there as well

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report
Copy link

Link copied!

Hi Mahmoud Hakim,

Thanks, yes its what user want.

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report
Copy link

Link copied!

Hi Mahmoud,

Sorry, turn out that its not what user want.

User doesn't told me the whole about her requirement.

i need to get data from form or report, column/field I need is Itemkey, product name/description, qty, price, no po dan po date

Thanks

Was this reply helpful? Yes No