ANS-0486 · SUITESCRIPT DEVELOPMENT

How to Handle Journal Entries as Payments in NetSuite Server Scripts?

Effectively apply journal entries as payments using NetSuite server scripts.

Short answer

When creating a payment record via a server script using a journal entry, a $0 payment amount causes an error. A non-$0 amount results in a double payment, showing the journal entry on the invoice and a separate floating payment. The payment record is essential for applying the journal entry to the invoice.

Scenario

When attempting to create a payment record using a server script and applying a journal entry in the credit tab, users may encounter unexpected behavior. Entering a $0 payment amount will trigger an error within NetSuite. Conversely, if a non-$0 payment amount is specified, the system will generate a double payment, where the journal entry is applied to the invoice, but a duplicate floating payment of the same amount is also created without being applied to any transaction.

Solution

When creating a payment record in a server script and utilizing a journal entry in the credit tab, observe the following behaviors:n

  1. Entering $0 as the payment amount will cause NetSuite to return an error.n

  2. Entering a payment amount that is not $0 will result in a double payment. The journal entry will appear applied under the payment tab of the invoice, and a separate floating payment of the same amount will also be created, unapplied to any transaction.n

  3. It is crucial to understand that the payment record acts as the mechanism for applying the journal entry as a payment. Deleting the payment record will typically undo the application of the journal entry to the invoice, as the payment record facilitates this linkage.

Expert NetSuite Support

Need help with this NetSuite issue?

SuiteScript Development consulting and configuration support

Talk to a consultant