Forum Discussion

lindso's avatar
lindso
Trusted Cover User
2 years ago
Solved

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
    2 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
2 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.

  • lindso's avatar
    lindso
    Trusted Cover User
    2 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.

Related content