1. Home
  2. Point-Of-Sale Software
  3. Basic list of transactions

Basic list of transactions

Hi I have looked around but cannot find a report that will allow me to list the transactions for a period.All I want is a list of sales / refunds/ pay outs etc for any given day. I realise there is a copy of each till receipt but this is a very laborious process. Alternatively a report that will give me all transactions which used a reason code I apologise if I have missed somethin but I am new to RMS. It does appear the reporting options are much more difficult to use / missing compared to other software I havew used.

Thanks for any help Richard

Reply to
RichardB
Loading thread data ...

Hi Richard, you're right, unfortunately the reports "out of the box" in RMS are nothing to write home about. I haven't been able to find a report that shows a list of sales transactions, so I put together my own report - it's a little rough on the edges - haven't had a chance to embellish it but it will give you a breakdown by transaction.

It won't include cash drops or payouts as it only taps into the transaction table. The shipping is based on using shift F1 for shipping charges. Paste the verbiage below on a notepad and save it as "Custom - Sales Transactions Today.qrp" or whatever title you want, just add "custom" at the beginning, you'll run it from reports - custom in SO manager. Save it in the following directory: C:\Program Files\Microsoft Retail Management System\Store Operations\Reports

//--- 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

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 = "[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

"RichardB" wrote:

Reply to
convoluted

Reply to
RichardB

Hi Richard - connect to your db and run sp_tables (this will show you tables and views) to view fields in a table run sp_columns [table_name]

For example to view the columns/fields in the purchaseorder table run sp_columns purchaseorder

Regarding the reason code, you can run the detailed sales report and filter for your reason code - it will show you sales where that reason code was used.

Hope this helps

"RichardB" 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.