Is there a report that shows item cost, price and margin?
I can see this on sales reports, but not just an item list. I want to quickly scan my items to see which have inappropriate margins. I've managed to do this by exporting to Excel, but would prefer to not have to go through this interim step.
Thanks
Malcolm Smart
No but you could add the code below to your Item Value List report. Make a copy of the report and change the name to -- Custom - Item Value List.qrp -- Right-click on the report and uncheck ReadOnly. Then open the report using Notepad, add the code below to the bottom of the report. **You will have to make sure that the Formula line is on 1 line and not 2. It wraps when posted. Save the report and restart SO Manager go to Reports --> Custom
-- Item Value List.
Rob
***********************************************************Begin Column FieldName = "ProfitMargin" DrillDownFieldName = "" DrillDownReportName = "" Title = "Profit Margin" VBDataType = vbDouble Formula = "CASE WHEN Item.Price 0 THEN ((Item.Price - Item.Cost) / Item.Price) ELSE 0 END" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 900 GroupMethod = groupmethodNone ColFormat = "0.00%" End Column
***********************************************************"T> Is there a report that shows item cost, price and margin?
Hello there,
Retail Analytics from Professional Advantage will allow you to not only look at your item cost, price and margin. You can see what the fastest/slowest moving item by month, how are sales performing vs budgets, what are the sales trends by time of the year by location, etc.
We also have the UCAP (Up Close and Personal) program for Retail Analtyics. UCAP - we have streamlined a process to get client's RMS data in house, load Retail Analytics and then demonstrate the full power of the product on the LIVE data at no cost!
Please do not hesitate to contact me if you have any questions or if there is anything that we can do for you.
Thansk,
Jen Bridgeford Professional Advantage
701 235 2363 ext 248 snipped-for-privacy@profad.com"T> Is there a report that shows item cost, price and margin?
Thanks very much, Rob. That did the trick. And even better, it taught a newbie like myself how to modify reports for my own needs.
Malcolm Smart
I typed in the code, but got an error report at line 443
Item.Price) ELSE 0 END"
I also tried cut and paste, still the same error....??
Marwat
"Rob" wrote:
This line needs be placed on the same line as the Formula. So it should read: Formula = "CASE WHEN Item.Price 0 THEN ((Item.Price - Item.Cost) / Item.Price) ELSE 0 END" But all one line.
Rob
Thank you Rob, works perfectly now.
Marwat
"Rob" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.