Submit your Suggestions for Spectrum

• Home /
• SPC-I-3158 /
• New idea

1 Vote

Allow more digits in Bill_Number

The Bill_Number field in TM_BILLING_DETAIL_MC is limited to 3 characters, so there is a hard-coded limit of 999 billings on a single Job.  We've had a couple of Jobs that have hit this cap, and are expected to have more over the next few years.  When we hit the cap we have to create a new sub-Job to allow us to continue processing, post all new Cost to that sub-Job and generate the bills from the sub-Job.  For a multi-year Job this can happen several times, with having to stop processing on one Job number and shift everything to a new one until it also runs out of digits.  Needless to say, this greatly complicates things for us and is very time consuming.  PLEASE increase the size of that field so we can have more digits in the Bill_Number and this problem goes away.

• Guest
• Apr 23 2018
• Already exists

Accounting

• Apr 27, 2018

  Admin response

  While we have maintained the three digit bill number, the scheme goes alpha once it reaches 999.

   

  998

  999

  00A

  00B

  00C

  00D

   

  And so on

• Comments (0)
• Votes (1)

• Attach files

  Enter a subject

• 

Log in / Sign up

Identify yourself with your email address

Email address

Subscribe

You won't be notified about changes to this idea.

Related ideas

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.