RKL eSolutions | Insights, Tips and Trends from a top Sage Reseller and Technology Specialist

How to Setup and Use an Early Settlement Discount for Customers in Sage X3

Written by LeeAnn Segan | May 12, 2022 3:15:00 PM

Wanting to show a little appreciation or provide an incentive for your customers who always pay their invoices early with a discount encourages good relationships between you and your clients. In this blog, we will show you step-by-step how to setup a discount for customers who pay their invoices before they're due.

Setting up the Parameter Values

  1. Go to Setup > General Parameters > Parameter Values
    1. Type TRS into the 'Chapter' field
    2. Type USA into the 'Legislation' field
    3. Type TDC into the 'Group' field

Parameter Value Glossary

DATDEP = Date for the Calculation of Discounts

  • Invoice Date - the date of the invoice is used to calculate the discount date 'range'. This is how we typically calculate the discount date range in the US.
  • Due Date - the due date of the invoice is used to calculate the eligible discount date.

AUTDEPCUS = Automated Calc AR Discount Taken

  • Yes - when this parameter value is set to 'Yes', the early discount is calculated and the discount line is generated according to the discount rate set up for the open item.
  • No - when this parameter value is set to 'No', there is no early discount calculated and generated. You will need to enter it manually.

DENDEP = Customer Early Payment/ Discount

  • CDISC - use this parameter to define the accounting destination to be linked to the discount line of the generated payment.

Setting Up the Early Discount

  1. Go to Common Data > BP Tables > Early Discounts/Late Charges

This setup shows that a discount of 2% will be applied if the invoice is paid within 10 days of the invoice date. No discounts will be made after 10 days.

Setting up a Customer Account with a Settlement Discount

  1. Go to Common Data > BPs > Customer
    1. Assign the Settlement Discount in the 'Financial' section
      pic

Creating an AR Invoice with a Discount

  1.  Go to A/P-A/R Accounting > Invoicing > Customer BP Invoice
  2. Early Discounts/Late Charges will default form the customer record.
    1. The user can specify what lines are included for the discount if needed. This defaults from the header of the invoice.
  3. Confirm the discount basis amount in the 'Totals' section

Creating a Customer Payment within the 10 day Discount Period

  1. Go to A/P-A/R Accounting > Payments > Payment/Receipt Entry
  2. Create the Receipt
    1. Note that when selecting the open item (invoice) from the left list, the discount will auto populate on the next available line in the grid


Questions?

Don't hesitate to reach out and ask us any questions you may have, it's what we're here for!