In this article, you will find the most common error message you can come across when using our NetSuite integration.
You cannot edit this transaction.
This is likely because the accounting period is closed
Error messages
- You cannot edit this transaction. This is likely because the accounting period is closed, or you do not have sufficient permissions. Learn More
- You do not have permissions to edit this transaction.,Are you sure you want to enter an unapplied payment for this customer?
Explanation
This error occurs when Upflow can't update a transaction in NetSuite, often due to restrictions on modifying older transactions or closed accounting periods.
Potential solutions
- In NetSuite: go to Setup > Accounting > Manage Accounting Periods.
- Edit Period: Find and edit the accounting period for the transaction's date.
- Enable Non-G/L Changes: Check the "Allow Non-G/L Changes" box within the period settings.
Unable to set the payment method
Error messages
- Unable to set the payment method. Please remove this optional setting in Upflow or change your NetSuite settings. Learn More
- You do not have permission to set a value for element paymentmethod due to one of the following reasons: 1) The field is read-only; 2) An associated feature is disabled; 3) The field is available either when a record is created or updated, but not in both cases.
Explanation
This error occurs when the element payment method is required when creating or editing a transaction in NetSuite (e.g. payment or refund). This is often related to global settings or custom forms.
Solutions
Option 1) Remove the payment method from the Upflow configuration: /settings/payments-by-upflow
Option 2) Edit the preferred form in Netsuite to show the payment method
- Find the Preferred Form set for your users or for the Upflow basic role
- Edit the preferred form such that payment methods are
shown- Navigate to screen Fields > Payment Method > Show ✔️
Application failed due to insufficient invoice balance
Error messages
- Application failed due to insufficient invoice balance. Adjust the invoice in NetSuite or check for duplicate payment syncs.
- Unable to find a matching line for sublist apply with key: [doc,line] and value: [1634092,null].
Explanation
This error message indicates a problem with applying a transaction in NetSuite due to a discrepancy in the amounts.
Solution
The invoice you are attempting to apply the payment to has an insufficient "Amount Remaining." The invoice's remaining balance must be equal to or greater than the payment amount. The error [ID] such as "4629556" corresponds to the internal ID of the affected invoice in NetSuite. To fix this, adjust the invoice in NetSuite to ensure its "Amount Remaining" is sufficient to cover the payment.
⚠️ Note that this issue is often caused by duplicate payment applications, for example, in the presence of both Upflow and SuiteSync data synchronization. In this case, you will need to delete or reverse the duplicates
Required fields missing in NetSuite: {Department, Class, Location}.
This error occurs if {Department, Class, Location} are set as mandatory classifications in NetSuite.
Solution
Ensure that Departments are not a mandatory classification in NetSuite:
- In NetSuite, go to Setup > Accounting > Accounting Preferences
- Under Classifications, disable Make Departments Mandatory
Record has been locked by a user-defined workflow
Explanation
The root cause is a "lock" on such records in your NetSuite instance, somewhere inside a workflow.
Solution
The fix is very quick & easy with the following steps:
- Go to your Lock Record workflow action and click on the condition button.
- Set the fields below:
- Field: User Role
- Compare Type: None Of
- Selection: Upflow Basic Role
- Save. The workflow action will not execute anymore when the User Role viewing the record is an Upflow Basic Role.
- Once this is done, contact our Support team so we can run a quick check on your data sync.
Any questions, feedback, or error messages that are not listed here? Please submit a Support request.