steven
Level 5

We have recently installed Lacerte 2023. Clients have all been Proforma'd.

We have previously installed the Lacertetax-SDK-Installer-64-1.0.0.418.msi and it works fine with prior years tested.

I have created new ODBC connections for each Tax type, however I am unable to connect to the \LACERTE\23tax\IDATA or the \LACERTE\23tax\PDATA.

I am using MS Excel to test the ODBC Connections. When building the connection or when trying to Refresh data from a saved connection, I can access all of the tax types other than the Individual and the Partnerships. When attempting to open the Individual or Partnership types I receive error

     [dataSource.Error] The Table has no visible columns and cannot be queried.

On one occasion while attempting to refresh a connection in the saved file I received the error:

     Mapping Error:Reinstall Lacerte to fix this problem. Mapping file not found: C:\Program Files (x86)\Common Files\Lacerte Shared\LacerteSDK\2023\mappings.xml

If I go to the location specified there is no 2023 folder. In the 2022 or 2021 folders I do find a mappings.xml file, along with a number of DLL files. The mappings.xml file appears to have mappings for the 2 problem tax types, but no others.

The 12/6/2023 (44.0004) update has not created the missing folder or fixed the error.