Edi: electronic authenticate intersection for microsoft great plains ? overview for software developer/pr - software
Microsoft Great Plains - Microsoft Affair Solutions accounting and ERP system, firstly under attack to mid-size - now, with advancements and escalating reliability of its catalog - Microsoft SQL Server, Great Plains is appealing elucidation for large corporation. Big companies as a rule have purchasing and order dealing out mechanization via so-called Electronic Certificate Exchange or EDI. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Preview of predefined fixed attitude fields.
We would like to give you - programmer, software developer, folder commissioner the core clues on producing EDI formatted text from Microsoft Great Plains database. Please, note but that Great Plains here is taken as the example, alike advance will work for other SQL based systems: Navision (SQL Folder or C/SIDE database), Microsoft RMS, Solomon as well as Foreshadowing and other non-Microsoft products. In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on All-encompassing SQL - IDE boundary will affect ADO/ODBC or Microsoft Admittance programming.
1. Appraise Query - The query below uses CAST construction to make the conclusion fixed distance end to end and meet the positioning. Plus the unionizing allows to be the source of Description and Allocate in one choose statement. Here we are industry with work Sales Documents
when b. LNITMSEQ=c. LNITMSEQ+1 and b. CMPNTSEQ=c. CMPNTSEQ+1 then CAST('Header' as char(10))
else CAST('Detail' as char(10))
when b. LNITMSEQ=c. LNITMSEQ+1 and b. CMPNTSEQ=c. CMPNTSEQ+1 then cast(a. CUSTNAME as char(65))
else cast(cast(b. QTYDMGED as decimal(19,5)) as char(65))
when b. LNITMSEQ=c. LNITMSEQ+1 and b. CMPNTSEQ=c. CMPNTSEQ+1 then CONVERT(char(51), a. DOCDATE, 101)
else cast(b. ITEMDESC as char(51))
--Additional fields go here
from SOP10100 a join SOP10200 b on a. SOPTYPE=b. SOPTYPE and a. SOPNUMBE=b. SOPNUMBE join
RM00101 d on a. CUSTNMBR=d. CUSTNMBR
(select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE,
as CMPNTSEQ from SOP10200
select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200
group by SOPTYPE, SOPNUMBE
) c on a. SOPTYPE=c. SOPTYPE and a. SOPNUMBE=c. SOPNUMBE
and ((b. LNITMSEQ=c. LNITMSEQ and b. CMPNTSEQ=c. CMPNTSEQ) or (b. LNITMSEQ=c. LNITMSEQ+1 and b. CMPNTSEQ=c. CMPNTSEQ+1))
left join SOP10106 udf on a. SOPTYPE=udf. SOPTYPE and a. SOPNUMBE=udf. SOPNUMBE
where a. ADDRESS3'Exported' and
a. SOPTYPE=3 and upper(d. USERDEF2)='YES'
order by a. SOPTYPE, a. SOPNUMBE, b. LNITMSEQ asc
2. Mark processed id - for this aim we use SOP10100. ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise account 6. 0:
update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3
3. Announcement with UNIX EDI Client or Ma?tre d' - each case requires characteristic approach. You may have to assign the file directory, exposed to the UNIX arrangement or use old DOS be in charge to move the file, or you can have certain email. Good idea is to write communiqu? appliance in your desired indoctrination language
4. Scheduled DTS Embalm - you be supposed to in all probability construct DTS box up to do all the steps: call SQL Query and save it as a file, then call DOS authority or clean EXE appliance - which does be in contact with UNIX
Happy programming! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum. com
About The Author
Andrew Karasev is Chief Expertise Administrator in Alba Spectrum Technologies - USA countrywide Great Plains, Microsoft CRM customization company, based in Chicago, California, Colorado, Arizona, New York, Texas, Florida, Georgia and having locations in compound states and globally (www. albaspectrum. com), he is Dexterity, Deal with SQL, C#. Net, Gem Hearsay and Microsoft CRM SDK developer; akarasev@albaspectrum. com
Ukraine IT Myths Dispersed
While Ukraine is appropriate a new common IT outsourcing destination, there are still many myths about it and no clear accepting of the opportunities outsourcing to Ukraine can present. Let us look close up at some of those myths and find out whether there is any truth after them.
What You Must Know About Spyware Right Now
Spyware is like the new technological nuclear bat on the internet. Spyware can not only dent the physical condition of your central processing unit but it can also steal your delicate characteristics other individual information.
DB Integration - Software for Amalgamate MS Admission Databases
Our company, Novaprof Inc., residential distinctive software - DB Integration.
Microsoft Commerce Solutions Customization Options - Overview for Programmer
Several years ago Microsoft purchased Great Plains Software, then Navision (Denmark based software change company). At this time Great Plains Software by now was effective ERP applications consolidation player - it previously acquired Solomon Software combine of years prior.
Microsoft Great Plains & CRM in Carrying & Logistics - Overview
Microsoft Affair Solutions Great Plains and MS CRM (client relative management system) are very accepted in a range of industries and marketplace niches. In earlier critique we described Microsoft Great Plains implementation for haulage & logistics company.
Exactly What Does FTP Stand for and What Can it do for Me?
FTP stands for "file convey protocol". FTP is all in all a way of carriage files over the Internet.
Microsoft Great Plains Defense Setup - Overview For Consultant
Microsoft Affair Solutions Great Plains is very good fit for mid-size ballet company and in all probability good financial plan solutions for large corporation. Earlier creation name was Great Plains Dynamics / eEnterprise.
Top Questions to Ask Beforehand Business a Help Desk & Asset Management Software
#5 All your hardware gears like Printers, PCs etc come under a mixture of maintenance contracts with altered maintenance vendors. Do you know which batch of PCs are under warranty & for what add up to of PCs is the warranty about to expire (so that you can plan for an AMC)? Can you split up & tell how much AMC charges do you pay for each hardware element & how much for each vendor? Can you re-calculate the costs if an AMC with a vendor is to be renewed?#4 Typically your band gets hardware parts and side dishes from another vendors.
Collaboration Software: Index of Collaboration Software Technologies
Collaboration SoftwareCollaboration Software, also known as group collaboration software or groupware, is software which allows cooperation on a affair deed connecting numerous parties on many computers. Collaboration software also allows the integration and merging of deed changes and versions on a commerce document.
Theres Gold in Your Websites Head waiter Log
Many Webmasters have never disturbed to view their website's ma?tre d' log. Ignoring your head waiter log is like brief with a blind pilot.
How to Upgrade Ability Customization - Tips for IT Manager
If you have Microsoft Great Plains and aid it for your business and have light or heavy Great Plains customization, in print in Adroitness - you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE. Great Plains Adroitness is proprietary training language/environment, which was bent in early 1990-th to give platform / file / graphical crossing point freedom for Mac and Windows based Great Plains Dynamics.
Spyware Protection: A Must for Any Home Computer
Now that spyware is the lone most dodgy menace to home computers associated to the internet today, being paid your hands on some sort of spyware and adware defense is critical. Spyware has outpaced cpu viruses in its prevalence, and in the kind of destruction it can do to your system.
Microsoft CRM Implementation for Large Corporation - overview
Microsoft Affair Solutions CRM is now approaching the phase of being mature artifact and the CRM blend you may bear in mind for large overtly traded company. Our view point considers the fact of compound platforms and systems coexistence and balancing: UNIX, Linux, Microsoft Windows, Java, .
Start Emergent Your Own Software
Learning how to course software seems like a frightening task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals printed basically in zeros and ones. Auspiciously the realism is that it's not as convoluted to make basic applications as ancestors may think.
ERP for Large Corporation - New Advertising Strategy
Our belief is based on our Microsoft Big business Solutions Great Plains, Microsoft CRM sales and marketing canvass to large businesses in the subsequent industries: Aerospace, Furniture, Beverages, Placement, Allocation & Logistics, Textile, Services, Food, Manufacturing. With the new belt-tightening exercise recovery we see signs on the market, signaling promotion approach change.
Microsoft Great Plains: Command & Non-Profit Company - Workflow Implementation
Usually workflow & messaging is realized in CRM and then transactions are just logged into Accounting/ERP/MRP. In the case of Microsoft Affair Solutions products: Microsoft Great Plains, Navision, Solomon, Axapta the biological CRM array would be Microsoft CRM.
Microsoft CRM Development
Microsoft CRM is CRM counter from Microsoft Big business Solutions.The whole conception at the back of CRM seems to be different.
10 Indoctrination Tips
(1) Avoid using the same capricious again and again for assorted purposes.This happens with us that we think that more and more reminiscence will be emaciated if we proclaim seperate capricious for each purpose.
With the coming on of 'Service Pack 2' for Windows XP in use system, Microsoft have exceedingly made the forums hum.Every forum on cpu harms is abounding with complaints that since downloading and installing 'SP2', many 'third party' applications don't work.
Microsoft CRM - Consulting in the Post-Recession Time
New post-recession era has new features, which didn't exist in late 1990th all through high-tech boom. This will be in our judgment on new commands for Microsoft Affair Solutions crop consulting, plus Microsoft CRM.
|home | site map|
|goldenarticles.net © 2018|