Customer/Vendor Consolidations in Microsoft Dynamics GP

by | Updated January 29, 2020 | Dynamics GP

Customer/vendor consolidations in Microsoft Dynamics GP allow you to set up a relationship between a company that is a vendor as well as a customer. If you’re purchasing and selling items to the same company, you’ll save time and resources by setting up customer/vendor consolidations. This functionality consolidates the balance you owe and the balance they owe you, meaning no more sending and receiving redundant checks.

To set up this features go to Tools > Setup > Company > Customer/Vendor Setup

Once you enter this window, you will define the defaults that will happen with each transaction. Here you’ll need to set the default suspense account, description and the options of setting up specific prefixes for descriptions. Your description will always start with ‘BALTRANSFER’ so you know it’s a balance coming from a customer or vendor. You can also mark to auto-create customers/vendors so any time you create a customer, it will automatically create a vendor with the same ID and name.

From this window, you can view who you have set up as relationships on the sales and receivables side.

Once you have the relationship set up, go to Customer/Vendor transactions. That’s where you create the transactions that go between sales and payables. From there you choose the customer and vendor, date to transfer.

Customer Vendor Consolidations

Credit and debit memos will be automatically created once you post the transaction. You can preview the transaction prior to posting.

Once you have this functionality set up you’ll no longer have to worry about manually processing or sending out unnecessary checks. For more help on this topic, contact Stoneridge Software.

Related Posts

  • Whether you’re looking to upgrade to the latest release of Microsoft Dynamics GP, get more information about new features, or request year-end close assistance, the resources below will connect you…

  • Need to issue a refund check in Microsoft Dynamics GP? You can cut a check directly out of payables in Microsoft Dynamics GP by using the ‘refund checks’ functionality. All you need…

  • If you have accidentally voided the wrong check in Microsoft Dynamics GP, or selected the wrong vendor for the AP transaction, you can recreate the transaction to ensure the vendor account…


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive


01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!