Brief description of problem: User validating AP Transaction Batch - gets error that reads 'Batch validation was not succesfully completed. You may try again but if the problem persists contact Application Support for assistance. Cannot insert the value NULL into column 'GLAcct', table 'Viewpoint.dbo.bAPGL; column does not allow nulls, INSERT fails. The statement has been terminated.
From this error the user cannot determine which Seq or where a GL Acct is missing
System version & test data: VP621SP2 - Oldcastle
Steps to reproduce: See screenshots attached to see AP Trans and where the GL Acct was missing.
Current results: Batch Validation cannot complete error with little detail
Expected results: provide customer with more detail - required VP assistance to identify which transaction/where GL Acct was null. By looking at the actual transaction you cannot tell that a GL Acct is missing.
Andrew Karr
| Company | Oldcastle Materials Group |
| Job Title / Role | AP Mgr |
| I need it... | Yesterday...Come on already |
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.
© 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.