Does anyone know how to create a item report that shows the profit margin for each item. I need to know which items have a negative profit margin. I have created one from detailed sales, but I would like to catch these items before they are sold, not after. I am having issues with my costs from our old system. Example: In our old system we could cost a item by the box but sell it by each and I have alot of items with "box" costs and "each" sell prices which are showing up as a loss when sold. Any help appreciated.
Profit Margin Report
Apr 07, 2005
4 Replies
Go into the Reports folder, copy the Items - Item Value List report and modify the properties of the copy to not be read only. Change the name to Custom - Value List report then add a new column for Profit Margin.
Begin Column FieldName = "Profit" DrillDownFieldName = "" DrillDownReportName = "" Title = "Profit Margin" VBDataType = vbCurrency Formula = "CASE WHEN Item.Price 0 THEN ((Item.Price - Item.Cost) / Item.Price) ELSE 0 END" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 855 GroupMethod = groupmethodAverage ColFormat = "0.00%" End Column
Rob
Thank you Rob. I have been looking for this for about 3 months now. works perfect. If its not too much problem can you please help me add one more coloumn to your add-on?
You know how it gives us a new coloum for Profit margin? Now can you avergae the profit margin and give us a totoal average profit of margin?
For example I choose Reports-> custom -> Item profit report -> I select a supplier. than it gives me profit margin for each item using cost and retail price values. now can you make a new box at the bottom which says " Total avergae margin on this supplier is: this much percentage"
i would greatly apreciate it thanx.
"Rob" wrote:
Adnan,
This is something you can do yourself. Run the Item Profit report. Click on the Supplier column and drag and drop all the way to the left. Now you have a profit margin report by Supplier. You can save this report to your Memorized list and call Item Profit Margin by Supplier Done.
Rob
perfect thanx a bucnh !
take care
p.S: I guess RMS does much more than what i though it could do.
"Rob" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required