Forum Discussion

angela11's avatar
angela11
Contributing User
4 years ago

Inventory purchase price history report

Hi, Is there a report that can be run in AccountRight that provides a unit price history for purchases of a particular item over time? In my case, I would like to track the price paid for raw mater...
  • Steven_M's avatar
    Steven_M
    4 years ago

    Hi angela11 

     

    There is no report per say that would store that information as it would only report the current information of the item setup. However, the way I would do it would be to run the Purchases [Item Detail] report.

     

    The Purchases [Item Detial] report is designed to the purchases record for that company file based on an item basis. One of the fields that can be added to that report is the Price, this would be the price of that item that was used on that transaction.  This report can be run via Reports>>Purchases>>Item>>Purchases [Item Detail]. Once that report has been run you can go to Insert/Modify>>Show Hide>>Navigate to Price (or Inc-Tax Price) and select Show. This will add the price of the items used on those purchases onto the report so you can see the change of time.

Steven_M's avatar
Steven_M
Former Staff
4 years ago

Hi angela11 

 

There is no report per say that would store that information as it would only report the current information of the item setup. However, the way I would do it would be to run the Purchases [Item Detail] report.

 

The Purchases [Item Detial] report is designed to the purchases record for that company file based on an item basis. One of the fields that can be added to that report is the Price, this would be the price of that item that was used on that transaction.  This report can be run via Reports>>Purchases>>Item>>Purchases [Item Detail]. Once that report has been run you can go to Insert/Modify>>Show Hide>>Navigate to Price (or Inc-Tax Price) and select Show. This will add the price of the items used on those purchases onto the report so you can see the change of time.

  • angela11's avatar
    angela11
    Contributing User
    4 years ago

    Thank you Steve, that resolves my issue.

    Much appreciated.

     

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.