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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Late Payment Record Invoice

(6) ShareShare
ReportReport
Posted on by 26

Hi Community,
I’m looking for guidance on how to automatically apply a 2% late fee to all overdue invoices in Dynamics 365 Business Central.
Requirements:

  • Automatically calculate late fees on overdue invoices.
  • Allow the A/R team to manually enter a waived amount when needed.
Example:
  • Customer: ABC Flooring
  • 2 overdue invoices of $10,000 each.
  • Late fee (2%) = $400 total (on $20,000).
  • A/R team enters a Late Fee Waive amount = $400 → No fee charged.
Desired Outcome:
  • System calculates the fee automatically.
  • A field (e.g., Late Fee Waive) allows adjustments or overrides at the account level.

Has anyone implemented a similar solution or used extensions/customizations to meet this requirement?


Any suggestions or guidance would be greatly appreciated!

I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    6,113 on at
    Hello,
    To implement a solution for automatically applying a 2% late fee to overdue invoices in Microsoft Dynamics 365 Business Central, you can follow these steps:
     
    Set Up Reminder Terms:
    - Navigate to the Reminder Terms setup in Business Central. This allows you to define the conditions under which reminders (and late fees) are calculated.
    - Assign the reminder terms to the relevant customers, ensuring that the late fee percentage is set to 2% for overdue invoices.
     
    Enable Automatic Calculation of Late Fees:
    - Use the Reminders functionality to automatically calculate late fees on overdue invoices. This can be configured to include finance charges or fees based on the overdue amounts.
    - Ensure that the reminder terms are set to trigger the calculation of the late fee when invoices are overdue.
     
    Create a Custom Field for Waived Amount:
    - You may need to customize the customer card or invoice page to include a new field, such as Late Fee Waive. This field will allow the A/R team to manually enter any waived amounts.
    - This customization can be done using extensions or by modifying the existing page layout in Business Central.
     
    Implement Logic for Waiving Fees:
    - Develop a logic (potentially using Power Automate or Business Central's AL language) that checks the Late Fee Waive field. If an amount is entered in this field, the system should not apply the calculated late fee.
    - This logic can be integrated into the reminder process or as part of the invoice posting routine.
     
    Testing and Validation:
    - After implementing the above steps, conduct thorough testing to ensure that the late fees are calculated correctly and that the waiver functionality works as intended.
    - Validate with sample invoices to confirm that the system behaves as expected when late fees are applied and waived.
     
    Training the A/R Team:
    - Provide training to the A/R team on how to use the new functionality, including how to enter waived amounts and understand the late fee calculations.
     
    By following these steps, you can create a system that automatically calculates late fees on overdue invoices while allowing for manual adjustments when necessary. If you require further customization or specific coding examples, consider consulting with a Business Central developer or partner who can assist with the implementation
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,639 Super User 2025 Season 2 on at
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,639 Super User 2025 Season 2 on at
    Hello,
     
    In Dynamics 365 Business Central, automatically applying a 2% late fee to overdue invoices with a manual waiver option typically requires a custom extension, as this functionality isn't available out-of-the-box.
  • Suggested answer
    Andrés Arias Profile Picture
    4,190 Super User 2025 Season 2 on at
  • Suggested answer
    Andrés Arias Profile Picture
    4,190 Super User 2025 Season 2 on at
  • Suggested answer
    Mansi Soni Profile Picture
    8,907 Super User 2025 Season 2 on at
    Hello,

    Firstly my suggestion is to check the standard Reminder and Finance Charge Functionality available in business central, if this functionalities does not support automatic late fee calculation as per your requirement, then it can be achieved through customization or third-party extensions. You can build a custom process that runs periodically to calculate 2% late fees on overdue invoices.

    https://learn.microsoft.com/en-us/dynamics365/business-central/finance-setup-finance-charges
    https://learn.microsoft.com/en-us/training/modules/send-memos-dynamics-365-business-central/
    https://yzhums.com/wp-content/uploads/2023/12/80534_NAV2013_ENUS_FINESS_07.pdf

    Hope this answer will help you as well!

    Regards,
    Mansi Soni
  • Verified answer
    Jeffrey Bulanadi Profile Picture
    8,760 on at

    Hi,

    It's a common but nuanced requirement, and I completely understand the need for both automation and flexibility in handling late fees. You're essentially looking to enforce a consistent policy while still empowering your A/R team to make judgment calls. That balance is key in real-world finance ops.

    Here’s how you can approach it:

    1. Use Finance Charge Memos for automatic late fee calculation
      • Go to Finance > Setup > Finance Charge Terms
      • Set the Interest Rate to 2%, define terms, and assign to customers
      • Use the Create Finance Charge Memos batch job to apply fees on overdue invoices
    2. Add a custom “Late Fee Waive” field
      • Can be added to either Customer Card or Customer Ledger Entry via AL
      • Logic suppresses the finance charge if a waive amount is present or matches calculated fee
      • Optionally log waived amounts for audit and reporting
    3. Alternative: Reminder Terms for level-based charges
      • Configure Reminder Levels with fees and aging
      • Include logic to zero out the fee via a waive field or override toggle
    4. Advanced: Power Automate or workflows for notification
      • Alert A/R team if a waive is applied or if overdue invoices hit chargeable threshold
      • Consider FactBoxes or list pages to show waive history and user actions


    Helpful References:

    Finance Charges Setup – Microsoft Learn
    Reminder Terms Setup
    Custom Fields in BC
    Late Payment Prediction Extension
    Finance Charge Memos – Rand Group


    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey

  • Suggested answer
    Sohail Ahmed Profile Picture
    11,148 Super User 2025 Season 2 on at
    Business Central doesn't handle late fee calculation automatically out of the box. You’d need a custom extension to calculate 2% on overdue invoices and include a “Late Fee Waive” field for manual adjustments. Some ISV apps may offer this too — worth checking AppSource.
     
    ✅ Mark this answer as verified if it helps you.
     
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans