Payments CSV Import – where there is Installments
I am trying to import payments where there is installment terms on the invoice.
Works fine with no installments, but wont work with. Is there any tricks to this. Using invoice number get sna ambiguity error, but there is no way to select what instalment to apply to.
To import payments for invoices with installment terms in NetSuite, you will need to use the NetSuite SuiteScript API or the CSV Import Assistant.
When importing payments for installment invoices, you will need to include the unique installment ID along with the invoice number. This ID can be found in the installment record in NetSuite or generated by you to uniquely identify each installment.
In the CSV file, you will need to include a column for the installment ID and another column for the invoice number. You can then map these columns to the corresponding fields in NetSuite during the import process.
If you are using the NetSuite SuiteScript API to import payments, you will need to include the installment ID as a parameter in the createRecord method for the payment record. You can retrieve the installment ID using the SuiteScript search API or by querying the installment record directly.
If you are still experiencing issues with importing payments for installment invoices, you may want to consult with NetSuite support or consult the NetSuite user documentation for more detailed guidance on how to import payments for installment invoices.
