Customer/Vendor link to hold AP Invoice until AR invoice is paid

(0) Share

Report

Posted on by Tracy Morris

165

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

All responses (1)

Answers (0)

Phillip Jenkins 45 on at

Like (0)

Report

Re: Customer/Vendor link to hold AP Invoice until AR invoice is paid

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.