Articles in this section

Understand the NetSuite order to cash: EDI for B2B Manager (EDIFACT) template

The order-to-cash process spans from placing an order until the business receives payment. This process encompasses order management, fulfillment, credit management, invoicing, and payment collection.

The Celigo platform (integrator.io) through B2B Manager functions as an EDI platform that modernizes traditional B2B EDI data integrations by providing standardized REST/JSON API endpoints for EDI transactions. For the order-to-cash process, when trading partners have purchase orders, they can create sales orders in NetSuite. The B2B Manager can convert the EDIFACT format to a JSON canonical structure and vice versa for seamless integrations between trading partners and NetSuite.

The NetSuite order to cash: EDI for B2B Manager (EDIFACT) template facilitates the exchange of purchase orders (ORDERS), purchase order change requests (860), invoices (810), purchase order change requests (ORDCHG), despatch advice (DESADV), and acknowledgments (CONTRL) between EDI trading partners and NetSuite. A B2B Manager subscription is required to use this template.

Features and Benefits

  • Optimize customer experience with timely sync of data.

  • Take control of your integrations with tools that let you configure and allow you to make mapping changes on the fly.

  • Efficiently scale operations by automating processes that rely on trading partners and NetSuite platforms.

  • Reduce maintenance time with a dashboard for sophisticated error handling and integration support provided by Celigo.

User journey benefits

  • A Sales Manager of an eCommerce manufacturer/supplier: 

    • requires the purchase orders placed by the Retailer to sync into NetSuite to approve the orders and pass along approved orders to downstream teams/departments for fulfillment and invoicing.

    • requires to see the correctly updated/newly created/deleted equivalent sales orders in NetSuite when a specific purchase order that is split as multiple sales orders in NetSuite is part of EDI (ORDCHG).

  • A Warehouse Manager of an eCommerce manufacturer/supplier wants shipped orders in NetSuite to sync directly to the trading partner source platform as order fulfillment completion.

  • An Account Receivables (AR) analyst of an eCommerce manufacturer/supplier wants invoices created in NetSuite against successfully shipped orders to sync directly to the EDI Source system and notified of the payment and records are closed.

  • A Sales Manager/Warehouse Manager of a manufacturing company wants to send the Purchase Order change requests from NetSuite against the Purchase Orders created directly in the source system.

Supported integration flows

ns-order-to-cash-edifact-template.png

The Celigo bundle contains workflows you can easily configure and deploy without coding or IT support. The following built-in flows sync from the specified source data to the corresponding destination.

  • Purchase orders (ORDERS) to NetSuite sales orders (add): Generates the purchase orders (EDI transaction ORDERS) from the trading partner to NetSuite as sales orders.

  • Purchase order change requests (ORDCHG) to NetSuite sales orders (update): Generates purchase order change requests (EDI transaction ORDCHG) from the trading partner source and updates the NetSuite sales orders.

  • NetSuite invoices to invoices (INVOIC): Generates the invoice from NetSuite as an invoice (EDI transaction INVOIC) to the trading partner source. This is a once-exported scheduled flow. Before the invoice is generated, be sure to sync the sales order.

  • NetSuite sales orders to purchase order response (ORDRSP) (add): Generates the purchase order acknowledgments based on the NetSuite sales order status as purchase order acknowledgments (EDI transaction ORDRSP) to the trading partner source. This scheduled flow picks the sales orders created since the last flow run.

  • NetSuite item fulfillments to despatch advice (DESADV): Generates the item fulfillment from NetSuite as despatch notice (EDI transactionDESADV) to the trading partner source. The scheduled flow generates only the fulfillment records with the status as Shipped in NetSuite. This is a once-exported scheduled flow. Before you generate the fulfillment, make sure to sync the sales order.

  • Generate acknowledgements (CONTRL): Generates the acknowledgements in integrator.io and sends them to the trading partner source as functional acknowledgements (EDI transaction CONTRL). An acknowledgment is generated on a successful run of the Purchase orders (ORDERS) to NetSuite sales orders (add) and Purchase order change requests (ORDCHG) to NetSuite sales orders (update) flows.

Error handling

Most integrator.io error messages clearly explain the error and suggest troubleshooting methods. If you need clarification on what the error means, contact Celigo support. See the endpoint documentation for errors passed through from NetSuite or trading partners.