Welcome, Guest. Please Login.
11/05/24 at 09:30:25
News:
Home Help Search Login


Pages: 1
Send Topic Print
Import sales order data from csv file? (Read 957 times)
Chris82
Browser
*


I Love EvoERP!

Posts: 22
Gender: male
Import sales order data from csv file?
08/10/09 at 08:12:41
 
Is it possible to import sales order data from a CSV file (or any remote file for that matter)? I've looked in the DE menu but haven't found any items pertaining to sales order. Thank you
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Import sales order data from csv file?
Reply #1 - 08/10/09 at 09:53:47
 
From Evo Help File:
 
 
EDI Overview
 
The EDI module that allows you to receive customer orders and send out customer invoices via EDI (Electronic Data Interchange).  The programs in this module are designed to work with the CanDo EDI software from Technology Management Programs (TMP), a value added network (VAN) company that will set up connections with your EDI business partners and guide you through the EDI implementation process.
You can also work with any other EDI provider but you need to have any incoming orders converted to a format that matches the DBASO.IN file that the ED-B program can read.  
 
A data map is available at http://www.istechsupport.com/dl/edimap.zip.
 
 
 Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Import sales order data from csv file?
Reply #2 - 08/10/09 at 11:53:57
 
I did some testing and there is a way to import sales order data from a cvs file.
 
If you import the SO data directly to BKEDIH (BKARINV) and BKEDIL (BKARINVL) then run
ED-D, the data is convert to an Sales Orders. It works fine.
 
I notice that EVO assign its own Sales Order Number, and you have to manually delete the data on the EDI tables (BKEDIH and BKEDIL)
using ED-C
 
Anyways, so I guess it is posible.
 
Regards,
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print