Editing Action Data of Auto-Create Rules
An auto-create rule is populated with actions that specify how the rule automatically generates transactions from imported data when the specified rule conditions are met.
By default, action data is sourced from the associated memorized transaction record. A memorized transaction record is a template that NetSuite generates from a matched account transaction. The auto-create rule uses the memorized transaction record to generate future account transactions.
You can override the values in the memorized transaction record by modifying the rule's actions.
The memorized transaction record does not 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 pops up. The Accounts subtab is open by default, which cannot be changed.
-
Click 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 are automatically copied from the memorized transaction record, including the transaction amount and currency. The Transaction ID is automatically generated.
-
-
(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 entering a name in the Payor/Payee field to narrow your search results.
-
Set the Class, Department, and Location fields.
These fields may be mandatory, 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 listed in the Actions subtab refers to the top-level memo only. To change memos at the line level, you must 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 receive an error when you try to 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, the Intelligent Transaction Matching feature runs and includes your new rule. To run a rule, see Running an Auto-Create Rule.