Minimum Version Required: 22.01
Steps
Overview of Due Date Methods on Credit Terms:
Standard:
• Calculation for Due Date:
• Load Sheet Date + Days of Credit
Example:
Load Sheet -> Load Sheet Date = 10/01/2017
Customer -> AR Account -> Terms -> Days of Credit = 15
Invoice Due Date = 10/16/2017
Missouri:
• Calculation for Due Date:
• The Year, Month, and Day of the Month after the Load Sheet Date
Example:
Load Sheet -> Load Sheet Date = 12/14/2017
(The next month is 01/14/2018)
Year = 2018
Month = 1
Day = 01
If the Load Sheet Date Day is between the 1st and the 15th
New Due Date Day = 01
If the Load Sheet Date Day is between the 16th and the 31st
New Due Date Day = 16
Invoice Due Date = 01/01/2018
New York:
• Calculation for Due Date:
• 2011-01-10 plus starting from 2011-01-10 to Load Sheet Date total number of weeks, plus 25 days
Example:
Load Sheet -> Load Sheet Date = 09/04/2017
Total weeks= 347 weeks
Invoice Due Date = 09/29/2017 ('01/10/2017' + 347 weeks + 25 Days)
Nevada:
• Calculation for Due Date:
• The year for the Load Sheet Date's next month & The Load Sheet Date's next month & '15'
Example:
Load Sheet -> Load Sheet Date = 01/03/2017
Invoice Due Date = 02/15/2017
Load Sheet -> Load Sheet Date = 12/04/2017
Invoice Due Date = 01/15/2018
Utah:
• The day of Load Sheet Date is between 1 AND 15
• Calculation for Due Date:
• The year for the Load Sheet Date & The Load Sheet Date's month & '25'
Example:
Load Sheet -> Load Sheet Date = 02/04/2017
Invoice Due Date = 02/25/2017
• The day of Load Sheet Date is between 16 AND 31
• Calculation for Due Date:
• The year for the Load Sheet Date next month & The Load Sheet Date next month & '10'
Example:
Load Sheet -> Load Sheet Date = 12/17/2017
Invoice Due Date = 01/10/2018
Maryland:
• Load Sheet Date and 2012-12-02 of the time difference, starting from 2012-12-02 to Load Sheet Date, mod 14, if the result is greater than 0
• Calculation for Due Date:
• 2012-12-02 plus starting from 2012-12-02 Load to Sheet Date total number of weeks, plus 46 days
Example:
Load Sheet -> Load Sheet Date = 09/10/2017
Invoice Due Date = 10/19/2017
Load Sheet Date and 2012-12-02 of the time difference, starting from 2012-12-02 to Load Sheet Date, mod 14, if the result is less than 0
• Calculation for Due Date:
• 2012-12-02 plus starting from 2012-12-02 to Load Sheet Date since the beginning of the total number of weeks, Plus 32 days
Example:
Load Sheet -> Load Sheet Date = 08/06/2017
Invoice Due Date = 09/07/2017
Washington DC:
• Calculation for Due Date:
• The year for the Load Sheet Date 's next month & The Load Sheet Date 's next month & 15th
Example:
Load Sheet -> Load Sheet Date = 06/06/2017
Invoice Due Date = 07/15/2017
End Of Month (+):
• Calculation for Due Date:
• At Load Sheet Date from 1th this month, add a month and Day of Credit days - 1
Example:
Load Sheet -> Load Sheet Date = 04/17/2017
Customer -> AR Account -> Terms -> Days of Credit = 31
Invoice Due Date = 05/31/2017
End Of Week (+):
• Calculation for Due Date:
• Subtracting the specified time interval from the Load Sheet Date
• SUBDATE(Load Sheet Date, DATE_FORMAT(Load Sheet Date,'%w')-5)
Example:
Load Sheet -> Load Sheet Date = 03/21/2017
Invoice Due Date = 03/24/2017