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.

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.

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.  

Yes, a very good suggestion.  I was referring to either 2013 or 2014 versions.

Thank you for responding. I am on 2013.

www.greytrix.com/.../create-custom-reports-in-sage-100-erp-using-business-insights

This link is basically what I've been trying to do. I feel like I've set it up for what I want, but every time I run it I get a huge error message saying failed to open the connection

jwellman creating a new "Report Setting" and adding a formula in the report Inventory Management/Reports/Inventory Sales History Report would be the easiest and quickest way to get what you want if you know crystal reports.  If you have access and crystal installed, after you create a new report setting you can go into the designer which is located under the "Save" button.  This is where you would modify it.  If you don't know crystal or have access to the designer, you may want to ask your consultant.  Should be a quick modification.