Questions:
1. Is there any option (bypass) for access to Job Cost tables via ODBC driver?
2. Is there any option (bypass) to decrypt employee encrypted data from external app?
3. Which of tools are recommended for reading data from Sage Mas 100 in replace of ODBC for v2018 and greater?
The problem description:
The Sage MAS 100 system provides with us dictionaries data: Employees, Jobs, Cost Codes, Cost Code Types, Job Cost Details, etc.
In replacement our tool does supply for Sage MAS 100 Time and Expense entries.
Technically:
- for import data from Sage MAS 100 we use MAS 90 4.0 ODBC Driver.
- for export data to Sage MAS 100 we use - Visual Integrator Jobs.
So for properly exchange data between systems we need to have access to Sage MAS 100 tables:
PR1_EmployeeMaster, JC1_JobMaster, JC2_JobCostDetail, JCC_CostCodeMaster, JC0_Parameters, etc
Until today everything was fine, but since the Sage released MAS 100 2018 version with new security restrictions everything in sync process was broken.
Common change list:
1. Sage changed Tables/Fields names (eg PR1_EmployeeMaster was replaced to PR_Employee; EmployeeNumber to EmployeeNo)
eg Table [JC_Job] or [JC1_JobMaster] is not accessable or blank data in Employee case.
Example of sources:
help-sage100.na.sage.com/.../index.htm
help-sage100.na.sage.com/.../index.htm
2. Sage encrypt employee data(eg first, last name, etc are blank now) and add new crypted field: EncryptedVals
3. Sage closed access to Job Cost module (tables) via ODBC (perhaps to some others)
Likely to these changes raise a lot of troubles for any Sage integration for any companies.
Thus, currently we have errors: eg Table [JC_Job] or [JC1_JobMaster] is not accessible or blank data in Employee case.
Thank you