by rssbus | April 22, 2019

Amazon Direct Fulfillment EDI to QuickBooks Online


Download Package

Amazon Direct Fulfillment EDI to QuickBooks Online

The sample project featured in this article has preconfigured 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 QuickBooks Online.

The project comes with data maps in XMLMap ports that will transform the XML structure of X12 850 files to valid QuickBooks SalesReceipts and transform QuickBooks SalesReceipts, Invoices and Items 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 QuickBooks port. The FileMatch port is set to pass only the Invoice data to its 'Match Send to Port' denoted by solid blue line in the Flow Designer and sends the remaining data to 'Else Send to Port' denoted by the 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 QuickBooks or the files retrieved from QuickBooks are transformed to EDI documents.

The XMLMap Ports and QuickBooks port are preconfigured 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.

In order to configure the example, please follow these steps:

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

  2. After you have imported the sample, start by selecting the QuickBooksOnline port and navigate to the Settings tab. If you have not already installed the QuickBooks Online port, the application will prompt you to install it.

  3. From the Settings tab, use the Connect button to connect to your QuickBooks Online account. This will take you to Intuit App Center login page. Enter your account credentials and authorize Intuit to securely share your data with RSSBus Connect. After setting these credentials correctly, you will be able to see a success message Port Profile was saved signalling that your account is connected.

EDI 850 Purchase Order

a. After you have imported the sample, start by selecting the X12_Amazon_DF_850 port and navigate to the Settings tab.

b. 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.

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

d. Select the file and click on Send button to begin sending the file from X12_Amazon_DF_850 port onto QuickBooksOnline port via XMLMap_850_SalesReceipt and Copy port.

e. Navigate to Input tab of QuickBooksOnline port to find the SalesReceipts file in XML format. You can click on the file to download it.

EDI 855 Purchase Order Acknowledgement

a. Start by selecting X12_Amazon_DF_855 port and navigate to the Settings tab.

b. 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.

c. The Copy port will copy the transformed SalesReceipt XML from XMLMap_850_SalesReceipt port to XMLMap_855_POAck port to transform it again into Orders Acknowledgement XML.

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

e. Navigate to 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

a. Start by selecting X12_Amazon_DF_810 port and navigate to the Settings tab.

b. 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.

c. To execute the sample, navigate to the Output tab of the QuickBooksOnline port and click the Receive button to begin retrieving Invoice and Items data from Quickbooks.

d. The Invoice files fetched from QuickBoooksOnline port will be filtered by the Filematch port to XMLMap_810_Invoice, and finally be passed onto the X12_Amazon_DF_810 port.

e. Navigate to 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

a. Start by selecting X12_Amazon_DF_846 port and navigate to the Settings tab.

b. 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.

c. The Items files fetched from QuickBoooksOnline port will be filtered by the Filematch port to XMLMap_846_Inventory, and finally be passed onto the X12_Amazon_DF_846 port.

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