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

Microsoft 365 Copilot for Outlook | Manage Email Smarter

Joel Trinidad

|

November 7, 2025
The Email Overload Holding Teams BackFor most of us, email isn’t just communication—it’s command central. But the volume is relentless. Between updates, requests, and follow-ups, your inbox can feel like its own full-time…

Copilot for Power BI: Your Personal Data Assistant

Joel Trinidad

|

October 30, 2025
Microsoft has been steadily adding AI features to their broad range of business products, and Power BI is no exception. Copilot can be utilized to take full advantage of your…

How to Migrate Fixed Assets from Dynamics GP to Business Central Smoothly

George Rios

|

October 28, 2025
PlanningWhen working on a migration of Dynamics GP fixed assets to Business Central, you will want to identify which fields you want to transfer from one system to another. It…

Introducing the BCS Support Portal

TJ Sedarski

|

October 23, 2025
At Bond Consulting Services, we know how important it is to get help when you need it, and to know where things stand once you’ve asked. That’s why we are…

Announcing Unlimited Support for Dynamics 365

TJ Sedarski

|

October 17, 2025
It's like having an in-house Dynamics team - without the overhead A Smarter Way to Get Support for Microsoft DynamicsWe've listened to your feedback and we're making support simpler, faster, and…

Meet Bond Consulting at Community Summit NA 2025

TJ Sedarski

|

October 9, 2025
Discover how we’re helping growing companies streamline operations and accelerate ROI with Microsoft Dynamics 365.Community Summit North America is right around the corner! From October 19–23 in Orlando, FL, business…