by rssbus | June 05, 2019

Amazon Direct Fulfillment EDI to NetSuite


Download Package

Amazon Direct Fulfillment EDI to NetSuite

The sample project featured in this article has pre-configured ports for mapping and transforming data to and from the 850 Purchase Order, 855 Purchase Order Acknowledgement, 846 Inventory Inquiry/Advice, and 810 Invoice transaction sets based on Amazon's Direct Fulfillment specifications. The data in these documents will be inserted to and retrieved from NetSuite.

The project comes with data maps in XMLMap ports that will transform the XML structure of X12 850 files to valid NetSuite SalesOrder and transform NetSuite SalesOrder, Invoice and InventoryItem files to X12 855, 810, and 846 documents respectively.

The project uses a Copy port to copy incoming XML files to multiple destinations, as well as a FileMatch port that acts as a filter for the incoming files retrieved by the NetSuite port. The FileMatch port is set to pass only the Invoice data to its 'Match Send to Port,' denoted by a solid blue line in the Flow Designer, and sends the remaining data to 'Else Send to Port,' denoted by a gray dotted line.

These ports are configured to automatically move files from one port to the next until the EDI files are transformed and added to NetSuite or the files retrieved from NetSuite are transformed into EDI documents.

The XMLMap ports and NetSuite port are pre-configured to operate automatically. To make the process completely automated, you can set the X12 port to send the files in its Input Folder at regular intervals using Automation Settings or manually process files using the Send button from the Input tab of X12 port.

To configure the example, follow these steps:

  1. Go to the Flows tab and click the Import Workspace button. In the dialog that appears, choose the file AmazonDFEDINetSuite.zip to import the project's settings and port configurations.

  2. After you have imported the sample, select the NetSuite port and navigate to the Settings tab. If you have not already installed the NetSuite port, the application will prompt you to install it.

  3. In Settings, enter your Account Id, User and Password to connect to your NetSuite account. After setting these credentials, click the Test Connection button to verify that you can connect to your NetSuite Account from RSSBus Connect.

EDI 850 Purchase Order

  1. After you have imported the sample, select the X12_Amazon_DF_850 port and navigate to the Settings tab.

  2. From Settings, to change Sender and Receiver Identifiers respectively, make the necessary changes in Interchange Settings for the Sender Identifier (ISA06) and Receiver Identifier (ISA08) segments. Do the same for Functional Group Settings for the Sender Identifier (GS02) and Receiver Identifier (GS03) segments. By default, these values are AMAZONDS and VENDOR respectively.

  3. To send the files manually, navigate to the Input tab to find DF850.x12 waiting to be sent.

  4. Select the file and click the Send button to begin sending the file from X12_Amazon_DF_850 port onto NetSuite port via XMLMap_850_SalesOrder and Copy port.

  5. Navigate to the Input tab of the NetSuite port to find the SalesOrder file in XML format. You can click on the file to download it.

EDI 855 Purchase Order Acknowledgement

  1. Select the X12_Amazon_DF_855 port and navigate to the Settings tab.

  2. From Settings, make the necessary changes in Interchange Settings for the Sender Identifier (ISA06) and Receiver Identifier (ISA08) segments and in the Functional Group Settings for the Sender Identifier (GS02) and Receiver Identifier (GS03) segments. By default, these values are VENDOR and AMAZONDS respectively.

  3. The Copy port will copy the transformed SalesOrder XML from XMLMap_850_SalesOrder port to XMLMap_855_POAck port to transform it again into Orders Acknowledgement XML.

  4. This Orders Acknowledgement file will be sent to X12_Amazon_DF_855 which will convert the file into 855.x12.

  5. Navigate to the Output tab of X12_Amazon_DF_855 port to find the EDI 855 file. You can click on the file to download it.

EDI 810 Invoice

  1. Select the X12_Amazon_DF_810 port and navigate to the Settings tab.

  2. From Settings, make the necessary changes in Interchange Settings for the Sender Identifier (ISA06) and Receiver Identifier (ISA08) segments and in Functional Group Settings for the Sender Identifier (GS02) and Receiver Identifier (GS03) segments. By default, these values are VENDOR and AMAZONDS respectively.

  3. To execute the sample, navigate to the Output tab of the NetSuite port and click the Receive button to begin retrieving Invoice and InventoryItem data from NetSuite.

  4. The Invoice files fetched from the NetSuite port will be filtered by the Filematch port to XMLMap_810_Invoice and passed onto the X12_Amazon_DF_810 port.

  5. Navigate to the Output tab of X12_Amazon_DF_810 port to find the EDI 810 file. You can click on the file to download it.

EDI 846 Inventory Inquiry/Advice

  1. Select the X12_Amazon_DF_846 port and navigate to the Settings tab.

  2. From Settings, make the necessary changes in Interchange Settings for the Sender Identifier (ISA06) and Receiver Identifier (ISA08) segments and in Functional Group Settings for the Sender Identifier (GS02) and Receiver Identifier (GS03) segments. By default, these values are VENDOR and AMAZONDS respectively.

  3. The Items files fetched from the NetSuite port will be filtered by the Filematch port to XMLMap_846_Inventory and be passed onto the X12_Amazon_DF_846 port.

  4. Navigate to the Output tab of the X12_Amazon_DF_810 port to find the EDI 810 file. You can click on the file to download it.