Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Sales Invoice Payment Tolerance in Batch Post

Posted on by 15,419

Hi

I need your help with Payment Tolerance in batch posting (payment) of sales invoice. My assumption is if I add 5 invoices to batch payment then the total of Payment Tolerance is equal to the total of all invoices in that batch. For example if Payment Tolerance is $2 and I have 5 invoices in batch payment then Payment Tolerance is $10. Which means one invoice can be short $10 but still for the batch all is acceptable. 

My questions are:

1) is my assumption accurate? 

2) Let say in the batch I do not want to accept Payment Tolerance for one invoice but the rest of invoices are ready to post. How I can flag that invoice to not mark fully paid?

Thanks 

  • MahGah Profile Picture
    MahGah 15,419 on at
    RE: Sales Invoice Payment Tolerance in Batch Post

    Thanks Steve for explanation. I will ask our team to create 2 payment batches.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Invoice Payment Tolerance in Batch Post

    MahGah,

    Not possible. If the Payment Tolerance is on, globally, and you turn on for the Customer too, than it effects all invoices to apply too. You cannot say yes to some and no to others. You would need to create 2 payment batches and turn off Tolerance for the ones you are not applying this too.

    Thanks,

    Steve

  • MahGah Profile Picture
    MahGah 15,419 on at
    RE: Sales Invoice Payment Tolerance in Batch Post

    Hi Steve

    Thanks for explanation. We have the exact setup. But I provided bad explanation. I meant Cash Receipts Journal. Usually our customers send a check for many invoices. For example one check for 12 invoices. Our accounting team add all those invoices in one Case Receipt and post. But sometimes payment for one or two invoice in that Cash Receipt is way out of payment tolerance. But they either have option to accept the waring and post for all invoices or not do it for all. They want to accept for all except one invoice (or two). Is this possible?

    Thanks  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Invoice Payment Tolerance in Batch Post

    MahGah,

    #1 - No, it is not accurate. The Payment Tolerance is per document and the % or Amount used defines the total tolerance used. In your case, $2.00.

    Here is the setups and process:

    pastedimage1643869223909v1.png

    pastedimage1643869351238v3.png

    pastedimage1643869328224v2.png

    The Batch you are talking about is this a Deposit or Cash Receipts Journal? Either does not have a Batch posting process. 

    Thanks,

    Steve

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,326 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,166 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans