In VN_INVOICE_APPROVAL_DET_MC and in VN_INVOICE_TRAN_DETAIL_MC, there are both Debit_Amount and Credit_Amount columns. When the Table Directory Inquiry feature is used to look up details on those columns, they are described as "Debit Amount" and "Credit Amount" (no surprise!!).
However, in actuality, it appears that only Debit_Amount is used (see support case 32711350). Credit_Amount is always 0. Instead of looking at both fields, Credit_Amount should be ignored, and the transaction type (e.g. I or C) needs to be used to determine whether Debit_Amount represents a debit or a credit (e.g. to determine whether to give the Debit_Amount column a positive or negative sign).
This request is for the Table Directory Inquiry documentation for these columns in the two tables to be updated to reflect this (e.g. that Credit_Amount is unused; and that Debit_Amount contains both credit and debit amounts).
Thank you for your consideration!
Guest
| Company | Big Wave BI |
| 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.