Submit Your Suggestions for Vista

Ideaspace topics with the most votes have been moved into the Suggestion Box. If there is a topic missing, please re-enter. Our product team reviews the Suggestion Box items regularly and will provide updates as to status and incorporation into upcoming releases.

Modify report #59 / APTax to grab company info from HQCO instead of APTL

We have found that this report doesn't list a company name in the footer if there are no values to return (no tax data to report).

We don't always have data, so we still need to know which of our companies doesn't. When printing these for each company, we can't tell them apart because no name is listed.

-------------------------------------------------------------------------------------------------------------------

According to Viewpoint support when I submitted a case:

"And the whole report groups off of the view "brvAPTax", which gets most of its' info from the APTL table (AP transaction lines). My assumption is that since there are no taxes, there is no APCo, so it looks for a GLCo and if no GLCo returns a null value.

This report would need to be modified to grab company info right from HQCO and return info whether there are taxes or not. "

 

brvAPTax Formula: 

TaxCo = CASE WHEN APTL.TaxType in (1,3) THEN APTL.APCo ELSE APTL.GLCo END

  • Guest
  • Feb 20 2020
Company C.S. McCrossan
Job Title / Role Business Systems Analyst
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

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