Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
Hi,
I would like to get data out of AX to another SQL database.
When I create a Table in AOT, how come it does not create a table at SQL database level?
I've test with TableType Regular, TempDB, but no luck.
Please assist. Thanks
Vi
I've found the solution. When I used _Customer table in AOT Data Dictionary.
At database level it shows as XCustomer
Thank you SQL Trace
Did you synchronise the databse (new created table)?
My table name is _Customer.
Yes, I have synchronize the database
1. System administration > Periodic > Database > SQL administration. On the Table actions menu, click Synchronize database --- no luck
2. In AOT right click on Data Dictionary and Synchronize -- still no luck
Please assist.
what Ax is saying when you try to insert any record into that table (from AX)?
I've a Job script to do insert data into that table. I've just ran it and it works fine. I am also able to browse the data in it.
This is bizzarre