Forum Discussion

lindso's avatar
lindso
Trusted Cover User
3 years ago

Inventory Report showing sale price and last cost incl price

Where can I find a report that can provide me with a list of inventory items showing sale price and last cost, not standard cost or average cost? When I'm in the Inventory command centre and to the t...
  • Steven_M's avatar
    Steven_M
    3 years ago

    Hi lindso 

     

    Why don't you just use the Inventory>>Item List window? This should show the Item Number, Name, Last Cost and Sell Price. If you wanted this in a report format, you could right-click on the Item List window and select Copy List to Clipboard. This will copy the on-screen information to the Windows Clipboard to allow you to paste into another application such as Notepad or Excel.


    If you are strictly wanting a report, the Inventory>>Price Analysis report with the Cost Basis being Last Price would be one to look into.

Steven_M's avatar
Steven_M
Former Staff

Hi lindso 

 

Why don't you just use the Inventory>>Item List window? This should show the Item Number, Name, Last Cost and Sell Price. If you wanted this in a report format, you could right-click on the Item List window and select Copy List to Clipboard. This will copy the on-screen information to the Windows Clipboard to allow you to paste into another application such as Notepad or Excel.


If you are strictly wanting a report, the Inventory>>Price Analysis report with the Cost Basis being Last Price would be one to look into.

lindso's avatar
lindso
Trusted Cover User
3 years ago

Hi Steven_M 

 

Excellent, thank you!! As I stated I was in the Item List window but tried to print the report from there (not knowing I could copy and paste) which gave the Item List Summary Report (not including the Last Cost Price) but I need the Price Analysis Report as suggested and change the cost basis from Average Cost to Last Price.

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.

 

Related content