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.

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

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.