Sales tax works...until it doesn't. Join our May 5 webinar.

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.

Other articles

Microsoft Dynamics 365 Business Central Implementation Packages

Clayton Jones

|

April 29, 2026
If you’re like 99% of our clients, you’re trying to rein in the soaring costs of technology. It’s a delicate balancing act. On the one hand, you understand that you…

Doing More With the Team You Have: What BCS is Changing with AI

Jackie Gant

|

April 29, 2026
AI is everywhere right now, but what feels different is the pace. For the first time in a long time, small and mid-sized businesses are adopting new technology just as quickly…

Why AI Sometimes Feels Off (Even When You Have the Data)

Zoltan Orban

|

April 23, 2026
Webinar: Doing More With the Team You Have | What BCS is Changing About AIApril 28 @ 12:00 PM PT/3:00 PM ETRegister Now!Most small and mid-sized businesses aren't behind on…

What 200% ROI from Business Central Really Looks Like

Jackie Gant

|

April 13, 2026
Where ROI actually shows up from finance efficiency to operational visibility Forrester says Business Central delivers 200% ROI. But what does that actually look like in practice? A recent Total Economic…

Do You Need Avalara for Business Central? A Practical Guide

Clayton Jones

|

April 10, 2026
Webinar: Sales Tax Works…Until It Doesn’t: Tax Complexity at Scale for Product CompaniesMay 5 @ 10:00 AM PT/1:00 PM ETRegister Now!Most companies focused on making, distributing, or selling products manage…

What Is Work IQ? How Microsoft Copilot Moves from Data to Context

Zoltan Orban

|

April 9, 2026
Work IQ is one of those terms that can sound more complex than it really is. Most AI tools today work by pulling from available data. They can read records, summarize…