Tip: Modify NetSuite Paycheck Number to Reset Auto Numbering Manager

This article is relevant if you are seeking to change your NetSuite paycheck or document numbers in bank accounts.

Background

Recently, while processing a paycheck in NetSuite, I provided a check number that was a reference number from an electronic bank transfer.  The number I provided modified the check number sequence to a very large number throwing off NetSuite’s automatic suggestion of next check number — convenient when working with paper check stock.

I was unable to change this check number because the underlying payroll batch was in a “committed” state.  Fortunately, with some help from NetSuite Support, I was able to resolve it.  The way it was resolved was not intuitive and I thought it may help to explain what I did as it may help you with your accounting work.

Open Print Check Capacities after Previously Printing

The trick is to “reprint” the paycheck.  To do this, you need to go to the Account listing under which the check was previously recorded.  You need to get to the “Register View”.  One way to get this to view is to go to Transactions, Employees, Create Individual Check, List and then click on the Account field for the troubled check.  Once you get to this view, turn off the 1-line display option so that two lines are used to display each check.  Once that is done, you should see a Print checkbox next to each check.  Once you click the check box, press the Refresh button at the bottom of the view to confirm that the checkbox indeed has taken.

Thereafter, go to Transactions, Management, Print Checks feature and select Paychecks.  At that point, y0u should see your paycheck and you can put provide a new check number as if you were printing the check for the first time.

Additional Check Numbering Tip

Independent of the fix noted above, the best practice is to use a string instead of a number for anything that is different from your pre-printed paper check numbers.  For example, you could put “ACH 2140324” to indicate that the check was processed via ACH.  These strings are ignored by the automatic number manager which helps you with your manual paper check number.

Get NetSuite Help

Use NetSuite’s Support to help with issues like the one I had above.  At the same, having a NetSuite expert help you learn how to get more out the platform can make a major difference in your day-to-day operating use and your capacity to make good information driven decisions.  Feel free to contact us if you want more conversation.

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube