I am trying to import into NetSuite customer payments. This works well. However, I want the integration to apply to account as an unapplied payment if the invoice number cannot be found on the "Invoices | Ref Num" mapping.
I've tried doing a lookup and using an 'empty string as default value' or 'null as default value' thinking the integration would then unapply it to no luck. I keep getting "Failed to create, update/transform record because You have attempted an invalid sublist or line item operation." error. Any ideas?
If you are looking to trying to have different behavior based upon the value of the invoice one possibility is using flow branching instead of trying to do everything in the mapping on a single step. You could have a NetSuite lookup step that returns the invoice details and then branches from that step based upon the invoice data. If an invoice is found then apply the payment to the invoice if not then create that unapplied payment. Could look something like this...
This might be easier to manage since you may need to have entirely different mappings for a step that applies customer payment and one that has unapplied payments. The error you are getting could be related to trying to map an unapplied payment in the same format as one that does have an invoice. Two steps will give you the flexibility to change the unapplied payment mapping so that NetSuite accepts the new record.
