Sage 100

Does anyone know of a method other than VI export to read the records from PR.TAXTBL? I'd like to access the table through ODBC, if possible. Any known 3rd part mods, scripts, etc.? Client is on Sage 100 2015 STD.

Excel, data from other sources?

I'm trying to pull the data directly into SQL, but it's not available as a table in the list of tables when using an ODBC connection. Other than doing a lookup in Tax Table Maint, or the VI Export, I have not come across any other available options. Although the VI export could be automated, I'd like to get at the data more directly.

Is it a one time export or something else?

It would be on going.

I have nothin.'

Why do you need to access the PR tax tables are you trying to bypass Sage PR module?

We import new employees. One of the states is Pennsylvania, which has a local tax code for schools, or PSD. PSDs are roughly based on the city and zip. Before I import an employee, I want to compare the employee's city, zip, and the PSD code they provided during the onboarding process to a table of PSD codes (about 2,300 of them). I then want to check if the cross referenced PSD code has been setup in the Tax Table file **by looking at existing local codes in Sage**. If it hasn't, I block the employee from importing and notify the user in an error report, which PSD needs to be added to the Tax Table file. We can't load all the PSD codes, because we only have 3 chars to use for the Local, so we load new ones as needed.

Use VI to Export the PRTaxtbl for the codes you need. Set up the export to run via Task Scheduler maintenance at the interval that you need to refresh the data for the program that you use to import new employees.

I like Access as a middle program between Sage and any other 3rd party program. It allows manipulation of data and uses ODBC

@ChrisStAmand said that the PRTaxtbl isn't available via ODBC. Access is good to use, agree, when it's possible.

Yes, unfortunately there are a few PR files that are strangely unavailable through odbc.