RKL eSolutionsBlogs

How to setup a Sales Discount on a Sales Invoice at the Line Level in Sage X3

 

Users may want to add a discount amount on the sales invoice line level and have the discount amount post to a specific GL account.

These steps will help you setup a sales invoice line discount:

  1. Setup the Sales invoice element for the sales discount
    1. The value type = Amount, the Sign = Decrease
    2. Select the desired accounting code with the appropriate GL accounts
    3. Click Element position to verify that the invoicing element will be included on the invoice.
    4. Click Control when finished.

      Invoicing Elements
  2.  Define the Price Structure
    1. Go to Setup > Sales > Price lists > Price structure
    2. In my example we are setting up a decreasing amount. The value = Amount, calculation basis = By line, Net price = No, and the desired invoicing element.

      Price Structure
  3. Create the Sales invoice
    1. I have created a Sales invoice for 2 items @ $100 each. The line discount amount is $5.00.
    2. The Sales invoice amount will update to $195.
    3. When posting to the General Ledger the $5.00 discount amount will post to the account defined in the Sales invoice element.

      Sales invoice Full Entry
Tagged With: Sales Tax, Sage X3
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.

Questions? Need Support?
Get in Touch