Tag Archives: price

Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice Transactions

As we all know, while creating any transaction in Sage X3, we can enter quantity and price manually in detail line as per the requirement. But one of our client wanted to restrict the creation of the Sales/Purchase Invoice Transactions if the user is trying to enter ‘0’ in Gross/Net Price and Quantity fields. Even… Read More »

Validation on Miscellaneous receipt based on Tolerance value

For any transaction in Sage X3, user can enter price manually as per his/her requirement. But one of our client requested to add validation on the price field in Miscellaneous Receipt Transaction. To achieve this requirement, we have added “Tolerance Percentage” field in the Product master as shown in the below screenshot. In which user… Read More »

Automatic Price calculation in Sales Transactions

In Sage X3, user can enter a Gross Price manually for any product in any Sales – Purchase transactions. But one of our client wanted to calculate gross price automatically while creating Sales transactions on the basis of LOT Numbers. To achieve this requirement, we did a customization on Product master, Work Order and Sales… Read More »

How to control Calculation basis of discount in Price structure

In Sage x3 we can control Discount calculation on what basis it should be calculated. In sales document we can enter Discount which will be calculated on 3 basis ‘By unit’, ‘by Line’, ‘by Document’ Navigate to Setup > Sales > Price list > Structures User can see the different values for Calculation basis (Refer… Read More »

How to set fixed price of carrier for a specific invoicing element

In Sage X3, we may come across, where a user wants a fixed price of the carrier in a specific invoicing element. This functionality can be achieved by following steps: Navigate to:  Setup → General Parameters → Parameters Values → Sales → Folder → Seed → Invoicing rules → Details If user want to check… Read More »

How to set the default price reason

Do you know Sage X3 has a feature where you can set the default price reason. Default Reason for the manual price Default reason for a base price New stuff: Automatic Reversals Follow the below steps to set the default reason for a manual price Navigate Through: Setup>General parameters>Parameter values Set the parameter “DACMANSAL” for default… Read More »

Sales Price Structure Feature in Sage ERP X3

Sage X3 offers a feature which adds some additional elements while determining the Sales Price. The additional elements corresponding to the factors such as Royalty, Rebate, Freight, Discounts etc… While we define this within the price structure, all these structures are added as columns within the Invoice line along with the Sales Price. There are… Read More »