Hi,
we have customized the POPOR01.rpt report of PO module, by adding few PJC tales to get the Contract details in the PO report. It was running fine with Accpac version 5.5A, then we upgrade the system to 5.6A and 6.0A. the report runs fine without requiring any modification or ODBC refresh. but since we have upgraded the Sage Accpac to version 6.2A, the Report is not working. It gives error "Failed to open Database". I have tried to refreshed the ODBC, after that the report prompt for SQL Credentials(after giving the SQL info, the report prints fine.) and it keep on asking every time we run it.
If any one wants to check, u can just need to add PMCONTS table to POPOR01.rpt.
Any suggestion will be highly appreciable.
Thanks
AV
we have customized the POPOR01.rpt report of PO module, by adding few PJC tales to get the Contract details in the PO report. It was running fine with Accpac version 5.5A, then we upgrade the system to 5.6A and 6.0A. the report runs fine without requiring any modification or ODBC refresh. but since we have upgraded the Sage Accpac to version 6.2A, the Report is not working. It gives error "Failed to open Database". I have tried to refreshed the ODBC, after that the report prompt for SQL Credentials(after giving the SQL info, the report prints fine.) and it keep on asking every time we run it.
If any one wants to check, u can just need to add PMCONTS table to POPOR01.rpt.
Any suggestion will be highly appreciable.
Thanks
AV