Submit your Suggestions for Spectrum

AR Default Transaction Adjust Ref Needs To Be Higher than 9999 (Case:32591913)

We need the cash receipts auto sequence to go beyond 9999. There are enough spaces in that field, but for some reason it resets to 1 after 9999. THEN we have to manually type in an assortment of numbers from 1-9999 to find what open reference numbers are still available.

What happens when we do fill out all 9999 adjustments? We have to do so many with our refinery customers.

Please fix or let us control the next sequence number so we can set it to start at 11,000 and so sequentially without issues.



  • Sarah Dalrymple
  • Jul 23 2025
Company WRS
I need it... Yesterday...Come on already
  • Attach files
      Drop here to upload
    • Admin
      Geoffrey Falk commented
      01 Aug 20:49

      This 4 character field is only one of seven other data elements that create a unque record key. They keys to this reocrd are:

      • Company Code (3 characters alpha)

      • Customer Code (10 characters alpha)

      • Transaction Type (10 characters alpha)

      • Transaction Number (4 characters alpha)

      • Invoice Date (MMDDYY)

      • Invoice # (10 characters alpha)

      • Invoice type (I or C)

      These seven fields create a 'key' that is used to store and call up the data. For this reason, the transaction ref is just one part of the key here.

      In other words, duplicate transaction numbers will not hurt or corrupt the system.

      Geoff

    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.