Small and medium business | Business Central, N...

Aligning Jet Reports Table Builder - Table Names with Business Central Table Names

(1) Share

Report

Posted on by Hatimali84

364

Hi all,

Is there a way to easily determine the naming convention between Jet Reports and Business Central? I find it challenging to select the correct table in Jet Reports. For instance, "Posted Purchase Invoice Lines" in Business Central is known as "Purch. Inv. Line" in Jet Reports.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

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

Like (1)

Report

Aligning Jet Reports Table Builder - Table Names with Business Central Table Names

Update: Dynamics 365 Business Central: How to export all pages with SourceTable number (list of pages with corresponding tables)

https://yzhums.com/58015/

Thanks.

ZHU
Suggested answer

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

Like (2)

Report

Aligning Jet Reports Table Builder - Table Names with Business Central Table Names

The name of the table is displayed in Jet Reports.

If you want a list, you can directly open table 2000000058 AllObjWithCaption from the UI, and then filter Object Type to table.

PS: Dynamics 365 Business Central: Is there an easy way to check if a standard/base object has been extended? (Extended object list)

https://yzhums.com/50977/

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Valentin Castravet 28,272 Super User 2025 Season 1 on at

Like (3)

Report

Aligning Jet Reports Table Builder - Table Names with Business Central Table Names

Business Central and Jet Reports use the same table names because Jet Reports simply displays data from your Business Central database without modifying any table or field names.

It seems there may be some confusion between Business Central Pages and Tables. For instance, in Business Central, the page is called Posted Purchase Invoice Lines, but the underlying table is actually Purch. Inv. Line.

Hope this blog post clarifies the difference pages and tables in Business Central - How to Identify Business Central Page, Table, & Report Object Numbers - Dynamics 365 Business Central Insights

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/