Editing Action Data of Auto-Create Rules

An auto-create rule includes actions that tell NetSuite how to generate transactions when its conditions are met.

By default, action data comes from a memorized transaction record—a template NetSuite creates from a matched account transaction. The auto-create rule uses it to generate future transactions.

You can override the values in the memorized transaction record by modifying the rule's actions.

Note:

The memorized transaction record doesn't impact the general ledger account.

To edit actions of auto-create rules:

Generate an auto-create rule. See Generating Auto-Create Rules.
Go to Transactions > Bank > Reconciliation Rules.
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.
Open the Actions subtab.

The subtab is populated with action data and contains two parts:
- A row of fields that mirror the line-level information in the associated memorized transaction record. This includes the general ledger account that automatically generated transactions go into, and the payor/payee, class, department, and location the rule looks for in future imports.
- A grid that specifies how NetSuite obtains the date and memo values for automatically generated account transactions.
Other fields, like the amount and currency, are copied from the memorized record. The Transaction ID’s generated automatically.
(Optional) To change the general ledger account, from the GL Account field, select a different account.
(Optional) To change the payor or payee, from the Payor/Payee field, select a different name.

Note:
To limit scrolling, start typing in the Payor/Payee field to narrow the results.
Set the Class, Department, and Location fields.

These fields may be required, depending on your company settings. See Using Per-Line Classifications.
To edit the action for the Date transaction field, from the Action field in the first row, select an action. There are two actions:
- Copy from imported bank line – The Date field in the created transactions is copied from the imported bank line. This action is the default.
- Autogenerate – NetSuite sets the date in the automatically-created transaction to the creation date.
Note:
The Date action cannot be removed, and there is no option to add another Date action.
To edit the action for the Memo transaction field, from the Action field in the second row, select an action. There are two actions:

Note:
The Memo field in Actions is the top-level memo. To change line-level memos, use the memorized transaction record. For details on memorized transactions, see Memorized Transactions.
- Copy from imported bank line – The Memo field in the created transactions is copied from the imported bank line. When selected, you can copy imported fields into the memo, which appear in the Value list:
  - Bank: Amount
  - Bank: Date
  - Bank: Memo
  - Bank: Tran No.
  - Bank: Payer/Payee Name
  This action is the default.
- Insert text – The Memo field in the created transactions contains a value you specify. In the Value field, enter text for the memo.
Warning:
You can only have one Memo action per rule. If you try to add additional memo actions, you'll get an error when you save.
To view or modify the memorized transaction record associated with the rule, click the link underneath the actions grid. Use the memorized transaction record to change fields or add custom fields.
To save the auto-create rule, click Save.

The new rule appears under the User Rules heading.
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, Intelligent Transaction Matching includes your new rule. To run a rule, see Running an Auto-Create Rule.

To edit actions of auto-create rules:

Related Topics