Thanks All,

My current filter for testing is:

Code:
AND( 
OR(
{D: Doc Type} ="C",
{D: Doc Type} ="I"),
{Date}  >= 43435,
{Date}  <= 43465,
LEFT({D: Category},2) <>"RC",
LEFT({Item #},2) <>"SH",
LEFT({Item #},2) <>"DE",
{Line Type} ="R"
)

This is showing All invoices and credit notes between Dec 1st to Dec 31st 2018, and filtering out RC item codes (Recycle Fees) and SH & DE (Shipping and Delivery). I have exported this list and compared it to our GL account for sales and it matches exactly except for two things.

AP/AR direct entries (Do not need to fix)
Credit Notes that do not have an order number.

I have changed the filter to not include anything other than

Code:
OR(
RIGHT({CN #}="59370",5),
RIGHT({CN #}="59378",5),
RIGHT({CN #}="59380",5),
RIGHT({CN #}="59409",5),
RIGHT({CN #}="59412",5),
RIGHT({CN #}="59414",5),
RIGHT({CN #}="59464",5),
RIGHT({CN #}="59472",5),
RIGHT({CN #}="59547",5),
RIGHT({CN #}="59558",5)
)


This returns no results. I have tried looking at this view without any filters and I cannot find the 10 credit notes that way either. The only common thing about these credits in OE is they all are Order Number "No Order". I believe these do not appear in this GV, no matter what I make my filter.

Thanks,
_________________________
Lance Tennier
TDL Canada