Lacerte Tax SDK / ODBC: How to insert new records into <CLIENT-NAME>-Detail (INSERT unsupported via ODBC)

[zurab]

Hi Lacerte Support / Tax SDK Team,

I’m using the Lacerte Tax SDK ODBC driver to read and update return data. My connection works fine for SELECT, and I can UPDATE existing rows in certain tables (e.g., <CLIENT-NAME>-Detail).

However, any attempt to INSERT a new row into <CLIENT-NAME>-Detail fails. Even a minimal literal INSERT causes the ODBC driver (LacerteCLIDSIODBC32.dll) to terminate the process, while UPDATE continues to work. This makes me think that INSERT into this table is not supported through ODBC and that new rows must be created through SDK business logic instead.

Could you please clarify:

1. Are tables like CLIENT-NAME>-Detail insertable via the Tax SDK / ODBC driver?

2. If ODBC INSERT is not supported, what is the correct SDK API/workflow to create a new record (detail row) for an Individual return?

   • Which class/method should be used?

   • What required fields/keys must be provided?

   • Are there any constraints on Series/Prefix/Code/Suffix or other hidden identifiers?

3. Is there any documentation or example code showing how to add a new “Detail” record using the SDK (not via ODBC SQL)?

4. Environment details:

   • Driver: LacerteDSIIDriver (32-bit)

   • TaxYear: 2022

   • ReturnType: Individual

   • App built x86

   My goal is to programmatically add new detail rows and then (if needed) update amounts/descriptions afterward. Any guidance or reference docs would be greatly appreciated.

   Thanks in advance,
   Zurab