A Memorized Transaction is a transaction you save to recur in NetSuite such as recurring journal entries. Memorized transactions eliminate the data entry process and serve as a useful reminder.
When you memorize a transaction, you set up the transaction to recur over time. You choose whether the transaction automatically posts or if you are reminded to post it. Set the frequency the transaction should occur and set posting options. You can choose for the transaction to recur forever or a set number of times.
I. Note the following limitations for posting memorized transactions in locked and closed periods:
- A user must have the Override Period Restrictions permission to enable the Allow Posting in Locked Period option for a memorized transaction. When this option is enabled, memorized transactions can post in locked periods even if users initiating these transactions do not have the Override Period Restrictions permission.
- Transactions can never be posted in closed periods. If the posting date for a memorized transaction is in a period that has been closed, it is posted to the next open period.
II. In NetSuite, you can memorize the following transactions:
- Write Checks
- Use Credit Card
- Enter Purchase Orders
- Enter Bills
- Enter Sales Orders
- Create Invoices
- Prepare Estimates
- Enter Cash Sales
- Make Journal Entries
- Create Statement Charges
- Enter Work Orders
III. To Set a Reminder for memorized transactions that are due, see instructions below:
- Click Home tab and on the right corner of your Dashboard, click Personalize.
- In the Personalize Dashboard, click or drag and drop the Reminders.
- In the Reminders portlet, hover your mouse to the right end of the portlet and click the Set Up.
- In the Set Up Reminders dialog, check the Memorized Transactions due box.
- Click Save.
IV. To memorize a transaction:
-
Edit the transaction you want to memorize, and make sure the appropriate information is filled in.
-
Posting transactions that contain serial or lot numbers cannot be memorized. This includes creating invoices, entering cash sales, and fulfilling sales orders.
-
Non-posting transactions with serialized or lot items can be memorized, as long as the serial or lot numbers are not entered on the transaction. This includes preparing estimates and entering sales orders.
Memorized non-posting transactions with serialized items require serial numbers to be entered at item receipt or fulfillment time. For example, you create a sales order that includes a serialized item but do not enter the serial number for that item. Later, when you fulfill that sales order, you will be required to enter the serial number for the serialized item.
-
If you select to email or fax your customer, your customer automatically receives an email or fax each time the memorized transaction occurs.
-
If you enter credit card payment information, this credit card is automatically charged each time the memorized transaction occurs.
-
-
From the Actions list, select Memorize.
When the Memorized Transaction page opens, the payee, vendor, customer, or project name you selected when entering your memorized transaction appears in the Name field.
-
If you want to change the name of the memorized transaction, enter a new Name.
The name you enter appears in the list of memorized transactions but does not affect the name you entered on the original transaction.
-
Choose one of three options in the Action drop down list in the Primary Information section:
-
Choose Template Only if you want to create a memorized transaction that will be used as a template, but will not create any actual transactions.
-
Choose Reminder if you want to be reminded when this transaction is due so that you can view and edit it before you save it.
-
Choose Automatic if you want this transaction to automatically post. See section VII for more information.
-
-
Check the Inactive box to prevent the memorized transaction from creating any more transactions.
-
Check the Override Transaction Date box if you do not want the transaction to post on the creation date. Then you must do the following:
-
In the Next Date field in the Recurring subtab, enter the next date you want the transaction to be generated.
If you want this transaction to automatically occur, you must enter a next date here. If you do not enter a next date, the transaction will not automatically post.
-
In the Next Transaction Date field beside Next Date, enter the date you want the transaction to post.
For example, today's date is 7/15. You want the first transaction to be generated on 7/16 and to post on 7/20. Check the Override Transaction Date box and enter 7/16 in the Next Date field and 7/20 in the Next Transaction Date field beside Next Date.
-
-
Check the Allow Posting in Locked Period box to enable the transaction to post to an accounting period for which transactions are locked. You must have the Override Period Restrictions permission to check this box.
When this box is checked, memorized transactions can post in locked periods even if the user who initiates the transaction does not have the Override Period Restrictions permission. Transactions can never be posted in closed periods. If the posting date for a memorized transaction is in a period that has been closed, it is posted to the next open period.
-
Check the Update Addresses box to have the memorized transaction use the customer email, fax, and address information that is current as of the date the transaction is created. This option applies only to addresses on the customer record. Any other addresses, such as those included in the To Be Emailed list, must be updated manually.
-
Check the Update Prices box to have the memorized transaction use sales pricing that is current as of the date the transaction is created.
-
There are two options for setting the frequency of the memorized transaction:
Note:
You will not be able to set a frequency if you selected Template Only in the Action list in the Primary Information section.
-
To create recurring transactions based on a number of occurrences within a time period, enter the following in the Recurring subtab:
-
Select the Next Date on which the memorized transaction will create a new transaction.
-
Select the number of times in a time period a transaction will be created in the Repeat Every field.
-
Select the Time Period over which transactions will be created.
-
Enter the total number of transactions which should be created in the Number Remaining field. If you do not want to set a limit on the number of transactions created, clear the field and check the Indefinite box.
-
If you checked the Override Transaction Date box in the Primary Information subtab, enter the Next Transaction Date on which you want the transaction to post.
-
-
To create transactions on specific dates, enter the Next Date to generate a transaction in the Custom Dates subtab and click Add. If you checked the Override Transaction Date box in the Primary Information subtab, enter the Next Transaction Date on which you want the transaction to post.
The frequency determines how often you receive the reminder if you choose Remind Me. If you choose Automatic, it determines how often the transaction occurs.
Note:
If Monthly is selected, and the Next Date selected is the last day of a month, NetSuite will schedule all following transactions for this memorized transaction for the last day of each month. For example, if you select a Monthly frequency and set the Next Date as 2/28/2019, subsequent transactions will occur on 3/31/2019 and 4/30/2019.
If you want your transactions to occur on the 28th, 29th, 30th, or 31st of every month, set up a custom frequency in the Custom Dates subtab.
-
-
When you have finished, click Save.
-
If you clicked Automatic for this memorized transaction, you will be prompted to continue. Click OK. Your memorized transaction is saved!
V. After you create a memorized transaction, you can review it in the following ways:
- Go to Financial > Lists > Enter Memorized Transactions > List. Select it from the list.
- Go to Financial > Lists > Enter Memorized Transactions. Click View or Edit next to the transaction.
- Go to your NetSuite Home page and click the reminder you set up.
Clicking the reminder takes you to a list showing memorized transactions that are currently due. To see all your memorized transactions, check the Show All box and click Refresh.
VI. To view a list of memorized transactions due to be entered, go to Financial > Lists > Enter Memorized Transactions.
VII. Automatic Memorized Transactions
NetSuite generates an alert message and changes the memorized transaction from Automatic to Remind Me if an error occurs when executing the transaction. In this case, the transaction will no longer be automatically generated. You must determine the cause of the error, then update the transaction to correct the problem. After you update the memorized transaction, you can again select the Automatic option on the memorized transaction. The memorized transaction will run automatically on the next scheduled date.
For example, an account used in a memorized journal entry has become inactive. You receive an alert that the transaction cannot be run. Update the journal entry with an active account number. Then select the Automatic radio button on the memorized transaction to reset the journal entry to execute as scheduled.