395
Can someone help me with a SQL (SQL2008) command please? I need a command to execute sales by cashier with in date range. The result must show company name and total sales. Thank you.
*This post is locked for comments
Nazza
You will not be able to modify the daily sales by cashier report. What you can do is add the company name to the Detailed Sales report.
Add this to the report qrp file, using notepad. Make it the first column entry under the //--- Columns ---//. Save report as "Custom - Detailed Sales by Customer Company.qrp.
Restart RMS Manager if open. Your report will be under the custom report menu.
Begin Column
FieldName = "Customer.Company"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Company"
VBDataType = vbString
Formula =
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2205
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
I am talking about customer's company name. All our customers are retailers hence their company name is priority for us. By default, Customer name is on the report but now I have amended report to look for Customer.Company instead of Customer.Name. Working a treat, thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (