How to Customize Detailed Sales Report to add item tender type sol

Hi Larry

It can be modified but unfortunately I don't know how. Although I did find a report showing tender type by transaction Id/number. I have copied it below, in case it's any use to you...

//--- Report Summary --- //

Begin ReportSummary ReportType = reporttypeSales ReportTitle = "Tender Summary with Transaction Number" PageOrientation = pageorientationPortrait WordWrap = True OutLineMode = True Groups = 1 GroupDescription = "" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" TablesQueried = "FROM TenderEntry LEFT JOIN [Transaction] ON TenderEntry.TransactionNumber = [Transaction].TransactionNumber LEFT JOIN Batch ON [Transaction].BatchNumber = Batch.BatchNumber LEFT JOIN Register ON Batch.RegisterID = Register.ID" SelCriteria = "" GroupBy = "" SortOrder = "TenderEntry.Amount, [Transaction].Time, TenderEntry.Description, Register.Description" End ReportSummary

//--- Title Rows ---//

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 16 Color = "Blue" End TitleRow

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 12 Color = "Black" End TitleRow

Begin TitleRow Text = "Generated On " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow

//--- Filters ---//

Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropbetween FilterLoLim = "" FilterHilim = "" End Filter

//--- Columns ---//

Begin Column FieldName = "Register.Description" DrillDownFieldName = "" DrillDownReportName = "" Title = "Register" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "[Transaction].TransactionNumber" DrillDownFieldName = "[Transaction].TransactionNumber" DrillDownReportName = "" Title = "Transaction Number" VBDataType = vbLong Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1245 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignCenterTop End Column

Begin Column FieldName = "TenderEntry.Description" DrillDownFieldName = "" DrillDownReportName = "" Title = "Tender" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "[Transaction].Time" DrillDownFieldName = "" DrillDownReportName = "" Title = "Date" VBDataType = vbdate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1500 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "Tenderentry.Amount" DrillDownFieldName = "" DrillDownReportName = "" Title = "Amount" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodSum ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "Tenderentry.Amount" DrillDownFieldName = "" DrillDownReportName = "" Title = "Max Amount" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodMax ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "Tenderentry.Amount" DrillDownFieldName = "" DrillDownReportName = "" Title = "Min Amount" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodMin ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Begin Column FieldName = "Tenderentry.Amount" DrillDownFieldName = "" DrillDownReportName = "" Title = "Avg Amount" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodAverage ColFormat = "" ColAlignment = flexAlignLeftTop End Column

Larry, Though the Detailed Sales Report could be modified to show tender information, it's not really practical. Here is why. In a detailed sales report each line corresponds to a single row in the TransactionEntry table in RMS. The Transaction, Customer, ReasonCode, etc, tables are joined to it to add additional information. The TenderEntry table could be joined to this, but the problem comes when you have a transaction with more than one tender. By default the sql needed in the report would generate 2 duplicate transaction entry for each transaction if there were 2 tenders, skewing things like sales totals.

Basically if you don't care about having some double reporting, or if you only want to ever be able to she a single Tender, then this is possible.

Of course, a different reporting language such as Crystal or RDL would be capable of reporting something like this.

Good morning.

Attached is a report that I have done that shows the tender on the sale. However, as Ryan stated, there will be issues where there are two tenders on the same sale as these items will show up twice.

Joshua

begin 666 Custom - Detailed Sales Report with tender.qrp M+R\M+2T@4F5P;W)T(%-U;6UA$%L:6=N3&5F=$-E;G1E

Thanks this will work, I was aware of the split tender issue.To adjust for exceptions we can run a script where the count of the tender type is greater than 1 per transaction and get a list of exception transactions to make the adjustment. We are tracking a single item and could create a business process rule if that item is included we can only sell it as a single tender or have to ring it as a separate transaction if neccessary. Thank you for the report Joshua

"Joshua Smith" wrote: