Submit your Suggestions for Spectrum

Validate Date field for importing cleared checks in Bank Reconciliation

In Spectrum, when importing a CSV file for clearing checks, on accident, we uploaded the file with the date format as 10/01/2019. We found out later with this format, it showed checks under the Vendor > payment history as cleared with 10/01/20 date. We did not know, the date format should be in a 6 character date. We were able to correct all of these with the 2019 year date but concerned Spectrum allowed us to have invoices that appeared to have paid a year later in the future. No error message occurs when importing cleared checks with a year future date.

  • Guest
  • Nov 7 2019
  • Already exists
Company Schuchart
Job Title / Role Payroll & Accounts Payable Specialist
I need it... 6 months
  • Attach files
  • Admin
    Geoffrey Falk commented
    October 02, 2023 22:04

    The date mask is definable when creating the Cleared Data File Format.

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.