Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

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

Posted on by Microsoft Employee

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
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Need tables names for the invoice, salesOrder, creditmemo, Inventory etc.

    Thanks for response, I will fix it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Need tables names for the invoice, salesOrder, creditmemo, Inventory etc.

    Thank you for your suggestion.

  • Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: Need tables names for the invoice, salesOrder, creditmemo, Inventory etc.

    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?

  • KareemTaima Profile Picture
    KareemTaima 304 on at
    RE: Need tables names for the invoice, salesOrder, creditmemo, Inventory etc.

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans