This document is meant as to aid in troubleshooting these error messages:
You have entered an Invalid Field Value ### for the following field: department
You have entered an Invalid Field Value ### for the following field: account
You have entered an Invalid Field Value ### for the following field: project
You have entered an Invalid Field Value ### for the following field: class
You have entered an Invalid Field Value ### for the following field: entity
You have entered an Invalid Field Value ### for the following field: location
About Invalid Field Value Errors:
Occasionally an error similar this may occur when pushing a voucher to from Prendio to your ERP System: You have entered an Invalid Field Value ### for the following field: entity
This error is reporting an issue with the ERP ID used for either the Supplier, GL Account, Department, Project, Class or Location (depending on what segments are enabled for your company) for the Voucher reporting the error.
You will know which one based on what field is indicated at the end of the error.
You have entered an Invalid Field Value ### for the following field: department – means the issue is with the mapped department on the voucher
You have entered an Invalid Field Value ### for the following field: account – means the issue is with the mapped GL account on the voucher
You have entered an Invalid Field Value ### for the following field: entity – means the issue is with the mapped supplier/vendor on the voucher
You have entered an Invalid Field Value ### for the following field: class – means the issue is with the mapped class on the voucher
You have entered an Invalid Field Value ### for the following field: project – means the issue is with the mapped project on the voucher
You have entered an Invalid Field Value ### for the following field: project – means the issue is with the mapped location on the voucher
How to Look up the ERP ID:
When one of these errors occurs, the Invalid Field Number reported is the ERP ID Number reporting an issue. Click on the Red Triangle Error in the Status column of the AP Push window to view the entire error message, example:
You have entered an Invalid Field Value 233029 for the following field: entity
233029 is the ERP ID in question in this example and since the field indicated in the error is “Entity” that means the issue with the ERP Supplier/Vendor
Accounts Payable:
In Accounts Payable, you can now go to the section where the error is indicated. “Entity” indicates Suppliers so we will go to Accounts Payable>Suppliers>ERP Total Suppliers
Accounts Payable > Suppliers > ERP Total Suppliers:
Here you can search the Supplier Name or the ERP Supplier ID which is 233029.
Resolving This Error:
1. In this example, the Supplier selected in the order is Inactive. To resolve the error make this Supplier Active in NetSuite. In some cases the vendor may need to be remapped if there is a duplicate or alternative version of the vendor in NetSuite that is already active.
2. Click on the Supplier at the AP Push Screen and remap the vendor under the supplier profile and click Save.
3. Push the Voucher to your ERP System.