Punchout - Error: You have entered an Invalid Field Value ___ for the following field: item
When attempting to save a transaction from the Return Cart screen an error may show up in some cases with the item internal number referenced:
You have entered an Invalid Field Value ___ for the following field: item
The reasons why this may occur are as follows in the order of likelihood:
1. The item is not enabled for purchase for the selected subsidiary
Solution: On the item record in NetSuite, select the subsidiary which is being used for purchasing.
Note: This error occurs when the subsidiary in the main list of fields does not include the subsidiary on the transaction being created. It is not referring to the subsidiary field on the vendor sublist on the item master record.
2. The item record is marked as inactive
Solution: Mark the item as active or change the configurations in the Punchout setups to use a different item.
3. An item filter has been applied on the transaction entry form under the “Sublist Fields” tab
Solution: Edit the transaction entry form and under the "Sublist Fields" tab, either remove the "Item Filter" or edit the item filter to include the item being selected.
4. The item does not have an entry in the Vendor sublist
Solution: On the item record, under the Vendor sublist which is generally found under the "Purchasing" tab, make an entry for the Vendor so that purchasing is enabled. Note, this is not always necessary.
5. The item type can not be used for Purchase e.g. “Non-Inventory Item for Sale”
Solution: Use another item of the correct type. This may be an issue with the Punchout Configurations if an item of the incorrect/incompatible type is being saved on the transaction.
6. The item selection on the Purchase Order is being filtered to a specific list of items on the Transaction entry form.
Solution: Check if this is the case by selecting the "Customize Form" option while editing a Purchase Order. This requires an Administrator login. Under the Transaction Form setups page under the "Sublist Fields" sub tab will be a drop down for "Item Filter". If a saved search has been selected here it means the list of available items on this form is limited. The search may have to be expanded or a separate form setup for use for Punchout orders so that the limits are not effective on PunchOut orders.