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

October 13, 2021

Cash Discounts on Customer Payments using Deposits

An inquiry we received from our clients is how to handle Customer discounts while receiving payments from the Customer in Dynamics 365 Business Central (BC). The following scenario will walk you through the process.

Let’s say, “Sale Invoice” created for a Customer for $450. The payment term is 1 month. The cash discount condition is if the Customer pays before 30 days.

Step 1: Search for “Deposits

Step 2: Create “New”

Step 3: Assume you got a check for $400, where $50 discount needs to be applied for the respective Invoice of $450.

Select Function >>> Apply Entries

Step 4:

Step 5: Set the “Applies to ID” against the respective Invoice entry and update the Payment Discount Date (Pmt. Discount Date) field to current date, enter discount amount as $50.

Step 6: Select Posting >>> “Test Report” to view the transactions before posting it.

Step 7: Select the “show application” (BC will show the entries for the Invoice where discount is applied)

Step 8: The test report will show, what is the Amount Due ($450), Discount ($50), Amount paid by Customer ($400) and Total applied amount ($450).

Step 9: After Posting the deposits, you can verify the posted transactions in Customer Ledger Entry, where the “Remaining Amount is Zero”

Detailed Customer Ledger Entry will clearly show the Total Payment and payment discount applied.

The status OPEN is unchecked, meaning there is no pending payment, and all the payments are received and cleared.

Share On: 

Other articles

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…

How to Tell if Your Distribution Business Has Outgrown Its Systems

Jennifer Ryan

|

December 1, 2025
As a former Controller inside a fast-moving distribution business, I learned this lesson the hard way: You don’t realize your system is breaking until growth exposes every weakness.It doesn’t happen…

Why Microsoft Killed Social Posting (And Why SMBs Should Care)

Jackie Gant

|

November 25, 2025
When Microsoft quietly pulled the plug on social posting in Dynamics 365 Customer Insights late last year, few in the small to mid-sized business (SMB) space raised an eyebrow. After…