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 »
While printing the report through code you may need to print the report or label in the printer defined on the ADC destination .The below mentioned global variable are available in x3 in which the label destination and Document destination are stored GVTETI : This global variable is used to store the Label destination GVTDOC… Read More »
If we come across a scenario where we want to enable warehouse selection field in Customer return Management screen then Sage x3 provides a standard functionality to enable the field. Navigate to Sales ->Returns ->Customer returns Steps to enable this functionality: Navigate to Setup ->Organisational Structures->Sites Enable Warehouse Management checkbox under Warehouse Tab Create Warehouses… Read More »
We may have situation where we need to split one order line into many order lines as per business requirement. Sage ERP – X3 provides a feature in which you can split a line based on Rec site, Address, Quantity and Expected Receipt Date. To achieve this functionality, Navigate to Purchasing → Orders →… Read More »
Iomode is used to assign for each open sequential file, the following parameters: Adxirs, Adxifs, Adxium. Syntax: Iomode ( Adxirs | Adxifs | Adxium ) Expression [using abbrev] where abbrev describing the open file. Examples: # Read of the first 10 words in the line in sequential files # the fields are separated by ‘ … Read More »
There might be situation where you want to issue the prepayment in bulk. Sage x3 provide a feature in which we can issue the prepayment in bulk. To achieve this feature, Navigate To:Sales>invoices>Issue Prepayments The issue of prepayments is made, in mass, simply by selecting a planned issue deadline. You can also print them if… Read More »
You may come across the situation where you have to find the last date of any month whether it is 30, 31, 28 or 29. To do so we can take help of EOMONTH function. Syntax: eomonth(DATE_EXPR) DATE_EXPR is an expression returning a date value. Consider following example where we have to find out the… Read More »
This function is one of the date function which will return the DAY number of the week from which we will be able to perform the other functionality. Function dayn(Date): The “dayn” function excepts one parameter which we need to pass the date for which we need to find the weekday number. Example: Output: These… Read More »
