I am on Sage 100, 2020, Premium (SQL) version 6.20.0.1
I have customized the Purchase Order report and it works fine from purchase order printing until in crysal reports I link the inventory memo table to the purchase order wrks table. As soon as I do that, I recieve the following error.
The database login failed. Failed to open the connection. PO_PurchaseOrder2 16728_17840_{9F6A92E0-2009-4DCB-9531-1B69F1296DED}.rpt Details:
[Database Vendor Code: 4060 ]
I have tried changing joins, using a report and tying the report, anything that I try to tie to the wrks file fails. Any help would be greatly appreciated.