In the detailed sales report. The profit margin (%) does not reflect the $ profit if there is a refund in the detailed sales report. the profit ($) is positive while the sale is negative, obviously the ouput is wrong. I am not sure if my explanation is clear, the best way is to try with a negative sale included. Does anybody have a solution? humbleman
inconsitant profit margin
Sep 13, 2007
4 Replies
hi you are right? here is the correct code which multiple the quantity with price also: You need to modify the Sales - Detailed Sales Report.qrp file and update the below code. once work rate me.
Begin Column FieldName = "Profit" DrillDownFieldName = "" DrillDownReportName = "" Title = "Profit" VBDataType = vbCurrency Formula = "(TransactionEntry.Price - TransactionEntry.Cost)* TransactionEntry.Quantity" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 900 GroupMethod = groupmethodSum ColFormat = "" End Column
Beg> In the detailed sales report. The profit margin (%) does not reflect
hi, Well I would say it is a bug as this already reported by me also to Microsoft and I am not sure. but I believe it also solve by any sp available as I not tried any service pack. Try and then let me know, and once anyone suggestion help you please rate. I appreciate.
"humbleman" 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