-
home page
-
vtenext - Official Forum
-
vtenext CE
-
Import/Export of Sales Order
Import/Export of Sales Order
Riduci
Di più
-
Messaggi: 7
-
Ringraziamenti ricevuti 0
-
-
18/02/2013 13:44 #2718
da 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
Si prega Accedi a partecipare alla conversazione.
Riduci
Di più
-
Messaggi: 380
-
Ringraziamenti ricevuti 26
-
-
18/02/2013 21:12 #2720
da 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
Si prega Accedi a partecipare alla conversazione.
Riduci
Di più
-
Messaggi: 7
-
Ringraziamenti ricevuti 0
-
-
19/02/2013 09:26 #2721
da 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.
Si prega Accedi a partecipare alla conversazione.
-
home page
-
vtenext - Official Forum
-
vtenext CE
-
Import/Export of Sales Order
Tempo creazione pagina: 0.150 secondi