Category Archives: Tips

How to assign the allocation and issue rules on product categories?

You may come across a scenario where you want to set the allocation and issue rules on product categories. Sage X3 has standard feature where you can set the allocation rule. Create the allocation and issue rules on below path. Navigate: Setup>Stock>Allocation and issue rules Assign the above created allocation rule on product category. Now… Read More »

How to avoid clashing between local variable and table column name?

In Sage X3, we may come across the situation where we may be having some variable name declared in the code file and the same variable in table. Sage X3 has special keyword to make differentiation between local variable and the table variable as there can be same name used while declaring the local variable… Read More »

How to Check Whether the Given Directory/ Path Exists or Not

In Sage X3, we may come across a situation where we need to know whether the path or a particular directory exists or not. We can know this using following function: Syntax: filinfo(path_fil, arg_ent) Parameters: path_fil: Char type expression for the file path to be tested Arg_ent: Integer expression specifying the property to be found.… Read More »

How to handle the errors in Sage X3 with custom message?

Here, we are going to look for the standard Sage X3 error handling process. It helps to trace error and passes error message to the end-user. Also it will helps to avoid interruption. In other word, it states the error and allow us to continue with the error messages. In Sage X3 when a number… Read More »

Rounding off Net Unit Price in Sales Order

In a Sales order, while dealing with pricing we may want to round off net price to the nearest decimal. Sage X3 provides a parameter where we can set whether we want to round off the price or not. SALRND parameter is helpful when the pricing value is in decimals. This parameter stipulates whether a… Read More »

How to add Sales Invoice elements in X3?

Sales invoice is a bill issued by the seller and is proof the selling process has already happened. The setup of the invoice footers is used to define the numbered codes which are calculated upon valuation of the invoice footer. Based on the setup, this valuation can be performed starting from: The value defined when… Read More »

Re-order suggestion in X3 by Periodic Replenishment method

This post is the continuation of our previous post were we discussed about the functions of Statistical Re-Ordering using the re-order threshold method. In this Blog we will focus on the Statistical reordering through Periodic processing method. The New Stuff : X3 Commands for Dynamic Changes Periodic Processing:  The periodic replenishment method is used to… Read More »

X3 Commands for Dynamic Changes

Many a times we come across scenarios when we need to dynamically change the labels or format or style of the fields/tabs/sections. X3 provides some easy commands which help us in achieving the same which can change title of any fields/Sections/Tabs dynamically on any field action. Just for your better understanding some of the dynamic… Read More »

Statistical Re-ordering – How to create re-order suggestion in Sage X3

An ERP application that is smart to provide you with recommendations and suggestions!!! Well that’s exactly what Sage’s X3 is about. X3 can aid you in suggesting the exact quantity of products that needs to be ordered in case of shortages in Inventory. This is achieved through Statistical Re-Ordering  (Navigate through “Inventory-> Reorder->Statistical Re-Ordering” (Process… Read More »