web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to post a sales in...
Small and medium business | Business Central, N...
Suggested Answer

How to post a sales invoice with multiple payment methods?

(0) ShareShare
ReportReport
Posted on by SSDev1 150

When posting a sales invoice, it adds a customer ledger entry with the payment method code selected. Is it possible to do this with two different payments? (So there would be a total of 3 customer ledger entries connect to the invoice instead of 2.)

If not, is it possible to do this with AL?

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • JAngle Profile Picture
    JAngle 150 on at

    What is the practical reason for needing this? Cash being received doesn’t necessarily need that recorded. Plus the payment method field is editable on the customer ledger entries. If you were to use something like the payment reconciliation journal where you import a bank statement it will allow multiple applications. Or if an invoice has a remaining balance you can apply accordingly. For instance you might do a payment reconciliation for a PayPal account statement and then for the business bank account where you get bank transfers or cheques.

    If you need to break up the customer ledger entry then AL could be an option

  • SSDev1 Profile Picture
    SSDev1 150 on at

    Basically I am trying to create an app that accepts payments made directly at the sales invoice (before it's posted).

    Normally, BC adds a customer ledger entry for the payment method selected when posting. However, I want to make a split payment between multiple payment methods. Since this is an app it would be done with AL, so I'm trying to find a simple (or the simplest) way to apply payments to the invoice with AL when it's posted.

  • Suggested answer
    JAngle Profile Picture
    JAngle 150 on at

    If the invoice is not posted the payments will just sit on the ledger. You will need a routine that does the application. For that you will need to work with the detailed customer ledger entries. Manually apply a payment to an invoice and you will see how the entries look. You can then create a routine that does that on mass. Be sure to add permissions in the object as inserting/modifying the mentioned table directly is not possible otherwise.

    From the sales invoice you could create a drill down from the payment method field to generate line data for multiple payment methods and the expected value for each which should be equal to the total. You could use the deferral line schedule table and page as a template for the concept. After that do you need a routine that references this? If your receipting cash does it need to know about this schedule or does this detail need printing on an invoice document? Not knowing the full story makes it harder to realise the boundaries of the request.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,822 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,136 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 956 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans