-
home page
-
vtenext - Official Forum
-
vtenext CE
-
Import/Export of Sales Order
Import/Export of Sales Order
Less
More
-
Posts: 7
-
Thank you received: 0
-
-
18 Feb 2013 13:44 #2718
by menonmat
Hi,
I would like to know if there is a method to Import/Export Sales Order throw a CSV file like the Accounts.
Thanks
Please Log in to join the conversation.
Less
More
-
Posts: 380
-
Thank you received: 26
-
-
18 Feb 2013 21:12 #2720
by dende
There aren't any standard functionality to do that.
Because salesorder have products/services in it (salesorder's body), you must populate product and/or services first and pass the relatives ids.
A CSV file is suitable only for standalone entities
Regards
Please Log in to join the conversation.
Less
More
-
Posts: 7
-
Thank you received: 0
-
-
19 Feb 2013 09:26 #2721
by menonmat
Thanks for the reply.
I have to import data of Accounts and Sales Order from an old ERP.
For the Accounts and Products I can use the CSV functionality;
for the Sales Order I have to import data directly in MySql database? Are there other methods?
In case 1 I have to match:
vte_salesorder.accountid = vte_account.accountid
vte_inventoryproductrel.id = vte_salesorder.salesorderid
vte_inventoryproductrel.productid = vte_products.productid ?
For the values of salesorderid I have to start from the current value of vte_crmentity_seq and increment for every Sale Order?
Are there other tables to update?
Thanks and sorry for the many questions.
Please Log in to join the conversation.
-
home page
-
vtenext - Official Forum
-
vtenext CE
-
Import/Export of Sales Order
Time to create page: 0.102 seconds