Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Automatically apply customer payment to future dated invoice

(1) ShareShare
ReportReport
Posted on by 4
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
    YUN ZHU Profile Picture
    YUN ZHU 76,878 Super User 2025 Season 1 on at
    Automatically apply customer payment to future dated invoice
    Hi, or you can try prepayment functionality.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,635 Super User 2025 Season 1 on at
    Automatically apply customer payment to future dated invoice
    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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans