Skip to main content
Question

Proxy Terms with Cutoff Dates

  • March 10, 2026
  • 1 reply
  • 21 views

Forum|alt.badge.img

Hello,

  1. How do you get the cash discount date correct when you have 2% 10th prox net terms with an invoice cut off date of the 25th of each month.  Example:
    1. Customer is invoiced on 2/20/26 – cash discount date is 3/10/26 due date 3/31/26 – cash discount date is usually right on this one
    2. Customer is invoiced on 2/27/26 – cash discount date is 4/10/26 due date 4/30/26 – cash discount date is usually wrong on this one

1 reply

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • March 10, 2026

Hello,

Credit Terms has no Cutoff day field that will allow One Terms ID to cause invoices dated after the 25 to be Discounted & Due in 2 months while invoices dated up to the 25th are discounted & Due next month.

I explored Custom Due Date Type: ability to choose one Date for invoices dated first of the month through 25th, and a different due date for invoices dated after the 25th of the month appeared. However, the ability to choose Fixed Number of Days starting Next Month disappeared when Custom was selected.  We can’t use both Custom for the date ranges and Fixed Number of Days starting Next Month for Due & Discount days.

Options:

  1. Create 2 different Terms, one for invoices dated on days 1-25 and the other from 26th to end of month. In both cases, use Fixed Number of Days Starting Next Month to calculate Due Date and Discount Date. Use a Business Event to Update Invoice Terms and Due Dates upon saving. 
  2. Customize Credit Terms screen to Provide a Cutoff Date field, and use the Cutoff Date field in Due Date Calculations on AP Bills, AR Invoices, and SO Invoices screen.