Billing Export Details

There are two similar fields in NetSuite credit memo/cash sale

It is the ETAIL ORDER BILLING EXPORTED that the Integration App uses. Please ignore the other one. This will be deleted by the product team at one point.

We have a use case here where a fully paid order in NetSuite is falling within the criteria of the 'NetSuite Billing to Magento Invoice Add' flow and getting exported. If an order has been fully paid for in Magento, through any means, an invoice is generated instantly, and the billing export tries to create a duplicate invoice against it resulting in the error:'You can't create an invoice without products. An invoice cannot be created when an order has a status of complete'.

Some use cases:

-If they import all orders once they are billed in Magento then we have a workaround to prevent these orders from Billing export by mapping ETAIL ORDER BILLING EXPORTED to true
-If they are billing some in Magento and some in NS, as of this writing (3/16/18) there is an enhancement (MAG2NS-321) logged for the request.

For a workaround, there is a difference between pending and paid orders in Magento 2. In pending, we don't get total_paid node. So you can add mapping expression
if total_paid === grand_total then this means fully paid and you can mark ETAIL ORDER BILLING EXPORTED to true for that order in NS via mapping.