Author Archives: Greytrix

How to set up matching tolerance for purchase receipt

Matching tolerance is a functionality in Sage X3 which allows the user to set up and maintain tolerances in purchase module. Kindly follow the below mentioned step to set up matching tolerance: Navigate to Setup >> Purchasing >>Matching tolerances The Matching tolerances codes are used to define the degree to which the quantity of purchased… Read More »

How to run accounting task for multiple transactions

We may come across a scenario where we want to run an accounting task for multiple transactions at a time. We can achieve this functionality by using the below steps: Navigate to Usage > Batch Server > Accounting tasks Stop the accounting task. Now navigate to Set-up > Financial > Accounting interface > Accounting tasks… Read More »

How to repeat a sub-string using Sage X3 keyword

You may come across where you wanna a repeat the word n times. String$ is used to define a string , the result of repeating a sub- string or an ascii code. If the number of characters in the result is more than 255, the string returned is truncated to 255 characters without generating an… Read More »

How to get the size of the keys

You may come across where you need to check the size of the keys. keylen determines the size of the keys (in number of bytes) for an open table. Keylen is a variable table of the [G] class associated with a table declared by a File command. The dimension of keylen is given by the [G]nbind… Read More »

How to find the inverse hyperbolic cosine of a number

In Sage X3, you may come across various scenarios where you need to get the fins the inverse cosine of a specified number. Sage X3 provides “ach” hyperbolic function which return the inverse hyperbolic cosine of a specified number. Syntax : ach(number) Examples :   Output : fig. Number value   Notes : For real… Read More »

How to Close/Open Mass purchase orders in one click by variance Quantity

This post shows how to close / open mass purchase orders in one click by variance quantity. Sage X3 provides the feature of closing the open Purchase Order with additional selection criteria on tolerance percentage for quantities received along with Site, Order date, Order number, Supplier, Product. In other words, Orders that are received will… Read More »

How to find the current Payroll Month (Sage X3 People)

What is Payroll? A Payroll is a company’s list of its employees, but the term is commonly used to refer to the total amount of money that a company pays to its employees. A company’s records of its employees’ salaries and wages, bonuses, and withheld taxes. The company’s department that calculates and pays these. In… Read More »