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.
      
      
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.
      
      
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.
      
      
      
      

Enhance. Extend. Evolve.

It’s What We Do

Enhance your current system. We’ll assist you in selecting, implementing, and supporting your accounting and management information solution with the latest in IT hardware and software.

Extend your IT footprint. We provide a range of IT solutions including ERP and accounting software, systems and network integration, Internet/Intranet applications, custom application development, e-commerce, and Business Intelligence reporting.

Evolve as technology progresses. We research and test new technologies so that you stay current with the latest solutions.