Wednesday, December 14, 2016

How to See an Item's Purchase History

When planning and forecasting for the next year, it is helpful to know the past purchase history on an item. It isn't extremely obvious how to find this in AX if you aren't tracking this with a Purchase agreement, but there are a few different ways to see this information that can help when setting up a purchasing plan for the next year.

Period Statistics


When you navigate to an item in the Released products form, Product information management > Common > Released products, you can find your item and navigate to the Purchase tab in the ribbon. 

In the Purchase order section, there is a button called Period statistics. 

Period statistics button on the Released product in AX
Period statistics button on Released products in AX

If you select this, you can see a very basic summary of how many of this particular item had been purchased in the current month, the past month, the current year to date totals, the past year totals, and the lifetime purchase totals for the item. 

Period statistics for current month, past month, current year, past year, and lifetime of the item.
Period statistics for current month, past month, current year, past year, and lifetime of the item.

Reports


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, there are a couple of different reports available to see how much of an item was purchased in a given time frame.

  • Item/Vendor statistics
  • Vendor/Item statistics

The Item/Vendor statistics report sorts first by the item number, then by the vendor account. You see everything broken down by item, with all vendors that the item was purchased from listed underneath within the date range specified. 

The Vendor/Item statistics report is the exact opposite. This report takes the Vendor and shows all purchases for the specified item under the vendor record within the date range specified. 

Inventory Transactions


And finally, the last way I am sharing today on how to see an item's purchase order history would be in the item's Inventory transactions.

The item's Inventory transaction history can be viewed from the item itself, and this would be the easiest way since the form will already be sorted by the item. You can see this on the item in Released products, which is located at Product information management > Common > Released products.

Navigate to the Manage inventory tab on the ribbon in your item. In the View section, select Transactions.

View of the Transactions button to view Inventory Transactions in AX
Inventory Transactions for the item in AX

This will open up all inventory transactions for the item.

List of inventory transactions in AX
List of inventory transactions in AX

This form can get very long, but one thing you can do to help is filter! 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.

How do you see an item's purchase order history in AX? Do you have any other cool tips and tricks that I didn't address in this blog post? Let me know in the comments!

No comments:

Post a Comment