Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by 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

  • Phillip Jenkins Profile Picture
    Phillip Jenkins 45 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans