I need to create a report based on the Current Sales Price and compare it to Last Cost and Avg Cost, so we can see what the Profit Margin/Profit % is.
I need to include the following fields in the report:
- Customer
- Inventory ID
- Current Sale Price
- Last Cost
- Avg. Cost
- Last Transaction Qty
- Last Transaction Date
- Profit Margin
- Profit%
I would like to be able to filter this report based on Customer Sales Price Code/Customer and Start Date (this would be the Start Date for the Customer’s Price Code)
I’m not sure how to bring all this data together, so if someone out there can help, I would greatly appreciate it!
Sarah