Tag Archives: sage enterprise management blogs

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 »

WIP posting for Sub-contracting orders in Sage Enterprise Management

In Sage Enterprise Management, WIP posting is an important stage which allows one to generate Journal Entries for subcontracting processes. Subcontracting refers to the process of entering a contractual agreement with an outside person or company to perform a certain amount of work. It is a process, wherein any manufacturing organizations either provides full or partial… Read More »