Previous Day Cancellations
- Kaitlyn Niemann (Unlicensed)
- Albert Saludaga
Requirements and Purpose
Displays cancellations from the previous day. This includes fully cancelled PO's, as well as individual line items. Date range is modifiable.
Report Definition
Stakeholders
Kaitlyn Niemann
Lori Setser
Author
Kaitlyn Niemann
Subject matter expert(s)
Kaitlyn Niemann
Presentation Medium
SSRS
Fields (data)
Cancel Date Time
Order Number
Event Info
Nick Name
Cancelled Amount
Note
User
Data Source(s)
The data from this report is gathered from the Eibo-215 Database.
Tables:
dbo.BuyOrder
dbo.BuyOrderTicketGroup
dbo.Event
dbo.OrderAdjustmentRegister
dbo.OrderPayment
Calculations
Column Name | Data Type | Calculation | Description |
|---|---|---|---|
Cancelled Amount | Numeric | =SUM(can.CanAmount) | Sum of all cancelled lines for a given po. |
NameOnCard | Varchar | =LEFT(OP.NameOnCard,CHARINDEX(' - ',OP.NameOnCard) | Reduces name on card to nickname on card. |
Parameters
Filters
@StartDate DATETIME
Beginning of date range for search
Default value is previous day.
@EndDate DATETIME
End of date range for search
Default value is current day.
Grouping
can.PONumber,
OP.NameOnCard,
oar.FinalizedDateTime,
can.EventName
Intentions for printing vs. online viewing
The report is delivered via SSRS
This report can be accessed here: SSRS→Admin→Previous Day Cancellations
Intended delivery mechanism (run on demand vs. delivered by subscription)
Run on demand.
Future maintenance tasks or manually maintained items
None
Results
Data Accuracy
QA
Validate against PO and Invoice Register reports in eibo.
Limitations
n/a