I am needing a way to link a customer to a vendor and then hold any vendor payments until the customer has paid the sales invoice. I know we have the customer/vendor consolidation for refund checks but they are not the same person/business. It's like a subcontractor scenario where my company is billing a customer, getting paid and then paying the subcontractors. I don't want to pay my subcontractors until I've gotten paid. Thanks for any advice.
*This post is locked for comments
Hi Tracy
Is this a one to one or one to many relaitonship? I.e. could the relationships be set up using customer/vendor reationships. If it is one to one then the realtionship table could be used as a basis to create some VBA business rules to hold/unhold a vendor based on activities/balances in the receivables. If it is a one to many relationship (it sounds like it is) then you could also do the same thing but it would require some specific table setup to define the relationships.
You would need Modifier/VBA license or at least the customization site enabler license.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156