We would like to reconcile a customer invoice with a journal entry that represents the payment. In this case, the payment was not processed through NetSuite's standard customer payment workflow, but instead posted manually via a journal entry.
We are looking to understand:
- How to match (reconcile) a customer invoice with a journal entry in NetSuite, using:
- a CSV import;
- an API connection (SuiteTalk or REST);
- or a custom script (SuiteScript).
- Is it possible to automate the reconciliation process between customer invoices and payments, even when payments are recorded through journal entries instead of native customer payments?
- If so, what kind of SuiteScript automation or integration should be implemented to achieve this?