Found an interesting issue with 2023 on my workstation. Programs on workstation, shared data and programs on server. Server and SQL are 2019.
I use Customization Directories to keep my modified forms and my clients' forms separate. Especially the PO and OE forms which I try to use the ODBC forms. Anyway, I went to print the default OE invoice 01 in Sample Company Inc and received the "Error in File.....The table could not be found" error. I logged onto the server and test printed from the server and had no issue.
Thinking I modified the OERPT.INI file in the programs folder, I went to set back to normal using "datapipe," but I found that I had not changed it. I tried everything copying OEINV01 and OEINPR3.dll from the server to my workstation. Same error. Tried OEINV02 and got the same error. I then proceeded to un-install then re-install 2023 but there was no change. I un-installed and renamed the program folder and re-installed to a new program folder. No Change. All this trying to print a standard OE invoice from SAMINC. Printing a datapipe report from PO was no problem.
The problem I found is the customization directories. If I removed the entries for custom folders, I was able to print a datapipe report in OE. Once I put it back, the "table not found" error came back. I used local workstation path and then UNC for server folder path and neither worked.
I thought maybe a user rights issue but I have no problem with a PO datapipe report. Now I am stumped.
Any suggestions??
Thanks in Advance.