Sage 300 Construction and Real Estate: 16.1 PR Time table has an ODBC error in the End field, worked in 15.1 to import won't in 16.1

We use ODBC to pull in the data tables and have reports that are formatted and easily refreshed from this. We were on 15.1 and could bring the whole PR Time table into excel via ODBC and refresh and use that table. When we upgraded to 16.1 we found an error, the table will not import unless excluding the End field. Please correct so the whole table pulls in and refreshes with ODBC.

by: Erin A. | over a year ago | 8 Reports and Inquiries

PR_Current_Time "End" field causes table to not pull in via ODBC in 16.1 but worked in 15.1

PRM_Master_Company_Tax fields "Percent" and "Limit" causes table not to pull in via ODBC in 16.1 but worked in 15.1

PRX_TAX_TAX field "Limit" causes table not to pull in
via ODBC in 16.1 but worked in 15.1

PRS_System_Fringe field "Limit" causes table not to pull in via ODBC in 16.1 but worked in 15.1

by: Erin A. | over a year ago

2

16.1 PR Time table has an ODBC error in the End field, worked in 15.1 to import won't in 16.1

Comments