"Error Field Entries.Account Number is a required field but value was not supplied" error when you run a General Journal integration
This article provides methods to solve the issue that ou can't run a General Journal integration in Integration Manager for Microsoft Dynamics GP.
Applies to: Microsoft Dynamics GP
Original KB number: 929783
Symptoms
When you run a General Journal integration in Integration Manager for Microsoft Dynamics GP, you receive the following error message:
Error Field Entries.Account Number is a required field but value was not supplied.
Cause
This problem occurs if the integration source file contains blank rows.
Note
To determine whether the integration source file contains blank rows, examine the source queries when you receive this error message.
Resolution
To resolve this problem, use one of the following methods.
Method 1
Manually delete any blank rows from the integration source file.
Method 2
Create a row restriction in the source query to filter out blank rows. To do this, follow these steps:
- Locate and then double-click the source query.
- Select the Rows tab, and then select a column in the Columns list that contains a blank row. This column must contain data in other rows.
- In the Operator list, select Not Like.
- In the Value box, type two double quotation marks ("").
- To add the restriction to the source query, select And Into Criteria, and then select OK.
- Preview the source query to verify that the blank rows no longer appear.