1. Home
  2. Point-Of-Sale Software
  3. Need a report of items sorted by profit margin (Crystal reports?)

Need a report of items sorted by profit margin (Crystal reports?)

I'm needing to create an item list to include the profit margin so I can sort by that.

I'm thinking I need to use Crystal Reports to do this. I have rad on here that version 8.5 is the one that integrates with RMS. Do I need to buy a copy of Crystal Reports to do this or should the program already be on my computer?

Also, when using Crystal Reports, can you have it include all the fields? For instance, I'd love to be able to have the above list include information that is in the commission tab (both the basis and the schedule).

Reply to
Meralee
Loading thread data ...

Reply to
sammm

Reply to
Meralee

memorize a copy of the Items - Master Price List and then edit in notepad (file is in directory c:\Program Files\Microsoft Retail Management System\Headquarters\Reports) to add this column to the bottom.

Begin Column FieldName = "profit" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Profit Margin" VBDataType = vbDouble Formula = "case item.Price when 0 then 0 else (1-Item.Cost/Item.Price)*100 end" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1170 GroupMethod = groupmethodNone ColFormat = "" End Column

"Meralee" wrote:

Reply to
Matt Hurst

I have one that shows 12 month sales by month and also shows profit margin, cost price etc

Leave your email here and i will email you a copy

"Meralee" wrote:

Reply to
Robert

could you send one to me also Robert? My email is snipped-for-privacy@cctropicalparadisepets.com thanks.

Craig

Reply to
Craig

Thank you Matt! This was EXACTLY what I needed!!!

RMS didn't like "(1-Item.Cost/Item.Price)*100 end" being on the next line, but I just deleted the carriage return and it worked like a charm.

THANK YOU!!!!

"Matt Hurst" wrote:

Reply to
Meralee

Meralee,

what did you have to delete to get it to work?

Craig

Reply to
Craig

figured it out, just delete the space between the two lines and it works.

Craig

Reply to
Craig

Please send to dj(dot)lane(at)gmail(dot)com Thanks

Reply to
Dan-902

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.