General Ledger -> Setup -> Financial statement -> Financial Statement

Finance and Operations/AX Developer Forum
1

Hi,

I want to get info from General Ledger → Setup → Financial statement → Financial Statement

->LedgerBalColumnsDim table. Do you tell me which table keep this info?

8883.FS3.JPG
8883.FS3.JPG942×565 95.3 KB

I will use these info in SQL Report Server. When I click the setup, it shows the table is used in tmpsysQuery. However, there have experience developer replied that tempsysQuery is not allowed query in SQL Statement.

Moreover, anyone would tell me the usage of “LedgerBalColumnsDimQuery” table? why the query field was kept info show at below:

8512.FS4.JPG