Submit your Suggestions for Vista Web

Credit Card Statement Upload Data Massaging

Please add some data massaging functionality in the credit card statement upload.  Our statement csv exports as

Date of transaction in Australian date format

$ value as a negative integer,

the description,

last four digits of the credit card number which can sometimes be 3 digits if it begins with a zero.

 

Please add functionality for on the fly uploads to :

Assign columns into the right sequence.

Detect the date format and change accordingly 

Detect negative values and ask if you want them uploaded as positive values.

detect credit card numbers that are not 4 digits and convert to text and add the zeros if missing. 

  • Alan Hitchcock
  • Jun 20 2019
Company Whittens Group
Job Title / Role ITC Manager
I need it... Yesterday...Come on already
  • 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

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