Insert Table AXAPTA From query insert in SQL Management Studio

Finance and Operations/AX Developer Forum
1

Guys, i need your help.

i have a table in AXAPTA database, and then i insert data into the table with query in sql management studio. but in AXAPTA i didnt find the data that i insert. can you give the solution?

2

Synchronize the database from AX and still if you not able to see the data in AX then please let me know the tables in which you inserted the data from SQL.

Administration->Periodic->SQL administration->Table actions->Synchronize database

3

Hi,

As much as possible, NEVER INSERT data into AX table directly from SQL.

In your case, what dataarea Id did you enter from SQL?

4

thanks harish, so what is the solution?

5

there is another way?

6

there is another solution?

7

Hi,

Can you let us know the following -

  1. What table(s) are you inserting data into?

  2. And what are you trying to achieve?

8

I have data in another Database and i want to insert the data into Database AXAPTA. the table AXAPTA that i want to insert is a new table in AXAPTA.

my solution is, i create agent job in SQL Server, the agent can run every night. but it didnt work.

could you help me harish? thanks…

9

You need to insert the following fields with their respective value-

1)All mandatory fields of the table
2)RECID( Insert a bigint value)
3)RECVERSION(Value-1)
4)DATAAREAID(Company ID)

After insertion of data, synchronize the database from AX as mentioned in my previous post.

10

hi guys, thanks for your reply. it works! the problem is in field DATAAREAID. when i insert data, the default is DAT. so it didnt show in my company ahahaha