1. Home
  2. Point-Of-Sale Software
  3. SO detail sales not equal X report

SO detail sales not equal X report

I have a very strange situation. At a closing 3 Blind-Close-out (1 day = 3 shifts), we printed a detail report for a specific date and noticed that the total sales does not equal a blind close-out X-Report all 3 reports.

The details is $18,752.00 and the sum of teh X-Report displays $9.525.11

At this point we are comparing actual receipt sales to see what happened.

My question is, whats the recommended way to analyze this type of situation and where shoudl we be looking besides actual paper receipt?

Reply to
RicoTowers
Loading thread data ...

There may have been some sales transactions AFTER the X report was printed, that would make the Z report be greater (if sales) or lower (if returns) than the X report. I have never seen a Z report printed immediately after the X report showing different numbers than the X report, as the X gives you exactly the same info the Z would, without closing the sales batch.

I use a custom report for Store Operations I created many moons ago to help me troubleshoot client closing issues. It allows you to filter by batch number, by day, etc. It shows a detail of the transactional info such as totals, sales tax, etc. (header info, no details)

Paste the following on a notepad and save as "Custom - Sales Transaction Journal.qrp" or something like that....run it from reports - custom. Hope this helps...

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

Begin ReportSummary ReportType = reporttypeSales ReportTitle = "Sales Transaction Journal" PageOrientation = pageorientationPortrait OutLineMode = True Groups = 1 GroupDescription = "" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" TablesQueried FROM [Transaction] WITH(NOLOCK) LEFT JOIN Customer WITH(NOLOCK) ON Customer.ID = [Transaction].CustomerID LEFT JOIN Shipping ON [Transaction].TransactionNumber = Shipping.TransactionNumber INNER JOIN Batch WITH(NOLOCK) ON [Transaction].BatchNumber = Batch.BatchNumber

SelCriteria = "" GroupBy = "" SortOrder = "" 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 = "[Transaction].TransactionNumber" DrillDownFieldName = "[Transaction].TransactionNumber" DrillDownReportName = "" Title = "Transaction" VBDataType = vbLong Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1245 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Batch.BatchNumber" DrillDownFieldName = "" DrillDownReportName = "" Title = "Batch #" VBDataType = vbLong Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1000 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "[Transaction].Time" DrillDownFieldName = "" DrillDownReportName = "" Title = "TransDate" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1800 GroupMethod = groupmethodNone ColFormat = "mm/dd/yyyy" End Column

Begin Column FieldName = "CustomerName" DrillDownFieldName = "" DrillDownReportName = "" Title = "Customer" VBDataType = vbString Formula = "Customer.LastName + ', ' + Customer.FirstName" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1350 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Begin Column FieldName = "SubTotal" DrillDownFieldName = "" DrillDownReportName = "" Title = "SubTotal" VBDataType = vbCurrency Formula = "CASE WHEN Shipping.Charge IS NULL THEN ([Transaction].Total - [Transaction].SalesTax) ELSE ([Transaction].Total - [Transaction].SalesTax - Shipping.Charge) END" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1530 GroupMethod = groupmethodSum ColFormat = "" End Column

Begin Column FieldName = "[Transaction].SalesTax" DrillDownFieldName = "" DrillDownReportName = "" Title = "Sales Tax" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1530 GroupMethod = groupmethodSum ColFormat = "" End Column

Begin Column FieldName = "Shipping.Charge" DrillDownFieldName = "" DrillDownReportName = "" Title = "Shipping" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1530 GroupMethod = groupmethodSum ColFormat = "" End Column

Begin Column FieldName = "[Transaction].Total" DrillDownFieldName = "" DrillDownReportName = "" Title = "Transaction Total" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1530 GroupMethod = groupmethodSum ColFormat = "" End Column

Begin Column FieldName = "[Transaction].RecallID" DrillDownFieldName = "" DrillDownReportName = "" Title = "Recall ID" VBDataType = vbLong Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1530 GroupMethod = groupmethodNone ColFormat = "" End Column

"RicoTowers" wrote:

Reply to
convoluted

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.