web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Aligning Jet Reports T...
Small and medium business | Business Central, N...
Suggested Answer

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

(1) ShareShare
ReportReport
Posted on by Hatimali84 679
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
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,800 Super User 2026 Season 1 on at

    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/
     

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 102,079 Super User 2026 Season 1 on at
    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)
     
    Hope this helps as well.
    Thanks.
    ZHU
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 102,079 Super User 2026 Season 1 on at
    Update: Dynamics 365 Business Central: How to export all pages with SourceTable number (list of pages with corresponding tables)
     
    Thanks.
    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,713 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,032 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 914 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans