RKL eSolutions Blog Trends and Insights

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

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 Values

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

Early Discount and Late ChargesThis 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.Customer BP Invoice
    1. The user can specify what lines are included for the discount if needed. This defaults from the header of the invoice.Lines - Settlement Discount
  3. Confirm the discount basis amount in the 'Totals' sectionTotal discount basis

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 gridCheck Receipts


Questions?

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

Tags: Sage X3, How-To
LeeAnn Segan

Written by LeeAnn Segan

LeeAnn Segan is an ERP Support Specialist with RKL eSolutions LLP. She supports Sage 500 ERP and Sage X3. LeeAnn specializes in the financial and distribution modules. Her background includes managing distribution and warehousing for ecommerce based companies. When not working, LeeAnn enjoys working out, volunteering with groups that support special needs, and spending time at the beach with family and friends.