I have a report that is currently working and in production. Connected to 8 tables in SQL via ODBC.
I added 2 more tables, check the links tab, everything looks OK.
But when I run the report from Microsoft Business Solutions (Great Plains), I get the "table could not be found" error.
and when I remove the 2 tables again, the reports runs OK.
I must be missing some steps after adding the 2 tables, but I could not figure it out.
Can anyone help me please?
Thank you in advance