Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Table of Contents

Create Payment Terms

1, Use search function to find Payment Terms

...

5. Enter the Payment Terms Description.

Image Modified

Due Date Calculation Formula

Primer on basic date calculations:

...

-1Y = 1 year ago from today

Due Date Formula example


Formula

Due date calculation (from “Document Date”)

30D

30 days

2W

2 weeks

D5

The next 5th day of a month

CM+10D

Current Month + 10 days

Due date calculation example
Document DateDue Date CalculationDue Date
11/5/202110D11/15/2021
11/5/20212W11/19/2021
11/5/2021D1011/10/2021
11/5/2021WD411/7/2021
11/5/2021CM+10D12/10/2021
11/5/2021-1Y11/5/2020
Complex due date calculation example
Case example 1 - yearly due date

a) if document date is before July 31, the due date is Jul 31 of the year.

...

10/15/20215M3/15/2022

-CY1/1/2022

+7M8/1/2022

-1D7/31/2022
Case example 2 - quarterly due date

a) due date on 1st Monday after beginning of the next quarter from the document date

...