Copy One Table data from one company to another company table

Dynamics 365 Business Central/NAV User Forum
#1

I have a company test1 in which i made a table table1 with 4 fields.

I have another company test2 with a table table2 with the same fields as table1.

but i have data only in table1 which i want in table2 too…

how can i copy data from table1 to table2…

#2

which version r u using

#3

I am using NAV 2009

#4

NAV 2009 R2

#5

Write dataport and extract data from table1 and using same dataport import data in table 2.

#6

You can Copy Paste data from Table1 to Table2 directly with CTRL+C and CTRL+V.

If both the tables will have same data every time and forever then set DataPerCompany property to NO, use this property on your own risk cause this property is not reversible until both the table data are blank.

#7

You can use CHANGECOMPANY function also

http://mohana-dynamicsnav.blogspot.in/2013/02/how-to-updatemodify-data-in-all.html

#8

Thanks Mohana