Missing Table in AL

(4) Share

Report

Posted on by Kevin Fernandez

Hi,

I am creating an extension in Visual Studio Code for Business Central and need to update a table, specifically "Statistical Acc. Journal Line". It tells me it is missing, so I assume the reference wasn't downloaded as it does not appear in the AL Object Designer. Should it download automatically? If not, is there a way to add this table to Visual Studio Code so that I can access it?

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

Padmavathy 124 on at

Like (3)

Report
If you're trying to access the "Statistical Acc. Journal Line" table in your AL project but it's missing from symbol references, it's likely because this table is part of the Statistical Accounts extension by Microsoft, which is not included by default in symbol downloads.

Go to Business Central → Extension Management

Check if "Statistical Accounts" is installed.

If not, install it from AppSource or publish it manually if you have the .app file.

Add the Dependency in app.json

"dependencies": [{

"appId": "GUID_HERE", "name": "Statistical Accounts", "publisher": "Microsoft", "version": "x.x.x.x" } ]

Replace with the actual App ID and version from Extension Management.

Download Symbols in VS Code

Open Command Palette (Ctrl+Shift+P)

Run AL: Download Symbols

Once these steps are completed, the "Statistical Acc. Journal Line" table should appear in IntelliSense and your project should compile without issuses.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (2)

Report

Hi, good day

You must download the symbols.

Download symbols from BC Online Sandbox environment

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

It's not part of the base apps. You need to have dependency to Statistical Accounts app in your app.json.

"dependencies": [

{

"id": "ea130081-c669-460f-a5f4-5dde14f03131",

"name": "Statistical Accounts",

"publisher": "Microsoft",

"version": "1.0.0.0"

}

]

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (2)

Report

Hi, hope the following helps as well.

Business Central 2025 wave 1 (BC26): New VS Code actions from the Web Client (Generate launch configurations and Get selected as dependencies on the Extension Management)

https://yzhums.com/62106/

Thanks.

ZHU

Was this reply helpful? Yes No