Proposal Summary
This proposal summarizes the functionality for NetSuite SFTP integration.
Requirement
Aero UK would like to collect orders in XML format from an SFTP and create sales orders in NetSuite. Also push invoices from NetSuite out to a HTTP link.
Our Solution
1. Receive Order from SFTP
• The third-party system places the Order Manifest in the SFTP file server. This is fetched by NetSuite on a scheduled basis.
•We will establish a connection between NetSuite and SFTP Server.
• We will write a map-reduce script for fetching orders from SFTP. Received Order Manifest will be saved to the folder ‘File to be Processed’ in the NetSuite file cabinet. Once the Order is created the file can be moved to the folder ‘File Processed’.
• We will convert the cXML file to JSON format inside the script and create the orders in NetSuite.
•We will schedule the script in a basic to create the orders in NetSuite
• There can be scenario when Order manifest is successfully received at NetSuite, but Order could not be created. Then a custom record can be created to store the Order manifest received and the error occurred. Each time an error occurred, and Order is not created, then an entry is added to the custom record.
2. Invoice Payload
• We will write a script to send the invoice data to provided HTTPS Link.
• Whenever an invoice is created in NetSuite, then the data will be sent to the End Point provided. The data will be sent in a daily scheduled process (Once in a day). The Invoices files are posted to an API endpoint. The API credentials can be stored in a custom record.
• We will consider the invoices that are created for the mentioned customer ‘The Mayor’s Office for Policing and Crime’
• We will schedule the script in a daily basis for sending the invoice data to the provided link
• A copy of the response file sends to API and is saved in a folder Invoice files in the NetSuite file cabinet.
• The data format will be a CSV file.
Assumption
• We assume that the Orders will be created for only one customer in NetSuite and that will be the customer with the name “The Mayor’s Office for Policing and Crime”
• We assume that custom price level is used for the items in the sales order
• Aero UK will provide the mapping of the cXML tags corresponding to the NetSuite field.
• We assume that Aero UK will provide the external link for sending the invoice data and the link will be an HTTPS link.
• Aero UK will provide the authentication detail required to make connection to the HTTP link.
• Aero UK will provide the template for CSV file that will use to create the CSV file of invoice.
• We assume that the structure of XML file will be always same and the order data inside the XML file will only different depends on the order.
• We will not setup the tax while creating the orders.