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

Notifications

Announcements

No record found.

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... / Sales Table in Busines...
Small and medium business | Business Central, N...
Answered

Sales Table in Business Central

(0) ShareShare
ReportReport
Posted on by Community Member

Hello.

I am using the Power Bi desktop and is already connected to Business Central as the source data:

1. What tables should we refer to in order to get the correct sales?

2. Which tables contain the sales data in which the credits (returns) have already been deducted?

Thanks. 

I have the same question (0)
  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    If you are looking for open sales or sales orders then you need to check the sales header and sales line table, but if you are looking for all sales then the best thing is to look at the Item Ledger Entry table and it has all the Cost Related fields.

  • Community Member Profile Picture
    Community Member on at

    Thanks Suresh!

  • AliHamza Profile Picture
    AliHamza 175 on at

    Hi,

    For Sales Orders: Table 36,37 (Sales Header, Sales Line)

    For Posted Sales Invoices: Table 112,113 (Sales Invoice Header, Sales Invoice Line)

    For Posted Sales Credit Memos: Table 114,115 (Sales Credit Header, Sales credit Line)

    Please verify my answer if it resolves your query

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Thanks Ali!

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans