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

Jan 05, 2010 9 Replies
M

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).


Vote
Twitter Facebook LinkedIn
M

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:

Vote
Twitter Facebook LinkedIn
R

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:

Vote
Twitter Facebook LinkedIn
C

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

Craig

Vote
Twitter Facebook LinkedIn
M

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:

Vote
Twitter Facebook LinkedIn
C

Meralee,

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

Craig

Vote
Twitter Facebook LinkedIn
C

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

Craig

Vote
Twitter Facebook LinkedIn
D

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

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required