Skip to Content

How to setup Payment terms/SAP B1 system so that due dates calculation exclude non-working days?


I would like to know is there anyway to setup the payment terms or Holiday calendar in SAP B1 so that system will exclude non-working days in the calculation of invoice due date? Currently, how the system work is that if due date is fall on non-working day, it will skip to next working day as due date but PH or weekend is included in the calculation of due date.

E.g. Public Holiday = 6/11/2018, weekend date = 3 & 4/11 and 10 & 11/18. Posting date = 1/11/18. Payment terms is 10 days. Due date calculated by system will be 12/11/18 because 11/11/18 is a weekend.

What I want is the due date should be 16/11/18 as 10 days is for 10 business days . Any idea how to achieve this?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Nov 01, 2018 at 05:51 AM

    Hi ms Too. i m miss lim from malaysia. i would like to ask you on this issue " cannot create a budget scenario for selected fiscal year .Delete the budget defined for the fiscal year first. 01.02.2018"

    i hv gone thru your blog . exactly the same case as i facing now. May i know how you solve this issue. Your prompt reply is highly appreciated

    Thank you

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 15, 2018 at 07:02 AM


    Check this thread if the links in the thread help you for your case:



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.