UHF - Header

SBX - Search With Button

SBX - Forum Post Title

Drop Payout Report

Microsoft Dynamics RMS Forum

Otto Badran asked a question on 26 Nov 2018 3:01 PM

Drop Payout Report

Suggested Answer

Hi all,

Does anybody have a report that list the drop/payout transactions? Seems the report library for SO is not available anymore.

Thanks,

Otto Badran

Universal Retail Systems 

Reply
Adam26 responded on 30 Nov 2018 5:39 PM
My Badges

Drop Payout Report

Unanswered

This is the one we use. I do not remember who the author is. Sorry


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

Begin ReportSummary
ReportType = reporttypeCustom
ReportTitle = "Drop or Payout List"
PageOrientation = pageorientationPortrait
ShowDateTimePicker = False
OutLineMode = True
Groups = 0
GroupDescription = "Total"
DisplayLogo = True
LogoFileName = "MyLogo.bmp"
ProcedureCall = ""
TablesQueried = <BEGIN>
FROM DropPayout
LEFT JOIN Cashier WITH(NOLOCK) ON DropPayout.CashierID = Cashier.ID
LEFT JOIN ReasonCode WITH(NOLOCK) ON DropPayout.ReasonCodeID = ReasonCode.ID
<END>

SelCriteria = ""
GroupBy = ""
SortOrder = "DropPayout.[Time]"
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 = "As Of: <Report Date>"
Font = "Arial"
FontBold = True
FontSize = 10
Color = "Black"
End TitleRow

Begin TitleRow
Text = "Designed and/or modified by Check Point Software Ver. 1.0"
Font = "Arial"
FontBold = False
FontSize = 8
Color = "Black"
End TitleRow

//--- Filters ---//

Begin Filter

Reply
LiquorBiz responded on 6 Jul 2019 10:52 AM

Drop Payout Report

Unanswered

Can I get the full report. ALso How to put a custom report to show on the menu

Reply
Kevin Antosh responded on 8 Jul 2019 9:06 AM
My Badges

Drop Payout Report

Unanswered

Ho Otto!  Any chance that you have Crystal Reports or a similar tool to create the report in RMS?  I can check with our tech team as well to see if we have already created a drop/payout report for RMS or what the cost would be - just let me know how you want to proceed. Thanks!

Reply
Kevin Antosh responded on 8 Jul 2019 10:07 AM
My Badges

Drop Payout Report

Unanswered

Hi again Otto!  RITE has 2 options: 1) we already have the report created so it would just be the billable time to install and test or 2) Our Consolidated Z report for RMS includes paid out information. You can find more information about Consolidate Z here: rite.us/.../ConsolidatedZReport.aspx

Reply
TheNeos responded on 13 Jul 2019 9:08 PM
My Badges

Drop Payout Report

Suggested Answer

The report bellow all fields for Payouts searchable

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

Begin ReportSummary

  ReportType = reporttypeSales

  ReportTitle = "Payouts by Date c Neos"

  PageOrientation = pageorientationPortrait

  WordWrap = True

  ShowDateTimePicker = True

  OutLineMode = True

  Groups = 1

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

  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 = 910

  GroupMethod = groupmethodSum

  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 = 992

  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 = 761

  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 = 829

  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 = 992

  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 = 1209

  GroupMethod = groupmethodSum

  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
TheNeos responded on 13 Jul 2019 9:08 PM
My Badges

Drop Payout Report

Suggested Answer

The report bellow all fields for Payouts searchable

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

Begin ReportSummary

  ReportType = reporttypeSales

  ReportTitle = "Payouts by Date c Neos"

  PageOrientation = pageorientationPortrait

  WordWrap = True

  ShowDateTimePicker = True

  OutLineMode = True

  Groups = 1

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

  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 = 910

  GroupMethod = groupmethodSum

  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 = 992

  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 = 761

  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 = 829

  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 = 992

  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 = 1209

  GroupMethod = groupmethodSum

  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