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

(0) Share

Report

Posted on by Hatimali84

295

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:

Business Central

All responses (1)

Answers (0)

Suggested answer

Valentin Castravet 23,639 Super User 2024 Season 2 on at

Like (2)

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/