Every year we are audited for Workers Comp and General Liability purposes. One report that is ALWAYS needed is a total amount paid to each subcontractor. If we used subcontracts for every job the report they offer under subcontract would work but jobs that are time and material don't use subcontracts, so therefore the amount we pay them isn't in those reports. When we enter a vendor in vendor setup you are asked the default cost type. For all of my subcontractors I use the default cost type of subcontractor. So I should be able to pull a report for amounts paid by vendor according to the default cost type.
Company | Richey/Zink & Associates Inc. |
Job Title / Role | Business Manager |
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.
If you post all your subcontractors to one general ledger account, here is a work around. I pull an account transaction report for my two subcontractor account number. Then export to excel, sort by vendor ID and then use Excel's subtotal feature to get your total per subcontractor.
Michael,
The main info I'm needing is to be able to run a total paid amount for those vendors I have identified as subcontractors in their setup screen under default cost type.. Not all vendors are subcontractors, but not all subcontractors do we run through "Vendor Subcontract". So to be able to specify a cost type (in my case Subcontractor) I would be able to get the info I need for Insurance audits.
Would a report by vendor showing each invoice, invoice total, and Subcontract cost type total (for that Invoice) and the amount paid meet your needs? Or is there additional information needed?
Amanda,
Would a report by vendor showing each invoice, invoice total, and Subcontract cost type total (for that Invoice) and the amount paid meet your needs? Or is there additional information needed?
I agree. Also, it is important that you be able to run the report based on the checks dates for those of us whose insurance periods are not calendar year. I need to report to show payments amounts and dates. This is something that should have been done a long time ago.
Agreed. This option you want would also help with auditing all cost type detail in the general ledger.