Missing Table in AL

(2) 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

All responses (4)

Answers (3)

Verified answer

YUN ZHU 84,274 Super User 2025 Season 1 on at

Like (1)

Report

Missing Table in AL

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
Verified answer

Teddy Herryanto (Th... 13,695 Moderator on at

Like (0)

Report

Missing Table in AL

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"

}

]
Gerardo Rentería Ga... 19,644 Most Valuable Professional on at

Like (1)

Report

Missing Table in AL

Hi, good day

You must download the symbols.

Download symbols from BC Online Sandbox environment

Best Regards
Gerardo
Verified answer

Padmavathy 27 on at

Like (2)

Report
Missing Table in AL

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.