ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> importing Sales Orders
http://www.istechforum.com/YaBB.pl?num=1213288204

Message started by CRBlount on 06/12/08 at 09:30:04

Title: importing Sales Orders
Post by CRBlount on 06/12/08 at 09:30:04

Is there a way to import Sales order information from an MS Access entry? I am trying to prevent double entry of shipping information. We are running DBA classic Version 2004.1 IS Tech Support update 12/15/07.

Title: Re: importing Sales Orders
Post by HB on 06/12/08 at 12:11:02

We are doing something like that with one customer who provides a xls spreadsheet. We link that spreadsheet to an access table and then do queries that create SOHEAD, SOLINE and SONOTES tables. From those table we create a flatfile (there is a special layout map available). This flatfile can then be imported into the EDI module under "Import EDI orders".

Title: Re: importing Sales Orders
Post by RPCAdmin on 06/12/08 at 12:40:44

'Bout the only way I can think of doing it. (Using the EDI module) There are some quirks with the EDI module that may affect how you import the data.

Title: Re: importing Sales Orders
Post by GasGiant on 06/12/08 at 12:50:26

:-X