Issue Querying DATA7 in 2023 Lacerte/Individual Module

[Steffan]

I am unable to query a column that I know exists using the Lacerte SDK.

I have created a custom filter which points to column C7_190. My CTS001.IW3 file says:

"C7_190,is,1,1="

However, if I try to query this column, I get "DataSource.Error: ODBC: ERROR [42S22] [Lacerte][SQLEngine] (31750) Column not found: C7_190"

For some reason, the SDK seems unable to query a column that definitely exists.

Anyone else have a similar issue?

[kamprich]

I have the same problem with the Series 1 table.   The easiest way to debug is to use the Excel ODBC interface and dump the table of a client.    Then you can see the actual codes and series for the query since Intuit doesn't document any of the tables.    You can get more info about the ODBC Excel connection in SDK documentation.

Regards,

Rick Kamp, EA

[Steffan]

Hi Rick,

You might find these files useful: "C:\Lacerte\24tax\2024.3.5.0\ind\usdbdef.i24" "C:\Lacerte\24tax\2024.3.5.0\fid\usdbdef.f24" (etc)

There is one for each module and they define most of the columns. It is no help for Table 7, though, as that table is different from the others and isn't fixed for everyone. It's confusing to me, maybe Robert can explain if he sees this thread. 😛

Best,

Steffan