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

Questions? Need Support?
Get in Touch

Which solution WORKS BEST for your business?

»Take this quiz to find out!

Find the Solution that WORKS BEST for your Business!