Editing Rule Conditions of Auto-Create Rules

Auto-create rules provide conditions for imported bank lines, based on the imported bank line that was used to generate the rule. For any imported data that meet these conditions, NetSuite automatically generates a corresponding account transaction and matches it. Auto-create rules are different from matching rules, which match existing transactions.

You can modify and add rule conditions, if needed. If you add multiple conditions, the Transaction Type must be the same.

To edit conditions of auto-create rules:

1. Generate an auto-create rule. See Generating Auto-Create Rules.

2. Go to Transactions > Bank > Reconciliation Matching Rules.

3. On the Reconciliation Rules page, click the auto-create rule you want to edit.

   The Auto-Create GL Transaction Rule window appears. The Accounts subtab is open by default, which cannot be changed.

4. Click the Conditions subtab.

   The subtab is populated with conditions from the account transaction that was used to generate the auto-create rule.

5. From the Transaction Type field, select a transaction type.

   Supported transaction types include:

   • All Imported

   • Imported ACH

   • Imported Checks

   • Imported Credits

   • Imported Debits

   • Imported Deposits

   • Imported Fees

   • Imported Interest

   • Imported Others

   • Imported Payments

   • Imported Transfers

6. From the Primary Field list, select the first field on which the system runs this auto-create rule condition.

   The options available in the list include the following:

   • Amount

   • Date

   • Memo

   • Payor/Payee Name

   • Transaction ID

7. From the Operator list, select an operator for the rule.

   The selected Transaction Type and Primary Field determine which options are available in the list. Operators include:

   • Equals – Specifies that the selected field must be equal to a certain value. For example, the Payor/Payee field must equal the value ESSO.

   • Equals (Ignore Prefix) – Specifies that the selected field must be equal to a certain value, but ignores any alphabetic prefix or leading zeros. For example, the Transaction ID 2134 still matches N2134.

   • Before – Specifies that the selected transaction type date can be before a certain date.

   • After – Specifies that the selected transaction type can be after a certain date.

   • Less Than – Specifies that the selected transaction type amount cannot be less than a certain value.

   • Greater Than – Specifies that the selected transaction type amount cannot be greater than a certain value.

   • Contains – Specifies a value contained in the imported transaction type, payor or payee name, or memo included in the rule. If future imports contain this value, the rule creates account transactions from them.

8. If you need to enter a value input, in the Value field, enter the appropriate value.

   You can enter a value input for the following operators:

   • Equals

   • Equals (Ignore Prefix)

   • Less Than

   • Greater Than

   • Contains

9. To add another condition, click the add icon.

   The add icon is only active if all fields for the condition are populated.

   Note:

   To remove a condition, click the delete icon.

10. To save the auto-create rule, click Save.

    The new rule appears under the User Rules heading.

11. To assign the order in which NetSuite runs the rules, use the icon to drag the rules into the desired order.

The next time bank data is imported into NetSuite, the Intelligent Transaction Matching feature runs and includes your new rule. To run a rule, see Running an Auto-Create Rule.

Related Topics

Editing Auto-Create Rules

Editing Action Data of Auto-Create Rules

General Notices