WeDid: X12 EDI and Netsuite
Challenges
The customer has many distributors that sell their product to reseller or end user.
When an order is placed, the distributor will send an email with Purchase Order information and this information was being keyed into Netsuite manually.
Once the order was confirmed, a separate email with Invoice information was sent back to the distributor.
This is inefficient and prone to errors due to the large volume of Purchase Orders to be processed daily.
Solution:
| Purpose | To capture purchase orders placed by distributors automatically and acknowledge them once the purchase order is processed. To send a confirmed invoice to distributors together with the associated product license key. |
| Applications | Netsuite (ERP) EDI (FTP) |
| Versions | Netsuite ERP EDI |
| Tool | Dell Boomi Atomsphere |
| Information | EDI 850 > Netsuite Sales Order Purchase Order Acknowledgement > EDI 855 Netsuite Invoice > EDI 810 |
| Data Formats | X12, XML (Netsuite) |
| Volumes | 100/day |
| Process | Retrieves EDI 850 via FTP and create into Netsuite Sales Order.Matches customer and reseller information found in the EDI 850 with existing customer in Netsuite by using advanced customer matching logic.
Retrieves Netsuite Invoice for the sales order and create EDI 810 and place to FTP. |
| Schedule | Hourly |
| Complexity | Moderate |