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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (