Copy user defined table using copy express

[Former Member]

I have created some user defined tables.I want to take backup of these tables using copy express.I created xml file for all these tables.When I copied the tables to another company only two fields were copied Code and Name.Rest of the fields were ignored.

[former_member187989 · Accepted solution]

hi dilip,

Check this note

Note 1268979 - Customization and updates of SAP Business One Add-ons

Jeyakanthan

[former_member708266]

Dear,

As confirmed by Development support,there are some runls for Copy

Express to judge a user table sould be copied or not.I am not sure

absolutely for it,but currently some tables will not be copied,like

the table name begin with : BA_,BD_,BSEWAS_,BNC_BB_...

So it is highly recommended please change the user tables name to

another one,and then it will be copied to the target db successfully.

Any other information you can give us about the test result,it would be

very welcome.

Thanks and best regards,

Apple

[Former Member]

When I create a user defined table it starts with @U_ .

UDT is manipulated from SAP B One.If I make any change from database then the changes are not reflected in SAP B One.Some or other problem is created if make change from database.So I manipulate UDT from SAP B One.

[msundararaja_perumal]

Hi,

Check this note:[940539|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=0000940539]

Also [984935|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=0000984935],[1118767|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=0001118767],[1059284|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=0001059284].

And i kindly recommend you to upgrade CX Addon to its latest patch.

Rgds

Sundar

[Former Member]

How do I fix this error ? Is there any new version of copy express where this problem is resolved ?

[msundararaja_perumal]

Hi,

Can you tell which Version of B1 and CX Addon is being used?