I wish I had a great suggestion for how to fix this, but mostly what I have is a description of the problem:
When we receive parts against a PO that has incorrect pricing on it, and then post the AP invoice with the correct pricing later, the average cost per unit gets rather inflated. The more significant the difference between the PO price and the AP price, the more significant the change in the average unit cost. I worked through some examples (two real-life examples, and some simpler ones with rounder figures), as well as ideas on how to fix this (without much luck), in an Excel workbook which is attached.
I offer this to make you aware of the issue, and in the hopes that maybe someone smarter than me can figure out how to address it.
It's really the IN module, but that wasn't include in the list below, so I chose AP.
Guest
| Company | Nicholson Construction Company |
| Job Title / Role | Staff Accountant |
| I need it... | 24 months |
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.
