I am trying to find a report to show daily sale where we can filter the data to show the transactions with any discount. I have also tried to create a report with reporting service but can not figure out what field and table hold discount amount.
I also need help with EDC reprot to show credit card type or starting four digit of any credit card number.
Help.
Discount information can be calculated by the difference in the transactionentry price (sold) vs. fullprice (retail).
Save your version to a memorized report and then open it in notpad from the directory: C:\Program Files\Microsoft Retail Management System\Headquarters\Reports
Then add these columns to the end of the report:
Begin Column FieldName = "discount" DrillDownFieldName = "" DrillDownReportName = "" Title = "Discount" VBDataType = vbCurrency Formula = "fullprice-TransactionEntry.price" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2280 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "pcntoff" DrillDownFieldName = "" DrillDownReportName = "" Title = "Percent Off" VBDataType = vbDouble Formula = "(1-TransactionEntry.price/fullprice)*100" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2280 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Have something to add? Share your thoughts — no account required.
Ask the community — no account required