Users set Payment Terms to handle:

  • Due Date Calculation
  • Factor of Due Date (Document Date)
  • To decide if the Prepayment Invoice needs to be created and posted before posting the SO/PO

Follow the below steps to set the Payment Terms:

1) Search "Payment Terms"

2) Create a new row and enter the related information for payment terms

3) Go to Payment Terms by Department Tab.  Select the Department Code for identify which department can be use the payment terms.

#FieldDescription

1

CodeCode of the payment terms to recognize
2Due Date Calculation

*Due Date Calculation (see formulas below)

Enter the date calculation after the document date

3Discount Date CalculationEnter the date calculation to allow discount within the Discount Date.
4Discount %Discount percentage allowed
5DescriptionDescription of the payment terms
6PrepaymentIf checked the box, SO/PO with this payment terms chosen, the Prepayment Invoice needs to be created and posted before posting from SO/PO.


*Due Date Calculation Formula

Primer on basic date calculations:

C = Current
D = Day
W = Week
M = Month
Q = Quarter
Y = Year
CD = Current Day
CW = Current week
CM = Current month

10D = 10 days from today 
2W = 2 weeks from today

D10 = The next 10th day of a month (e.g. 10th date of every month)
WD4 = The next 4th day of a week (Thursday) (e.g. Thursday of every week)

CM+10D = Current month + 10 days

*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