SG Disk To NetSuite Update

#

Overview

This process "SG Disk To NetSuite Update" is designed to update Item Fulfillment and Consolidated Fulfillment records in NetSuite based on files retrieved from a disk storage system. It starts by retrieving files from the disk, then performs various data processing, mapping, and validation steps to prepare the data for updating the corresponding records in NetSuite. The process also includes error handling mechanisms, file backup, and notification capabilities to ensure the integrity and reliability of the integration workflow.

#

Process Diagram

#

Business Context

Source Application: Disk
Target Application: NetSuite
Application Info:

1. Disk: The disk connector in Boomi AtomSphere allows for the retrieval, storage, and management of files from local or cloud-based disk storage systems. In this process, the disk connector is used to fetch files that contain data to be updated in the NetSuite ERP system.
2. NetSuite: NetSuite is a comprehensive and highly scalable cloud ERP system tailored for mid-market and enterprise businesses. It unifies core functions spanning accounting, finance, revenue management, fixed assets, order-to-cash, purchasing, inventory, manufacturing, supply chain management and employee management on a single platform. This process updates Item Fulfillment and Consolidated Fulfillment records in NetSuite based on the data retrieved from the disk storage.

#

Process Steps and Functions

Start\[stepname= "Start"]: Initiates the process flow.
Document Properties\[stepname= "Document Properties"]: Manages and sets properties or metadata associated with the processed documents.
Branch\[stepname= "Branch", numBranches= "2", 1= "Process Call", 2= "Connector"]: Splits the process flow into two parallel branches - one to call a subprocess, and the other to retrieve files from the disk.
Process Call\[stepname= "Process Call", sub\process\name= ]: Calls a subprocess to perform additional processing or data retrieval tasks.
Get File from Disk\[stepname= "Connector", connectorname= "Disk", actionType= "Get"]: Retrieves files from the disk storage system using the disk connector.
Document Properties2\[stepname= "Document Properties"]: Manages additional document properties or metadata.
Try/Catch\[stepname= "Try/Catch", default= "Data Process", error= "Business Rules"]: Establishes an error handling mechanism, directing the flow to either a data processing step or a business rules validation step in case of errors.
Data Process\[stepname= "Data Process"]: Performs data preparation and transformation tasks on the retrieved files.
Business Rules\[stepname= "Business Rules", Accepted= "Connector", Rejected= "Message"]: Validates the processed data against defined business rules. If the data is accepted, it proceeds to the next step; if rejected, it generates a message.
Business Rules2\[stepname= "Business Rules", Accepted= "Map", Rejected= "Stop"]: Performs additional business rules validation on the data. If accepted, it proceeds to the mapping step; if rejected, it stops the process.
Split\[stepname= "Map", mapname= ,

of mappings= 4]: This mapping step splits the retrieved file data into separate records or entities based on defined criteria. It utilizes custom functions like Date, Date Format, and Right Character Trim to prepare the data for further processing.
Decision\[stepname= "Decision", true= "Flow Control", false= "Stop"]: Evaluates a condition and routes the flow accordingly, either to a flow control step or a stop step.
Flow Control\[stepname= "Flow Control"]: Manages the flow of the process based on specific conditions or logic.
Branch2\[stepname= "Branch", numBranches= "2", 1= "Map2", 2= "Map3"]: Splits the process flow into two parallel branches to perform separate mapping operations.
Update\IF\[stepname= "Map", mapname= ,

of mappings= 3]: This mapping step transforms the file data into the format required to update Item Fulfillment records in NetSuite. It utilizes a Document Cache Lookup function to retrieve additional data.
Update\CF\[stepname= "Map", mapname= ,

of mappings= 5]: This mapping step transforms the file data into the format required to update Consolidated Fulfillment records in NetSuite. It also utilizes the Document Cache Lookup function.
Decision2\[stepname= "Decision", true= "Try/Catch", false= "Stop"]: Checks if the Item Fulfillment internal ID is present, and routes the flow accordingly.
Try/Catch2\[stepname= "Try/Catch", default= "Connector", error= "Stop"]: Establishes an error handling mechanism for the Item Fulfillment update operation.
Connector2\[stepname= "Connector", connectorname= "NetSuite", actionType= "UPDATE"]: Updates the Item Fulfillment record in NetSuite using the transformed data.
Decision3\[stepname= "Decision", true= "Try/Catch", false= "Stop"]: Checks if the Consolidated Fulfillment internal ID is present, and routes the flow accordingly.
Try/Catch3\[stepname= "Try/Catch", default= "Connector", error= "Stop"]: Establishes an error handling mechanism for the Consolidated Fulfillment update operation.
  Connector3\[stepname= "Connector", connectorname= "NetSuite", actionType= "UPDATE"]: Updates the Consolidated Fulfillment record in NetSuite using the transformed data.



    Object Name: Consolidated Fulfillment
    Operation Type: UPDATE


Decision4\[stepname= "Decision", true= "Connector", false= "Stop"]: Determines whether to delete the file from the disk or not.
Connector4\[stepname= "Connector", connectorname= "Disk", actionType= "Get"]: Deletes the file from the disk storage system.
Document Properties3\[stepname= "Document Properties"]: Manages additional document properties or metadata.
Document Properties4\[stepname= "Document Properties"]: Sets the file name and backup directory for the file stored on the disk.
Connector5\[stepname= "Connector", connectorname= "Disk", actionType= "Send"]: Stores a backup of the file on the disk storage system.
Connector6\[stepname= "Connector", connectorname= "Disk", actionType= "Get"]: Deletes the file from the disk storage system, based on the business rules validation.
Message\[stepname= "Message"]: Generates a message based on the business rules validation.
Document Properties5\[stepname= "Document Properties"]: Manages additional document properties or metadata.
Document Properties6\[stepname= "Document Properties"]: Sets the file name and backup directory for the file stored on the disk.
Connector7\[stepname= "Connector", connectorname= "Disk", actionType= "Send"]: Stores a backup of the file on the disk storage system.
Connector8\[stepname= "Connector", connectorname= "Slack", actionType= "CREATE"]: Sends a notification message to a Slack channel or user, potentially
informing about the process execution or any errors encountered.