Item margin report

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

"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: