Due Date and Discount Date Comparison Chart

This chart example compares different combinations of Due Days, Cutoff Days, Prox Codes, Prox Due Days, Prox Months Forward, Prox Discount Days, Prox Discount Months Forward and Holiday Offset Method in order to determine the Due Date and Discount Date. The date, 11/24/2011, is a holiday for these examples.

In the chart, the Prox-related values column lists the Prox Code, Due Days, Prox Due Day, and Prox Months Fwd. values. The Note column corresponds to the Note Legend after the table.

Invoice Date Prox-related values Cutoff Day Holiday Offset Method Discount Days Prox Discount Day Prox Disc. Months Fwd. Due Date Discount Date Note
10/25/2011 0/30/0/0 25 No Offset 10 0 0 11/24/2011 11/4/2011 A
10/25/2011 1/30/0/0 25 No Offset 10 0 0 12/1/2011 11/4/2011 B
10/25/2011 2/30/0/0 25 No Offset 10 0 0 11/30/2011 11/4/2011 C
10/25/2011 3/30/0/0 25 No Offset 10 0 0 12/30/2011 11/4/2011 D
10/25/2011 99/30/0/0 25 No Offset 10 0 0 11/24/2011 11/4/2011 E
10/25/2011 0/0/5/0 25 Bring Fwd. 0 27 0 11/5/2011 10/27/2011 F
10/25/2011 1/0/5/0 25 Bring Fwd. 0 27 0 11/5/2011 10/27/2011 G
10/25/2011 2/0/5/0 25 Bring Fwd. 0 27 0 11/5/2011 10/27/2011 H
10/25/2011 3/0/5/0 25 Bring Fwd. 0 27 0 12/5/2011 10/27/2011 I
10/25/2011 99/0/5/0 25 Bring Fwd. 0 27 0 11/5/2011 10/27/2011 J
10/25/2011 0/0/24/0 30 Bring Fwd. 0 10 0 11/23/2011 11/10/2011 K
10/25/2011 1/0/24/0 30 Postpone 0 10 0 11/25/2011 11/10/2011 L
10/25/2011 2/0/24/0 30 No Offset 0 10 0 11/24/2011 11/10/2011 M
10/25/2011 3/0/24/0 30 No Offset 0 10 0 11/24/2011 11/10/2011 N
10/25/2011 99/0/24/0 30 No Offset 0 10 0 11/24/2011 11/10/2011 O
10/25/2011 0/0/5/1 25 No Offset 0 27 0 12/5/2011 10/27/2011 P
10/25/2011 1/0/5/1 25 No Offset 0 27 1 12/5/2011 11/27/2011 Q
10/25/2011 2/0/5/1 25 No Offset 0 27 0 12/5/2011 10/27/2011 R
10/25/2011 3/0/5/1 25 No Offset 0 27 0 1/5/2012 10/27/2011 S
10/25/2011 99/0/5/1 25 No Offset 0 27 0 12/5/2011 10/27/2011 T

Note Legend

A - Add Due Days to Invoice Date

B - Invoice Date >= Cutoff, Due Date is Start of Next Month plus Due Days

C - Due Date is End of Invoice Month plus Due Days

D - Invoice Date >= Cutoff, Due Date is End of Next Month plus Due Days

E - Add Due Days to Invoice Date

F - Invoice Day falls on or after Cutoff Day, move to next month

G - Invoice Day falls on or after Cutoff Day, move to next month

H - Invoice Day falls on or after Cutoff Day, move to next month

I - Invoice Day falls on or after Cutoff Day, move to next month, and then push to end of next month before adjusting to Prox Due Day

J - Invoice Day falls on or after Cutoff Day, move to next month

K - Holiday falls on 11/24/2011, Holiday Offset Method is Bring Forward

L - Holiday falls on 11/24/2011, Holiday Offset Method is Postpone

M - Holiday falls on 11/24/2011, Holiday Offset Method is No Offset

N - Holiday falls on 11/24/2011, Holiday Offset Method is No Offset

O - Holiday falls on 11/24/2011, Holiday Offset Method is No Offset

P - Prox Month to Forward is 1

Q - Prox Months Forward is 1; Prox Discount Months Forward is 1

R - Prox Month to Forward is 1

S - Prox Month to Forward is 1

T - Prox Month to Forward is 1