Hello - As the end of my fiscal tear quickly approaches, I was wondering if there is a report that lists the payouts made during a definable period? (ie 1/1/2010 - 12/31/2010)?
this is an easy sql query, and wouldn't be too hard to put in a report as well.
select * from droppayout where time>'1/1/10' and time<'1/1/11'
Check your email for a pre-formatted report
Atten: Microsoft - will we EVER be able to attach files here?
There is a report available on customersource for both drops and payouts. I use it all the time.
I was wondering the same thing Marc. I didn't think about sending it to his email. I'll use that next time. It's a shame though, since only one person benefits from your help and sharing that way.
Hey Marc and fishhead, is it possible for you to send it to my email also. I would really appreciate it thanks. firstname.lastname@example.org
Check your email.
Maybe open a DropBox or similar account and post links to the file(s). We do this all the time.
BTW, here's our Drop and Payout report;
I have not been active on the forums since the change. I am glad to see you found a workaround for the attachment issue. Thanks for the tip.
Hey thank you very much Marc, it worked perfectly.
Could you please send updated link or email to email@example.com
please email me the report as well firstname.lastname@example.org
Can I get the report email@example.com
Could you please send this via email firstname.lastname@example.org link showing 404.
Copy the following text into NotePad then save in your reports as UTF8 and this filename "Memorized-Drop Payouts by Date.qrp", no .txt extension
Then you will have it in your Memorized reports.
//--- Report Summary --- //
ReportType = reporttypeSales
ReportTitle = "Drop Payouts by Date"
PageOrientation = pageorientationPortrait
WordWrap = True
ShowDateTimePicker = True
OutLineMode = True
Groups = 0
GroupDescription = ""
DisplayLogo = False
LogoFileName = ""
ProcedureCall = ""
PreQuery1 = ""
PreQuery2 = ""
TablesQueried = <BEGIN>
SelCriteria = ""
GroupBy = ""
SortOrder = ""
//--- Title Rows ---//
Text = "<Store Name>"
Font = "Arial"
FontBold = True
FontSize = 16
Color = "Blue"
Text = "<Report Title>"
FontSize = 12
Color = "Black"
Text = "Generated On <Report Date>"
FontSize = 10
//--- Filters ---//
FieldName = "DropPayout.Time"
FilterOp = reportfilteropBetween
FilterLoLim = "8/07/2015"
FilterHilim = "8/07/2019"
FilterNegated = False
FilterConnector = reportfilterbooleanconAND
//--- Columns ---//
FieldName = "DropPayout.CashierID"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Cashier ID"
VBDataType = vbInteger
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 937
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftTop
Title = "Date"
VBDataType = vbDate
ColWidth = 1195
FieldName = "DropPayout.StoreID"
Title = "StoreID"
ColWidth = 1100
FieldName = "DropPayout.BatchNumber"
Title = "Batch #"
ColWidth = 774
FieldName = "DropPayout.Amount"
Title = "Amount"
VBDataType = vbCurrency
ColWidth = 1508
GroupMethod = groupmethodSum
FieldName = "DropPayout.Comment"
Title = "Comment"
VBDataType = vbString
FieldName = "DropPayout.Recipient"
Title = "Recipient"
ColWidth = 1902
FieldName = "DropPayout.ReasonCodeID"
Title = "Reason Code"
ColWidth = 992
Business Applications communities