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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Need tables names for the invoice, salesOrder, creditmemo, Inventory etc.

(0) ShareShare
ReportReport
Posted on by

Hi, 

I want to check some data from database directly in AX. Could you please let me know what are the corresponding tables for the following transaction:

Table
CreditMemoHeaders
CreditMemoLines
Customer - SalesInvoiceHeaders
CustomerProducts
Customers
FxRates
GeneralLedger
InventoryLedgerList
PaymentJournal
Products
SalesInvoiceLines
SalesOrderHeaders
SalesOrderLines
Transactions
UnitofMeasure
I have the same question (0)
  • KareemTaima Profile Picture
    304 on at

    As far as I can understand from your post, you should check CustInvoiceTrans, CustInvoiceJour and SalesTable for the invoices and sales orders

    and you may use personalize option, you'll find your answers faster

  • Martin Dráb Profile Picture
    237,880 Most Valuable Professional on at

    Your list is displayed in a weird way. Could you fix it, please?

    By the way, finding many of them should be rather easy. For example, do you know that you can find object names directly from AX GUI?

    Nevertheless some make little sense. For example, "Inventory" is a whole part of the application, not a single table. You should specify what exact information you're looking for. You can also find out that looking at certain data directly in database is pretty complicated. For example, if you want to see get the available quantity of an item, regardless of inventory dimensions, you'll have to calculate it by yourself. Also, don't forget to take into account DataAreaId and Partition.

    What exactly are you trying to achieve and why do you believe that bypassing AX business logic (and security, caching etc.) will be better?

  • Community Member Profile Picture
    on at

    Thank you for your suggestion.

  • Community Member Profile Picture
    on at

    Thanks for response, I will fix it.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans