UHF - Header

Skip to main content
Dynamics 365 Community

SBX - Search With Button

SBX - Forum Post Title

Report to tally the payouts for a definable period - does this exist?

Microsoft Dynamics RMS Forum

David Schueckler asked a question on 3 Dec 2010 6:49 PM
My Badges

Report to tally the payouts for a definable period - does this exist?

Suggested Answer

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)?

Reply
Matt Hurst responded on 4 Dec 2010 8:53 PM
My Badges

Report to tally the payouts for a definable period - does this exist?

Suggested Answer

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'

Reply
MarcR responded on 5 Dec 2010 7:50 AM
My Badges

Report to tally the payouts for a definable period - does this exist?

Unanswered

Check your email for a pre-formatted report

Marc

 

Atten: Microsoft - will we EVER be able to attach files here?

Reply
fishhead responded on 7 Dec 2010 6:00 AM
My Badges

Report to tally the payouts for a definable period - does this exist?

Suggested Answer

There is a report available on customersource for both drops and payouts. I use it all the time.

Reply
fishhead responded on 7 Dec 2010 6:02 AM
My Badges

Report to tally the payouts for a definable period - does this exist?

Unanswered

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.

Craig

Reply
Delon Ragobeer responded on 29 Feb 2012 10:06 AM

Report to tally the payouts for a definable period - does this exist?

Unanswered

Hey Marc and fishhead, is it possible for you to send it to my email also. I would really appreciate it thanks. dragobeer@nealandmassygy.com

Reply
MarcR responded on 29 Feb 2012 12:13 PM
My Badges

Report to tally the payouts for a definable period - does this exist?

Unanswered

Delon,

Check your email.

Reply
Jeff @ Check Point Software responded on 29 Feb 2012 1:45 PM
My Badges

Report to tally the payouts for a definable period - does this exist?

Unanswered

MarcR,

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;

dl.dropbox.com/.../Custom%20-%20Misc%20-%20Drop%20or%20Payout.qrp

Reply
MarcR responded on 29 Feb 2012 1:59 PM
My Badges

Report to tally the payouts for a definable period - does this exist?

Unanswered

Hi Jeff,

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.

Marc

Reply
Delon Ragobeer responded on 5 Mar 2012 3:40 AM

Report to tally the payouts for a definable period - does this exist?

Unanswered

Hey thank you very much Marc, it worked perfectly.

Reply
LiquorBiz responded on 6 Jul 2019 10:54 AM

Report to tally the payouts for a definable period - does this exist?

Unanswered

Could you please send updated link or email to penrynsub@gmail.com

Reply
LiquorBiz responded on 6 Jul 2019 10:55 AM

Report to tally the payouts for a definable period - does this exist?

Unanswered

please email me the report as well penrynsub@gmail.com

thanks

Reply
LiquorBiz responded on 6 Jul 2019 5:43 PM

Report to tally the payouts for a definable period - does this exist?

Unanswered

Can I get the report arusent@outlook.com

Reply
Aadeel S. Puri responded on 7 Jul 2019 12:40 PM
My Badges

Report to tally the payouts for a definable period - does this exist?

Unanswered

Hi Jeff,

Could you please send this via email aadeel@skyrocket.com.pk link showing 404.

Thanks.

Reply
TheNeos responded on 8 Jul 2019 4:13 AM
My Badges

Report to tally the payouts for a definable period - does this exist?

Suggested Answer

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.

Cheers

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

Begin ReportSummary

  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>

FROM [DropPayout]

<END>

  SelCriteria = ""

  GroupBy = ""

  SortOrder = ""

End ReportSummary

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

Begin TitleRow

  Text = "<Store Name>"

  Font = "Arial"

  FontBold = True

  FontSize = 16

  Color = "Blue"

End TitleRow

Begin TitleRow

  Text = "<Report Title>"

  Font = "Arial"

  FontBold = True

  FontSize = 12

  Color = "Black"

End TitleRow

Begin TitleRow

  Text = "Generated On <Report Date>"

  Font = "Arial"

  FontBold = True

  FontSize = 10

  Color = "Black"

End TitleRow

//--- Filters ---//

Begin Filter

  FieldName = "DropPayout.Time"

  FilterOp = reportfilteropBetween

  FilterLoLim = "8/07/2015"

  FilterHilim = "8/07/2019"

  FilterNegated = False

  FilterConnector = reportfilterbooleanconAND

End Filter

//--- Columns ---//

Begin Column

  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

End Column

Begin Column

  FieldName = "DropPayout.Time"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Date"

  VBDataType = vbDate

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1195

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.StoreID"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "StoreID"

  VBDataType = vbInteger

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1100

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.BatchNumber"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Batch #"

  VBDataType = vbInteger

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 774

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.Amount"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Amount"

  VBDataType = vbCurrency

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1508

  GroupMethod = groupmethodSum

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.Comment"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Comment"

  VBDataType = vbString

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1195

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.Recipient"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Recipient"

  VBDataType = vbString

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1902

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.ReasonCodeID"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Reason Code"

  VBDataType = vbInteger

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 992

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Reply
fishhead responded on 7 Dec 2010 6:00 AM
My Badges

Report to tally the payouts for a definable period - does this exist?

Suggested Answer

There is a report available on customersource for both drops and payouts. I use it all the time.

Reply
TheNeos responded on 8 Jul 2019 4:13 AM
My Badges

Report to tally the payouts for a definable period - does this exist?

Suggested Answer

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.

Cheers

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

Begin ReportSummary

  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>

FROM [DropPayout]

<END>

  SelCriteria = ""

  GroupBy = ""

  SortOrder = ""

End ReportSummary

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

Begin TitleRow

  Text = "<Store Name>"

  Font = "Arial"

  FontBold = True

  FontSize = 16

  Color = "Blue"

End TitleRow

Begin TitleRow

  Text = "<Report Title>"

  Font = "Arial"

  FontBold = True

  FontSize = 12

  Color = "Black"

End TitleRow

Begin TitleRow

  Text = "Generated On <Report Date>"

  Font = "Arial"

  FontBold = True

  FontSize = 10

  Color = "Black"

End TitleRow

//--- Filters ---//

Begin Filter

  FieldName = "DropPayout.Time"

  FilterOp = reportfilteropBetween

  FilterLoLim = "8/07/2015"

  FilterHilim = "8/07/2019"

  FilterNegated = False

  FilterConnector = reportfilterbooleanconAND

End Filter

//--- Columns ---//

Begin Column

  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

End Column

Begin Column

  FieldName = "DropPayout.Time"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Date"

  VBDataType = vbDate

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1195

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.StoreID"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "StoreID"

  VBDataType = vbInteger

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1100

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.BatchNumber"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Batch #"

  VBDataType = vbInteger

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 774

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.Amount"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Amount"

  VBDataType = vbCurrency

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1508

  GroupMethod = groupmethodSum

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.Comment"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Comment"

  VBDataType = vbString

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1195

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.Recipient"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Recipient"

  VBDataType = vbString

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 1902

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Begin Column

  FieldName = "DropPayout.ReasonCodeID"

  DrillDownFieldName = ""

  DrillDownReportName = ""

  StoreIDFieldName = ""

  Title = "Reason Code"

  VBDataType = vbInteger

  Formula = ""

  ColHidden = False

  ColNotDisplayable = False

  FilterDisabled = False

  ColWidth = 992

  GroupMethod = groupmethodNone

  ColFormat = ""

  ColAlignment = flexAlignLeftTop

End Column

Reply

SBX - Two Col Forum

SBX - Migrated JS