**edit: Solved I was missing the AP_OpenInvoice file (duh)
What setting do I have turned on, or what file am I missing? Customer is getting a Vendor Code 9 when running the AP Aged Invoice History report. I have checked to ensure the ""NULL Date"" is UNCHECKED in ODBC, and when I pull data into Excel or Query, I expect to get an error saying the data cannot be retrieved - but I don't get it. Initially, I had the Null date checked, thinking I would be able to identify the incorrect date, but couldn't see anything other than the occasional posting to year 2023 or whatever - but all valid dates. I even tried making a new ODBC connection in case something was stuck. Maybe I am not checking all the right files for the Aging? I don't get the error when pulling into Crystal Reports either.
(pulled all fields with the word 'date')
AP Invoice History Header / Detail
AP Transaction Payment History
I even checked AP Check History and Detail so I am thinking I have something turned on so it will not error out? Thoughts? TIA!
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=24679&sliceId=1&cmd=displayKC&dialogID=378707&docType=kc&isLoadPublishedVer=&stateId=378726&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl