Monday, September 10, 2018

Unable to Reconcile more than 10,000 Transactions at a Time

NetSuite only shows a maximum of 10,000 items to be reconciled in a bank reconciliation. If users have more than 10,000 transactions in a given period, NetSuite recommends:


  • Reconciliation in batches
  • Shorten the time period and do smaller reconciliations

To verify the total number of transactions for the period of a specific account:


  • Navigate to Lists > Accounting > Accounts
  • Click on the account to display the register
  • Set Date to the period of the reconciliation
  • Click Refresh
  • Export to excel to determine the number of transactions

No comments:

Post a Comment