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

[Steffan]

Unfortunately, this seems to be broken for another year. 😕 Querying 2024 Lacerte for a column that definitely exists, C7_191 results in "Column not found: C7_191". Meanwhile, that custom filter works just fine in 2024 Lacerte.

[Kathi_at_Intuit]

Hi @Steffan  Thanks for posting in the Community and bringing this to our attention! This has been fixed with SDK version 1.0.0.495. Happy Holidays!

[Steffan]

I can confirm this is absolutely fixed with the latest SDK. Thanks so much!

[Kathi_at_Intuit]

Welcome, thanks for the update and for the patience.  We will let development know.