Using Wholesale Electronics to Get Organized

electronic

We would really like to provide you – programmer, software developer, database administrator that the primary clues on producing EDI formatted text out of Microsoft Great Plains database. Pleasenote however Great Plains here is chosen for example, similar approach will probably continue to work for other SQL based approaches: Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and also other non-Microsoft products. In the instance of non-SQL system, such as older Great Plains Dynamics, ACCPAC on Pervasive SQL – IDE port will involve ADO/ODBC or even Microsoft Access programming.

1. Sample Query – The electronic contract manufacturing below uses CAST construction to create the effect fixed-length and match up with the positioning. And also the unionizing lets to generate Header and Detail in a select statement. This we are dealing with work Revenue Records

Pick

Case

Else CAST(‘Detail’ as char(10))

end

as FIELD0,

Case

Else cast(cast(b.QTYDMGED as decimal(19,5)) as char(65))

end

as FIELD01,

The event

If b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1 then CONVERT(char(51), a.DOCDATE, 101)

Else cast(b.ITEMDESC because char(51))

end

as FIELD03

–Additional disciplines go here

From SOP10100 a unite SOP10200 Bon a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join

CUSTNMBR

Join

(choose SOPTYPE like SOPTYPE, SOPNUMBE as SOPNUMBE,

LNITMSEQ

as LNITMSEQ,

CMPNTSEQ

Union

Select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ in SOP10200

Set by SOPTYPE, SOPNUMBE

) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE

Left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE

Where a.ADDRESS3’Exported’ and also

A.SOPTYPE=3 and upper(d.USERDEF2)=’YES’

Order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc


2. Mark processed documents – for this reason we use SOP10100.ADDRESS3 field – that wasn’t used at Great Plains Dynamics/eEnterprise version 6.0:

Upgrade SOP10100 place ADDRESS3=’Exported’ where SOPTYPE=3


3. Communication using UNIX EDI Client or Server – each case requires individual strategy. You may have to assign the document directory, confronted with the UNIX platform or utilize old DOS command to move the document, or you can get automatic email. Very good thought would be to write communication software in your favorite programming language

4. Scheduled DTS Package – you should likely make DTS package to do All of the measures: phone SQL Query and save it as a file, then telephone DOS control or easy EXE application – which does convey with UNIX

 

Leave a Reply

Your email address will not be published. Required fields are marked *