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 |
Thanks for response, I will fix it.
Thank you for your suggestion.
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?
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
#1
André Arnaud de Cal...
294,351
Super User 2025 Season 1
#2
Martin Dráb
233,029
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
