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 apply multiple ...
Small and medium business | Business Central, N...
Answered

How to apply multiple payments to the same invoice.

(5) ShareShare
ReportReport
Posted on by Greg Kowieski 157
I'm trying to import in payments and the applied entries on tables 18 and 21.  But, I've noticed that in all the windows I can find to apply payments to Sales invoice, there appears to be a table design flaw in that you can only indicate one payment to an invoice.  I've been looking for another table to be the one to many relationship for this, but have come up zilch.  I can't believe that this isn't possible, so I've scoured and scoured.  Perhaps using the key word Apply Payment isn't Bcentral nomenclature?  Any ideas?
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 5,420 Super User 2026 Season 1 on at
     
    You can apply mutiple payments against an invoice from "Apply Entries" button in JV's
     
     
    Or from Vendor Ledger Entries Page . 
     
    To run script from backend then you have to update vendor ledger entry with amount to apply  , applies to id , once  you post system will create detailed vendor ledge entries 
     
     
    Warm Regards
    Pallavi Phade
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 12,808 Super User 2026 Season 1 on at
    Hello,
     
    Payment ↔ Invoice applications are stored in Table 379 (Detailed Cust. Ledger Entry).
    This is the real one-to-many table.
    Tables 18 and 21 cannot store applications.
     
    Regards,
    Oussama Sabbouh
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,555 Most Valuable Professional on at
  • Greg Kowieski Profile Picture
    Greg Kowieski 157 on at
    Thanks for all the links.  I'm actually importing in data from other ERP systems.  So using the GUI doesn't really fit the model.  I'm trying to see if I can import into the register table.  Fingers crossed.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,055 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
     
    Thanks.
    ZHU
  • Verified answer
    Greg Kowieski Profile Picture
    Greg Kowieski 157 on at
    Well, I suspected this might be the issue.  I thought I remembered from class that you can't import into Register tables and I'm assuming this is what this error message is alluding to:  
     
    Your license does not grant you the following permissions on TableData 379 Detailed Cust. Ledg. Entry: Modify. To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session I  
       
     
     
    Which brings me full circle back to the problem that the GUI doesn't really allow 2 payments to be applied to the same invoice in the same entry batch.  I'll just write code to work it out in batches.  Thanks for helping though.
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,732 Super User 2026 Season 1 on at
    Hello,
     
    In Business Central, you can apply multiple payments to a single invoice, but the one-to-many relationship isn’t stored in Customer Ledger Entry (Table 21) alone.
     
    Instead, applications are tracked in Detailed Customer Ledger Entry (Table 379), which links payments and invoices at a granular level.
     
    So, while Table 21 holds the main transactions, Table 379 records each application, allowing multiple payments per invoice.
     
    For vendors, the equivalent is Vendor Ledger Entry (Table 25) and Detailed Vendor Ledger Entry (Table 380).
  • Greg Kowieski Profile Picture
    Greg Kowieski 157 on at
    Thank you for the information.  The other gentleman already alerted me to table 379.  Unfortunately, its a ledger table, and I don't believe you can import into ledger tables.
     
    But, its all good, I'll just batch the invoices with payments by month and handle manually any exceptions to the application restriction of the entry tables.

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,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans