NetSuite Sync Errors and Resolutions

Error

Error Reason

Resolution

INVALID_FLD_VALUE You have entered an Invalid Field Value Captured for the following field: custbody_cseg4

This error message occurs when attempting to create an expense report for a user who no longer exists in the system.

This error message occurs when attempting to process a transaction without any line items. It can happen in the following scenarios:

• For Bills: No Chart of Accounts (CoA) is selected on the line items of the bill.
• For Bill Payments: The bill has been paid manually in NetSuite, causing a mismatch during the sync.

1. For bills/expense reports, check CoA selection: Ensure that a Chart of Accounts (CoA) is selected for each line item on the bill or expense report. If any line item is missing a CoA, add the appropriate account and save the changes.

2. For bill payments, verify payment status in NetSuite: Check if the payment has been completed manually inside NetSuite. If the payment is confirmed to be complete, cancel the sync attempt in Peakflo to prevent further errors.

This error occurs when attempting to post or sync a bill or expense report to NetSuite, and the bill issue date or expense report date falls outside of the allowed posting period. The posting period may be locked in NetSuite, preventing the transaction from being processed.

USER_ERROR The transaction date you specified is not within the date range of your accounting period

This error occurs when the specified transaction date falls outside your accounting period's date range in NetSuite. The transaction date is not within the open accounting period. The accounting period is locked in NetSuite, preventing transactions from being recorded.

This error occurs when the user attempts to edit a transaction. This error rarely occurs, but is critical to address when it does. This error indicates the role Peakflo Developer in Netsuite has either "no permissions" or "removed permission". 

This error occurs when there is an incomplete Chart of Accounts (CoA) configuration for the tenant. It means the "Peakflo Wallet" is not configured in the CoA for the tenant.

1. Cancel the Sync: To resolve the issue, reach out to Peakflo's support team at support@peakflo.co, and we will help you to cancel the sync with NetSuite.

2. Set Up Peakflo Wallet in CoA: Follow the steps mentioned in "How to do account mapping in Peakflo?" to configure the CoA and set up the Peakflo Wallet.

This error occurs when a transaction is not completed successfully. Specifically, it indicates that the wallet accounts cannot be selected while creating bill payments for the expense reports. This issue is related to a NetSuite configuration problem.

This error occurs when the bill issue date in Peakflo is earlier than the effective or creation date of the corresponding tax code in NetSuite. NetSuite requires that the tax code be valid as of the bill’s issue date, and an earlier bill date can trigger this error.

1. Adjust the Bill Issue Date: Update the bill issue date in Peakflo to match or be later than the effective date of the tax code in NetSuite.

2. Resync the Bill: Once the bill issue date is adjusted, initiate a resync from Peakflo to NetSuite to ensure the bill processes successfully without errors.

This error occurs when the bill number already exists in NetSuite, as well as in Peakflo.

To resolve the issue, reach out to Peakflo's support team at support@peakflo.co, and we will help you to cancel the sync with NetSuite and resolve the error.

This error occurs when an update attempt is made on a bill that has already been synced to NetSuite, but the G/L period for that bill is now closed. NetSuite prevents modifications to any transactions within closed periods, resulting in a sync failure.

To resolve the issue, reach out to Peakflo's support team at support@peakflo.co, and we will help you to cancel the sync with NetSuite and resolve the error.

This error occurs when the item used in the bill has an invalid ID, which is not recognized or accepted by NetSuite.

To resolve the issue, reach out to Peakflo's support team at support@peakflo.co, and we will help you sync the line item details to NetSuite accurately.

This error occurs when attempting to sync a transaction from Peakflo to NetSuite using a tax code that is either invalid or not currently enabled in NetSuite.

If the tax code is incorrect:

1. In Peakflo, return the transaction (e.g., bill or expense report) to Draft status.

2. Update the Tax Code to a valid one.

3. Reapprove the transaction and attempt to sync again.

If the tax code is correct:

1. In NetSuite, ensure the tax code is enabled and applicable for the transaction type.

2. Once enabled, retry syncing the transaction from Peakflo.

This error occurs when syncing a transaction from Peakflo to NetSuite, and the selected currency is either not associated with the vendor or not enabled for the subsidiary in NetSuite.

If the currency selected in Peakflo is incorrect:

1. In Peakflo, return the transaction to Draft.

2. Change the currency to the correct one.

3. Reapprove the transaction and sync again.

If the currency is correct:

1. Log in to NetSuite.

2. Enable the currency for the vendor and/or the relevant subsidiary.

3. Return to Peakflo and retry the sync.

This error occurs when attempting to sync a goods receipt from Peakflo to NetSuite, but one or more of the items on the Purchase Order cannot be received due to configuration issues in NetSuite.

Check Item Preferences: Go to the item record in NetSuite. Under the Preferences tab, make sure the “Can be received” checkbox is enabled.

Verify Item Type: Ensure the item is not of type Non-inventory item for purchase, as such items are not eligible for receiving.

Check Associated Account Status: Confirm that the account linked to the item is active in NetSuite. If inactive, reactivate the account or associate a different active account.