In Sage X3, discounts can be configured using Invoicing Elements and applied automatically throughout the Sage X3 sales order processing workflow. However, when a Sales Order is fulfilled through multiple partial deliveries, users may notice that the Sage X3 discount percentage is applied only to the first invoice and not to subsequent invoices. This can lead to inconsistent Sage X3 customer billing and require manual adjustments.
In Sage X3, discounts can be configured using Invoicing Elements and applied automatically throughout the Sage X3 sales order processing workflow. However, when a Sales Order is fulfilled through multiple partial deliveries, users may notice that the Sage X3 discount percentage is applied only to the first invoice and not to subsequent invoices. This can lead to inconsistent Sage X3 customer billing and require manual adjustments.
A Sales Order was created with a discount percentage, and the order was delivered and invoiced in multiple stages.
Example
The table below illustrates the Sage X3 delivery invoice discount issue before the fix:
|
Transaction |
Sales Order |
1st Invoice |
2nd Invoice |
|
Discount % |
10% |
10% |
0% |
The Sage X3 invoice discount not carrying forward issue is caused by the configuration of the Discount Percentage Invoicing Element under the Transfer Rules.
The existing setup was configured as:
With this Sage X3 transfer rules configuration, Sage X3 transfers the discount percentage only to the first delivery generated from the Sales Order, preventing it from being carried forward to subsequent deliveries and invoices.
To fix the Sage X3 split rule and ensure consistent discount application:
Navigation: Setup → Sales → Invoicing Elements
|
Field |
Existing Value |
New Value |
|
Split Rule |
1st Delivery |
All Deliveries |
|
Grouping Rule |
1st Order |
Average Percentage |
After updating the Sage X3 invoicing element setup, create a new Sales Order with a discount percentage and process multiple partial deliveries and invoices. The Sage X3 discount percentage on multiple invoices will now be applied consistently across all deliveries and invoices:
|
Transaction |
Sales Order |
1st Delivery |
1st Invoice |
2nd Delivery |
2nd Invoice |
|
Discount % |
10% |
10% |
10% |
10% |
10% |
Note: This change applies only to newly created transactions and will not affect existing Sales Orders.
If Sage X3 discount percentages are not appearing on subsequent partial invoices, the root cause is typically the Transfer Rules configuration of the Discount Percentage Invoicing Element. By changing the Split Rule to All Deliveries and the Grouping Rule to Average Percentage, the Sage X3 average percentage grouping rule ensures the discount is consistently applied across all deliveries and invoices ensuring accurate and reliable Sage X3 customer billing and eliminating the need for manual billing corrections in the Sage ERP invoicing workflow.
