Inventory Sales History Report

I'm trying to get a report that is similar to the Inventory Sales History Report, but also to include the price per unit. This report sorts by item code which is what I want, and also lists quantity sold and quantity returned which I need. I just need it to show the price per unit of the item instead of giving me total dollars sold of that item number.

Parents
  • 0

    Hi,

    Sage Intelligence includes an inventory status report that comes standard.  This report includes costs, various quantities, sales unit of measure and more. You can add price per unit by adding the field to a container and ultimately to the report.  To do this you will need Report Manager (1 comes free with Sage ERP 100) and the Connector module (purchase license).  If you are interested and would like more information on the product let me know and I can get you resources.

    Thank you,

    Sandra.

  • 0 in reply to Sandra Smith

    You do not say which version you are on, but if the report allows you to add a new "Report Setting" you could go into designer and put a formula in, to divide the dollar amount by the quantity and add it to the report.  This of course will give you a rounded number, but close to what was charged.  

Reply
  • 0 in reply to Sandra Smith

    You do not say which version you are on, but if the report allows you to add a new "Report Setting" you could go into designer and put a formula in, to divide the dollar amount by the quantity and add it to the report.  This of course will give you a rounded number, but close to what was charged.  

Children