copy the data

Finance and Operations/AX Technical Forum
1

hi

i have two tables 1. postable 2.sostable

postable fields are Custacct, Custname,Addresss, COntactNo

Sostable fields are Accid ,Name

i want to move the all Cust acct field values to Accid ,CustName values to Name

how to do it …

2

Do you want to copy all records from one table to the other? In that case, I would use insert_recordset. See the following example (not tested):

insert_recordset sosTable (AccId, Name)
    select CustAccount, CustName from posTable;
3

its not working …