Submit your Suggestions for Spectrum

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
  • 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

  • Attach files

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.

1515 SE Water Avenue, Suite 300, Portland, OR 97214 |  800.333.3197  | Contact Us | Terms of Use | Privacy | Support Policies

© 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.