I have a standard schedule report to export a file containing invoice information to be uploaded on Finance's database. The problem is that I only have a invoice added to the system date to work with, depending on the invoice status the report will only send completed invoices added on to the system in the last 7 days.
So far so good, however if the invoice status is incomplete for more than 7 days the report will not pick up on these records.
I am trying to add an event based schedule in order to solve this problem.
The dataset comes from a ODBC data source which I can find under the DSN Name list, and when it connects I can find the table I need. However when I try to build the query and click Parse I get the following error:
[Cache ODBC][State : S0002][Native Code 30]
[SQLCODE: <-30>:<Table or View not found>]
[Cache Error: <<SYNTAX>errdone+3^%qaqqt>]
[%msg: < Table 'SQLUSER.XORDER_INVOICE' not found>]
Thank you very much in advance :)