Tag Archives: sage enterprise management blogs

Guide to create Groups after creating the new User in Sage Enterprise Intelligence (SEI)

In SEI, when we create Users, it is strongly recommended to create Groups to maintain the security based on these groups instead of an individual user. Rather than solely relying on individual user permissions, a strategic approach involves organizing users into groups with shared access levels. This practice not only simplifies administration but also strengthens… Read More »

Global Variables in Sage Enterprise Intelligence

Introduction: Sage Enterprise Intelligence has a feature to create scripts and run them in the environment using the script builder. These scripts can be created and run to create worksheets, dashboards, and SEI reports, so for these scripts, sometimes we need to provide global values that can be made available to the user for access… Read More »

How to solve reposition shipment date error in the Sage Enterprise Management sales order screen

In Sage Enterprise Management, we may come across a scenario where user get this error while creating a sales order. Navigate to: Sales → Orders → Orders In the above screenshot, the highlighted error is coming while creating a sales order. Now, follow the below steps to solve this error:Step 1: Navigate to Common Data… Read More »

How to add dimensional field in object selection

We might know how to add the Single dimensional field in the selection tab while creating the object. Refer to the below screenshot, to add a field in object selection. Navigational Path – Development->Script Dictionary->Objects Here is the Screenshot below to add Multidimensional field in the selection tab of objects. Make Table and Field column… Read More »

Write line level field values in a single line through a table with the values in fixed number of fields during file creation

Sometimes while creating/writing to a file we might need to write values from a field in a grid but through a table and not by looping through the grid and the values would be written sequentially in a fixed number of fields in a single line in the file and assigning blank values to the… Read More »

How to Copy FIle in Server using .bat Process

In Sage Enterprise Management (Sage X3) we may need to copy the file from one folder to another folder. We will do it by using .bat process. Syntax: Subprog MoveFile(PATH1,PATH2) Value Char PATH1 Value Char PATH2 Local integer RETURN_VALUE RETURN_VALUE=Delfile(filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’) Local Char WRET(250) (0..4) Openo filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’ Using [FACS] WRET(0)=”copy “+PATH1+” “+PATH2 Wrseq WRET(0) Using [FACS]… Read More »

How to Setup Stock Count in Sage Enterprise Management

Stock count is a process of counting inventory on a periodic basis throughout the year. It is the physical verification of the quantities and condition of items held in an inventory or warehouse. This may be done to provide an audit of existing stock. It is also the source of stock discrepancy information. Stock-taking may be performed as an intensive… Read More »

How to check the conformity of a string according to a pattern

You may come across the situation where you have to check the conformity of a string according to a pattern. Syntax:  pat(EXPR_STR,EXPR_PAT) EXPR_STR : is a string or CLOB expression that contains the string to be tested. EXPR_PAT   : is a string or CLOB expression that contains the pattern used for the verification. Example :… Read More »

How to setup expense notes defaults and maximums on portal in Sage X3

Step 1: Ensure that the variables containing the rates used as defaults and/or maximums are ticked for expense notes. Once “expense notes” is ticked this Variable cannot be used in a heading. Step 2: Flag input to the expense notes tab. Step 3: Ensure that all the variables are captured. Note: A separate variable is required… Read More »

How to Merge Business Partners (BP) in Sage X3

Many a times, the user creates 2 similar business partners in Sage X3 instead of 1 business partner, this results in 2 separate entities in all the related inquiries or reports. In such cases, Sage X3 provides BP Merge functionality which allows two BP accounts to be merged together, which will automatically transfer all the… Read More »