Custom lightweight EDI integration

Product            : Sage MAS500
Description    : Custom EDI integration for orders, shipments and stock status reports
Project Type  : Custom integration
Customized   : None
New Screens : None
Versions           : 6.3 and later

The requirements for this customization was to enable the transmission of EDI documents in .csv format between an originating organization and a MAS500 user who was going to do shipping fulfillment on behalf of them. Documents were transmitted via FTP  between the two sites. On the MAS500 side the EDI documents were imported into MAS500 using a custom EDI connector written in which moved data from the FTP site .csv files into custom SQL staging tables in MAS500. The standard MAS APIs were then used to create sales orders, pick lists and then shipments. After the shipment were completed a shipment confirmation was then transmitted to the origination company.