Proposal summary

Interface Description is a Brucker Warehouse Software system. The shipping and tracking of the order needs to be synced between the NetSuite and Brucker Warehouse system. 

Requirement 

The requirement is to integrate the Brucker Warehouse software system with NetSuite. The integration will be done using the SFTP file transfer since the Brucker Warehouse software system can send/receive files only through the SFTP/FTP server. The shipping details of the order should be synced between NetSuite and Brucker Warehouse software system: Interface Description. 

Our Solution

There will be a custom record named “Interface Description Logs”. The custom record will store the file details and will attach the corresponding item fulfillment record. This custom record will be helpful for the user to backtrack if any error arises during the file creation and file transfer process.

There will be 2 scenarios for the file transfer between NetSuite and Brucker Warehouse software systems. Following are the two scenarios:

• When an item fulfillment record is created from the Sales order and the status is picked and the location is Brucker Warehouse Germany, then need to create a CSV file based on the item fulfillment record. A userEvent script needs to be developed for the process. The script will send the CSV file to the SFTP server. The CSV file should be in the correct format and format is already shared. Custom record entry should be created when sending the file to the SFTP server and the created CSV file should be attached with the custom record. If an error occurs, then the error should be stored on the custom record entry. The file will be fetched by the Brucker Warehouse software system from the file transfer. 
• A map-reduce script needs to be developed for fetching the files from the SFTP server. Brucker warehouse software system will post the files to the SFTP server when the order is shipped from the warehouse. The map-reduce script should fetch the CSV file from the SFTP server and based on the file details identify the corresponding item fulfillment record in NetSuite. The tracking number and link should be stored into the item fulfillment record if present. The file should be stored into the custom record entry. 

Assumptions

• SFTP server doesn’t have IP Whitelisting so the script can establish the SFTP connection.
• We will assume that the SFTP server credentials will be shared before the development is started.
• The folder location of the files should be shared so that script can fetch files from the correct folder location.
• CSV file will be created based on the shared file format.
• All the CSV files will be stored into the file cabinet and will be attached to the custom record entry.
• Map-reduce script can be scheduled every day for one-time.

Risks 

• If the SFTP server has IP Whitelisting, the proposal is not applicable.