Suppress Leading Zeros for Check Numbers in Vendor Check Register Report

(0) Share

Report

Posted on by Community Member

We have multiple companies setup in Dynamics GP 2015 R2 that was done by a contractor we no longer use.

Our new controller noticed that when they print a Vendor Check Register Report, that the check numbers for one company are displayed without any leading zeros. In the second company when they run the Vendor Check Register Report, the check numbers are padded with leading zeros.

For example

Company 1

Check Number

12345

Company 2

Check Number

00000000000000012345

Where is the setting to change Company 2 to display check numbers like Company 1?

*This post is locked for comments

All responses (4)

Answers (1)

Sort by

Suggested answer

Almas Mahfooz 11,013 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

There is no setup for this, however you can modify the way check Number print on reports by using RW_Value function for Check Number field on desire report.
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your response.

It turns out that the check number series for the first company was 5 numbers while the second company had the program default. Our controller adjusted the check number series for the second company to 6 numbers.
Verified answer

L Vail 65,271 on at

Like (1)

Report
Copy link

Link copied!

For future checks, you should change the Next Check Number field on the next check number field on the Checkbook Maintenance Window of the specific checkbook account.

Kind regards,

Leslie
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks - this is the solution we did implement. The controller reviewed how many checks each account writes to determine how many numerical units each check numbers scheme should be.