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 :
Small and medium business | Business Central, N...
Suggested Answer

Automatically apply customer payment to future dated invoice

(1) ShareShare
ReportReport
Posted on by 14
We have the need to automatically apply customer payments to an invoice that is dated on a future posting date.  The company is a subscription business (using an extension for recurring billing).  The issue we have is that invoices are generated on the 20th of one month and posted on the 1st of the following month to allow time for statements to be mailed to subscribers.  Every month, some subscribers will pay the new invoice prior to the invoice's actual date (ie a customer may pay on February 28, but the invoice isn't dated until March 1), which prevents the /Apply To Oldest/ from processing.  I found where this filter is being applied in Codeunit 12 but there is nothing to subscribe to nearby to remove this filter and allow the application.  Has anyone else run into this problem and come up with a solution?  The payments are being applied via the cash receipts journal and all of the customers are set to apply to oldest.  If the payment is made after the posting date of the invoice, everything works as expected.
  • Suggested answer
    Valentin Castravet Profile Picture
    32,808 Super User 2026 Season 2 on at
    Another option - post the payments without applying them to a specific invoice. Afterwards, create a processing report that mass applies unapplied payments/invoices to each other based on apply to oldest. Once a payment and invoice are both posted, the system allows you to apply them even if the payment posting date is before the invoice date. 
     
     
    Valentin Castravet
    Zander ERP Services
  • Suggested answer
    YUN ZHU Profile Picture
    104,090 Super User 2026 Season 2 on at
    Hi, or you can try prepayment functionality.
     
    Hope this helps.
    Thanks.
    ZHU

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 677 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 430 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 280 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans