In Dynamics AX, after PO issuance to the supplier, we will be receiving the materials which will be entered through the “Receive” tab. I request the support from group, to generate the report of all the product receipts for a specific period. Say for the last month. Thanks Sunil
You can use purchase receiving log report under procurement and sourcing _> reports → Transactions.
This report is country specific and currently available for USA and Canada. Developers can change it, so that it will be available for other countries as well.
Thanks Kranthi for the response. This feature is not available in our version. As mentioned, I will be asking the developer.
Sunil
BTW, what is your AX version?
It is AX 2012 R3
It is available in R3, but as already said it is country specific. If you open a legal entity whose country is USA or Canada, then you will be able to see that report.
Depending on how formatted it needs to look, you can find a list of product receipts in a specific period in a couple of places.
First, you could use the “Procurement and sourcing”–>“Inquiries”–>“Journals”–>“Product receipt” form. You can filter the form to show whatever date range you need and then press Ctrl+T to export it to Excel.
Additionally, you could use the inventory transactions form in “Inventory management”–>“Inquiries”–>“Transactions”–>“Transactions”. You’d have to filter this one a little more aggressively to show only product receipts (look for only purchase orders that have !"" in the physical date field.)
I prefer using the forms because I get a little more control over what they show. You can personalize and change column labels and things - you can’t do that with standard reports.
[mention:d16d1631a7404018a8e6312528e48961:e9ed411860ed4f2ba0265705b8793d05] 's suggestion is great, though, if you need a more formal report.
Hi Jake,
I have tried to do through the Procurement & Sourcing, however the information lacks the line wise items information for the product receipts. Is there any other way to get these information including the PO #, Product Receipt #, Vendor Account & Line wise details for a specific period?
cheers,
It is just like the most of the inquiry forms available in AX. You will have header information on overview tab and item information on lines tab. You should be able to do the data filtering like other forms.
Which means there is no other option available to generate it in one report other than take support from the developer to tailor it?
Yes
Take a look at the inventory transactions form instead. That will have all the line information. A user should be able to personalize those forms to include the data you need (by right clicking and selecting personalize.)
I recently wrote a blog post on how to see an item’s purchase history. Here is the link: dynamicsuser.net/.../how-to-see-an-item-s-purchase-history
Maybe this can point you in the right direction?