Added
false
198
114
All Open Invoices
All Invoice line items with amount due greater than 0, sorted by date due.
Select
Profile_View_Profile_ProfileId As 'Profile ID', Profile_View_Profile_ReportName As 'Profile Report Name', Profile_View_MembershipLevel_Name As 'Profile_View_MembershipLevel_Name', RevenueItems_ItemName As 'Revenue Item Name', AdjustedLineItemAmount As 'Adjusted Line Item Amount', AdjustedPaymentAmount As 'Adjusted Payment Amount', AdjustedAmountDue As 'Adjusted Amount Due', Invoice_InvoiceNum As 'Invoice Number', CONVERT(CHAR(10), Invoice_DateDue, 101) As 'Date Due', Profile_View_BC_ReportName As 'Billing Contact''s Report Name', Profile_View_MC_ReportName As 'Main Contact''s Report Name', Profile_View_Profile_AssignedToUserName As 'Profile Assigned Username'
From
Invoice_View
Where
(AdjustedAmountDue > 0)
Order By
Invoice_DateDue Asc, Profile_View_Profile_ReportName Asc, Invoice_InvoiceNum Asc
2016-10-03T09:24:37
2016-10-03T09:24:37
lbashaw
Invoice_View
false
0
false
Unchanged
false
0
0
false
Daily
1
1
false
2016-10-03T00:00:00-07:00
2016-10-03T00:00:00-07:00
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
Added
false
Invoice_View
Profile_View_Profile_ProfileId
Profile ID
System.Int32
4
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
Profile_View_Profile_ReportName
Profile Report Name
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
Profile_View_MembershipLevel_Name
Profile_View_MembershipLevel_Name
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
RevenueItems_ItemName
Revenue Item Name
RevenueItems
ItemName
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
AdjustedLineItemAmount
Adjusted Line Item Amount
System.Double
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
AdjustedPaymentAmount
Adjusted Payment Amount
System.Double
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
AdjustedAmountDue
Adjusted Amount Due
System.Double
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
Invoice_InvoiceNum
Invoice Number
System.Int32
4
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
Invoice_DateDue
Date Due
System.DateTime
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
Profile_View_BC_ReportName
Billing Contact's Report Name
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
Profile_View_MC_ReportName
Main Contact's Report Name
System.String
300
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
Profile_View_Profile_AssignedToUserName
Profile Assigned Username
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
Invoice_View
AdjustedAmountDue
Adjusted Amount Due
System.Double
8
false
GreaterThan
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
Added
false
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Modified
false
Invoice_View
Invoice_DateDue
Adjusted Amount Due
System.Double
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Modified
false
Invoice_View
Profile_View_Profile_ReportName
Adjusted Amount Due
System.Double
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1
Modified
false
Invoice_View
Invoice_InvoiceNum
Adjusted Amount Due
System.Double
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-10-03T00:00:00-07:00
0
0
Ascending
AndJoin
1