You may come across the situation where you need to access the physical folder path in Sage X3. It could be easily achieved with the help of the keyword ‘filpath’. filpath: Filpath creates the access path to a file on a Sage ERP X3 application server. Syntax: Current_Folder_PATH=filpath(“”, “”, “”) Specific_Folder_PATH =filpath(“”,””,””,”Folder_Name”,””) Parameter Details: Folder_Name:… Read More »
When you have created sales order, your next step is to do allocation of the items in sales order. You may come across a situation where a sales order is signature managed. In signature management, we can decide whether allocation should be allowed on unsigned orders or not. There is a parameter SOHAPPALL which is used… Read More »
When it is necessary to substitute components or material on a Work Order BOM, Sage X3 allows the replacement of components on a Work Order if the Product’s Routing allows it. Following are the two methods for replacing a component with a substitution product Method 1: Remove the original component Method 2: Replace a component.… Read More »
You may have come accross a situation where you need to find if a transaction is underway during a process. Adxlog can be used to achieve the same. Return value is of type ShortInt. Function Adxlog(ShortInt) – It returns one the two values : 0 or 1. 0 indicates that no transaction is going… Read More »
You may come across a situation where you would like to know the abbreviations for open tables. Sage ERP X3 has a function called “fileabre” which contains the abbreviations for all open tables. fileabre is an Adonix system variable of the character string type that contains the abbreviations for all tables opened via the File… Read More »
In Sage X3, you may come across a scenario where you have to do customization on any inquiry screen. For screen level changes, we simply need to make the changes and validate the corresponding screen. But, it will not reflect the changes unless we do entry transaction validation of that Inquiry screen. This validation is… Read More »
We came into circumstance where one of the Client asked to allocate the bulk work order. Sage X3 provide feature to mass allocation processing of the materials linked to the production for a given site, a given period and a selection of a work orders. This processing can allocate material in a global or detailed… Read More »
You may come across a scenario where you want to do the journal validation in bulk. Sage X3 has feature where you can Finalize or validate the journal entries in bulk. Navigate To: Financial>Current processing>Final validation (Refer the below screenshot) In this process you can select the different criteria. This function changes the journal… Read More »
You may come across the situation, where you may want to export report in particular file format. This can be done through coding using FITCHIER action. FITCHIER action is called before the display of the selection window for the export format, when the user wants to export the print to a file. This action is… Read More »
The Customer working day’s logic works on the Delivery date. Therefore if a particular work day is unchecked in the Customer – Ship to tab then the Delivery date cannot be chosen on the unchecked work days. However working day’s logic does not affect the Shipment date. Navigate: All -> Common data -> BPs ->… Read More »
