Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Sales Invoice Payment Tolerance in Batch Post

(0) ShareShare
ReportReport
Posted on by 15,433

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,433 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,433 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

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans