ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Import sales order data from csv file?
http://www.istechforum.com/YaBB.pl?num=1249917161

Message started by Chris82 on 08/10/09 at 08:12:41

Title: Import sales order data from csv file?
Post by Chris82 on 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

Title: Re: Import sales order data from csv file?
Post by Kelloggs on 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.

:P

Kelloggs

Title: Re: Import sales order data from csv file?
Post by Kelloggs on 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