The Billing Export flow exports billing data from NetSuite to Magento in real time. As soon as a cash sale is created or a customer payment is applied to an invoice in NetSuite, the flow exports the NetSuite cash sale/invoice and creates a corresponding invoice in Magento. The flow supports both partial and complete billing of orders, whether the billing was completed individually or via NetSuite’s bulk billing feature. The Invoice record created in Magento contains the same items and quantity as the corresponding NetSuite cash sale or invoice.
Supported Use Cases
Credit card payments need to be authorized in Magento but can be captured either in Magento or NetSuite or both systems. Based on where the capture occurs, the connector supports two scenarios:
A) Payment capture in NetSuite – Sellers typically capture payments only once the fulfillment is complete in NetSuite. In this case, the connector does the following:
- Once the payment is captured fully/partially in NetSuite, connector creates an invoice for the corresponding order in Magento & marks it paid within Magento.
B) Payment capture in Magento – The payment can also be captured within Magento after fulfillment is complete in NetSuite. In this case, the connector does the following:
- Once the payment record is created in NetSuite, connector creates an invoice for the corresponding order in Magento and also trigger the capture of payments in Magento.
Note: Customers can deploy Celigo’s Auto-Billing script to generate payment records in NetSuite without having to manually bill the orders if they like. See the FAQ here.
Custom mappings are not supported for this flow & only specific fields are exported from NetSuite to Magento. Also, the connector does not update the order status in Magento as part of the Billing export.
Billing the sales order in NetSuite
Invoice in NetSuite
Invoice in Processing state in Magento
Status changed to Complete
Invoice with Paid status in Magento (billing exported from NetSuite to Magento)