SBX - Search With Button

SBX - Forum Post Title

Drop Payout Report

Microsoft Dynamics RMS Forum

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

Question Status

Unanswered

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 6:39 PM
My Badges

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

SBX - Two Col Forum

SBX - Migrated JS