New Year, Smarter Work: Get 1 Month Free Copilot | Now $21/User.

May 21, 2016

One Sale; Two Invoices in Dynamics GP

Recently, a customer of ours asked how they can invoice two customers that were splitting the cost for one piece of equipment. Since selling ½ of this product/ equipment was out of the question, we had to think of another approach. After doing a little bit of brainstorming, we came up with the following:

1. Invoice the entity that will be holding title to the equipment for the full amount
2. Back out the balance to be paid by the second entity through the Terms Discount Taken field

sales-trans-entry-GR

3. Create a new invoice for the second entity, but use a Non-Inventory item (this item happens to have a period at the end)
sales-trans-entry-2-GR

In concept, this should work as both customers would be receiving invoices for their respective balances due. The only issue we can foresee is that the formatting for the standard Dynamics GP invoice comes with the summarized amounts for the sale and not the amount due. This may require some modifications to be made within Report Writer to show the correct On Account balance for the first customer invoiced.

total-GR

Please check back on our blog series where we walk you through this process.

George Rios Microsoft Dynamics GP Consultant George Rios is a Microsoft Dynamics® GP Certified Professional and senior consultant at Bond Consulting Services. He has over 13 years of work experience with accounting and accounting systems.

Share On: 

Other articles

From Frustration to Future-Ready: What Growing Distributors Need to Know About Their Systems

Jennifer Ryan

|

January 8, 2026
I spent years on the other side of the table — inside distribution businesses, closing books at midnight, trying to reconcile inventory that never quite matched, and juggling spreadsheets that…

How Miron Violetglass Scaled 40% Without Adding Headcount

Jennifer Ryan

|

January 6, 2026
Every distributor reaches a point where growth exposes the cracks: too many spreadsheets, too much manual work, and not enough visibility. Miron Violetglass hit that moment and what happened next…

Why Distribution Hand-Offs Break (and How Connected Operations Fix Them)

Jennifer Ryan

|

December 18, 2025
Inside distribution companies, most problems don’t come from bad people or broken intentions. They come from gaps in the hand-offs between teams.As a Controller, I used to think our issues…

Unlocking Insights: Power BI Integration with Dynamics 365 Business Central

Joel Trinidad

|

December 16, 2025
As businesses increasingly rely on data to drive decisions, Microsoft continues to enhance the synergy between Dynamics 365 Business Central (BC) and Power BI. With the release of Business Central Version 26, users now…

The Spreadsheet Trap in Distribution: Why You Lose Control Without Realizing It

Jennifer Ryan

|

December 11, 2025
Let me start with a confession: I love a good spreadsheet. They’re flexible. Fast. Familiar. Elegant.But here’s the problem no one talks about: Spreadsheets eventually become the system. And that’s…

How to Connect Power Pages & D365 Customer Engagement for a Seamless Self-Service Experience

Marisa Mini

|

December 4, 2025
Power Pages for Customer Service, Field Service, and Sales PortalsCreating a seamless, modern customer experience starts with reducing the back-and-forth. If your customers (or vendors, partners, applicants, members, etc.) still…