NSC | Memorized Transactions > How to Resolve: "Please enter value(s) for: (Missing Field)

Micah Timbol-Oracle

Scenario:

The user creates a Memorized Vendor Bill transaction and sets it to run automatically on a scheduled basis. During execution, NetSuite displays the following User Error:

"Please enter value(s) for: Invoice Number, Send Approval Email To"

Solution:

This behavior is expected and occurs by design in NetSuite. When an Automatic Memorized Transaction fails to execute successfully—typically due to missing required information or validation errors—it is automatically reclassified as a Reminder transaction. This allows the user to manually review and correct the issue before executing it again.

Based on the scenario, this error is caused by the presence of mandatory fields on the Vendor Bill custom form that are left blank during the automatic generation of the transaction. In this case, the following fields are set as required:

• Invoice Number
• Send Approval Email To

Since no value is populated for these fields during automatic execution, NetSuite prevents the transaction from processing and triggers a validation error.

To resolve this issue, the user should modify the custom Vendor Bill form and update the field configurations, especially for fields that are not auto-populated during scheduled execution. Below are the detailed steps:

1. Navigate to the Vendor Bill Form: Go to Transactions > Payables > Enter Bills.
2. Open the Customize Form Interface: Click on Customize at the top of the page.
3. Then select Customize Form from the dropdown.
4. Edit the Preferred Custom Form (Vendor Bill): Locate the Preferred Vendor Bill Form from the list of custom transaction forms.
5. Click Edit next to it or select it from the form list in the customization window.
6. Update Field Settings: Click on the Screen Fields tab.
7. Under the appropriate subtab (typically Main or Custom), locate the fields: (Invoice Number, Send Approval Email To)
8. For each of these fields, remove the checkmark in the Mandatory column.
9. Save the Custom Form
10. After updating the field settings, click Save to apply the changes.
11. Return to the Memorized Transaction: Navigate to the memorized transaction record that failed.
12. Manually update its execution type back to Automatic.
13. Save the transaction.

Hope this helped!