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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

One check for invoice payment and prepayment

(0) ShareShare
ReportReport
Posted on by 15

I've searched 10 pages deep into the forums and can't find anything like this, so please forgive me if it's been asked before. 

I have received a check from a customer who long ago thought his payment would be the same each month, but unfortunately this isn't the case. As a result of this being ongoing for several months, he has an outstanding balance on a current invoice, and an invoice for the next period. 

I received his check and need to use part of it to pay for the balance of the current invoice, then book the remainder as the prepayment (to be applied once we're in the next period). 

I know I can use the Payment Entry screen to book payments and prepayments, but it looks like I can only do 1 at a time. Will I need to enter the check as 2 separate reference items in order to split it between current and future within the same batch? I guess this is what I'm thinking will need to happen, but I want to make sure there's not a simpler way to do it:

  • Check #123 for $2,000.00 is to be put against the following: Inv ABC for $500.00 (current period) and Inv DEF for $1,500.00 (future period)
  • Ref #1 to be Payment from check #123a for $500.00 (then applied to Inv ABC in Payment Application screen immediately after)
  • Ref #2 to be Prepayment from check #123b for $1,500.00 (won't be applied to Inv DEF until we're in the next period)

In an ideal world, I'd like to be able to enter check #123 once (no "a" and "b") and break it down between the 2 places in 1 reference number (like how you can break a check down to pay multiple open invoices at once on the Payment Application screen), but I'm not seeing a way to do that. (And I'll definitely be addressing the payment amounts with the customer so he knows to wait for his invoices to pay the correct amount.)

Thanks in advance for any advice!

I have the same question (0)
  • Suggested answer
    Mark E Profile Picture
    6,451 on at

    I'm not sure you need to break the customer remittance down between a Payment and Prepayment, why not just record the entire check as a Payment in the Payment Application screen, and apply any relevant amounts to open invoices and leave the rest as an unapplied payment.  You can then go back later and recall the unapplied payment to future invoices.  The only reason I can think to enter a Prepayment type would be if you do not want to include it as part of the Customer AR balance and treat it separately as a Customer deposit (liability) that might need to be repaid if gone unused.  If it is truly going to be considered AR and applied to future invoices, then leave it as a Payment type.

    It all depends on how you want to account for the advance payment.

  • RWest-Cbus Profile Picture
    15 on at

    Unfortunately, the 2 portions need to go to different GLs (one for active AR and another for deferred income because they don't want the payment amount to hit the AR account until the same month as the invoice so that the period sensitive Aged AR report matches the GL balance), otherwise I would have done it that way. I was just hoping there was a way to do it that I might have been missing. I used SL at a previous company, but was never this involved with the AR module, so I've been learning a lot lately.

    Thanks for your reponse!

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans