Discount can be used in a different way in Sage X3. For example on the basis of percent, amount, etc. In this blog, we will see the different set of values for a discount in Sage X3.
Navigate to Setup > Sales > Price list > Structures User can see the different values for discount (Refer below screenshot).
These values are used to define whether the value is an amount or percentage.
When it is an amount, the entered amount in the transaction is applied to the document.
When it is a percentage, it can be combined with percentages previously defined, or applied
in series to these elements.
There are thus two choices in this case: % combined, and % series.
Let’s see an example of the above values:
Amount: Let’s say the values are set as ‘Amount’ for Discount 1 and Discount 2. Now, I have created an invoice document with gross price 100 and discount 1 as 5 and discount 2 as also 5 (refer below screenshot).
As we can see in the above screenshot, amount $ 10 (5 from Discount 1 and 5 from Discount 2) is deducted from Gross price (100) and total amount after the discount is 90 $.
% combined: Now let’s say that the values are set as ‘%combined’ for Discount 1 and Discount 2. Now, I have created an invoice document with gross price 110 and discount 1 as 5% and discount 2 as also 5% (refer below screenshot).
As we can see in the above screenshot, amount 11$ (5% from Discount 1 and 5% from Discount 2) is deducted from Gross price (110) and total amount after the discount is 99 $.
In %combined both discounts are applied on gross price. See the below calculation:
- Discount 1: 5 % 110*5%= 5.5 $
- Discount 2: 5% 110*5%= 5.5 $
- Total Amount = 110 – (5.5+5.5)= 99 $
% series: Now let’s say that the values are set as ‘%series’ for Discount 1 and Discount 2. Now, I have created an invoice document with gross price 110 and discount 1 as 5% and discount 2 as also 5% (refer below screenshot).
As we can see in the above screenshot, amount 10.72 $ (5% from Discount 1 and 5% from Discount 2) is deducted from Gross price (110) and total amount after the discount is 99.28 $.
In %series Discount 1 is applied on gross price and Discount 2 is apply on Gross price – Discount 1 amount. See the below calculation:
- Discount 1: 5 % thus 110*5%= 5.5
- Amount after Discount 1 calculation = 104.5
- Discount 2: 5% thus 104.5*5%= 5.225
- Here Discount 2 is applied on the amount after Discount 1 calculation
- Total Amount = 104.5-5.225 = 99.28 $
This explains the different set of values for discounts in Sage X3 which can be useful in different ways.
About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation expertise.
Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.
Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.
For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.