X12 810 - NetSuite O2C

A search request is performed on NetSuite to look for unprocessed invoice records. If a record is found, it is parsed and the matching Outbound Route is searched. If there is a match, then the data (in .csv format) is translated to an EDI 810 and sent to the trading partner. 

This section explains how to configure the integration to retrieve the Invoices and transform them to EDI X12 810 format for trading partner integration. 

How to Configure the Flow

1. Configure Process Schedulers: LaunchNetsuiteInvoicePS. This can be found in the com.cleo._customer_.booster.netsuite.invoice package. By default, it is scheduled to run once an hour. Configure the specific time interval based on your specific requirements. See Creating and Defining Process Schedules for details.
2. Configure the Outbound Route. The CustomerInternalID field from saved search results is used to identify the Trading Partner to whom the Invoice records are to be sent.
3. Configure the EDI Enveloper.  The X12 810 envelope details and the trading partner endpoint to which the X12 810 is to be sent should be specified in _TP_810v4010ENV (found in trading partner Project - com.cleo._customer_.netsuite._tp_.outbound.n810.v4010 package).  By default, the Customer name and the TP Name entered in the Wizard property file are added to the sender id and receiver id respectively. If there are any changes to the enveloping details, _TP_810v4010ENV must also be updated accordingly.

Prerequisites - Folder Internal IDs and Names, Global Variables

After configuring the outbound 810 flow, the following prerequisites must be met before running.

• Folder Internal IDs. The Folder internal IDs being used in the Saved Search Scripts must be modified per the customer’s instance internal ID. The saved search script ID used is customscript_cleo_sch_810_go_script.
• Folder name in saved document search. In addition to updating folder internal IDs, you must update the folder name under the criteria tab in the saved document search so that it points to the appropriate transaction folder name. The saved search ID used is customsearch_cleo_ss_810_getcsvfile.
• Configure Global Variables with Archive Folder Internal ID. Global Variables must be initialized with the internal ID of the archival folder as per the customer instance. For this flow, update the Global Variable for InvoiceArchiveFolder.

Please see specific details for updating the NetSuite script for the steps noted above.

How to Run the Flow

1. Before proceeding, ensure that the following Projects have been deployed. If any of these Projects are already deployed and remain unmodified, there is no need to redeploy them. Similarly, if any of these Projects were not checked out to your Workspace, they can be skipped from the deployment process.

1. • com.cleo._customer_.edi
   • com.cleo._customer_.edi.booster.netsuite
   • com.cleo._customer_.edinetsuite
   • com.cleo._customer_.netsuite._tp_
   • com.cleo.b2bcloud.core
   • com.cleo.b2biaas.clarify
   • com.cleo.cic.cockpit.core
   • com.cleo.cic.cockpit.core.n810
   • com.cleo.cic.cockpit.core.n850
   • com.cleo.cic.cockpit.core.n855
   • com.cleo.cic.cockpit.core.n856
   • com.cleo.cic.connector.netsuite
2. Manually run the flow using LaunchNetsuiteInvoiceBPS. See Starting Objects for details.
   Alternatively, automatically run the flow using LaunchNetsuiteInvoicePS, which runs the flow based on the interval specified.
3. Monitor the flow using:
   • Log Entries (Studio Auditor)
   • Message View (Cockpit)
   • Jobs View (Cockpit)
   • Dashboard > Charts (Cockpit)  

   In case of errors, a ticket is generated and information is also visible in the Message and Job views in CIC Cockpit.

   Example of Cockpit Tile with error

   

   Example of Cockpit Job with error

   

   For Outbound EDI validation use cases, see Validation Rules in the Transformation Settings object for Outbound EDI validation rules.

How to Customize

1. Change how often Invoices are retrieved from NetSuite.

   The LaunchNetsuiteInvoicePS Process Scheduler, found in the com.cleo._customer_.booster.netsuite.invoice package, is currently configured to retrieve Inventory once each hour. If necessary, change the schedule to run more frequently or less frequently based on your requirements. See Creating and Defining Process Schedules for more information.

2. Add more details to the X12 810 from the NetSuite invoice.

   The values mapped are documented in the Integration Design Specification, which can be found in the com.cleo._customer_.edinetsuite project under the docs folder. However, if you wish to add fields, you must update the _TP_810v4010RS Ruleset, which can be found in the following package:  com.cleo._customer_.netsuite._tp_.outbound.n810.v4010. 

Contact Cleo Support for assistance with adding Rules.