Purchase return is normally a part of business. In which, goods are returned to the supplier if they had any defects or not according to the specifications of the buyer. In Sage X3, while creating Purchase Return we may come across an error like ‘The quantity to be returned exceeds the maximum authorized: 0 UN’.… Read More »
Sometime we may come under a situation where we have to close the sales order through code. Keyword DIVSOHCLE is used to close the sales order record. For example: Below is a sales order which we have to close through our code. Fig1: Sales order record Use the keyword as… Read More »
The new feature in V12 for managing serial numbers for product using the “Global received/issued” radio button under serial no.management section in Product screen increases better usability and increase performance and productivity. Here are the steps to check the benefits using the new option added for serial number products. STEP 1: Navigate to product screen… Read More »
A Payments is like an accountant. It keeps track of who owe whom and how much. Basically it is a transfer of money or assets to another person or business. You may come across a situation where you would like to do payments for the sales invoices. Sometimes while doing payments for sales invoices we… Read More »
Sometimes we may come under a situation where we need to update a field in the same time when the workflow gets triggered. To update field on running workflow firstly we need to select a workflow rule. i.e at what action you need to update the field (For eg: on Validation, rejection, notification, cancellation etc).… Read More »
In some requirement, user may wants to see some reports when they login to the Sage X3, or for the management people thy need to see the any sets of records like Open Sales Order, Open Invoice, outstanding and many more on the login of the Sage X3. We can achieve this by following the… Read More »
In Sage X3, when a new folder is created we may come across a scenario where we don’t see a column to map accounts in Accounting code lines. Below screen capture depicts the navigation to enable the column: Navigate to Setup–>Financial –>Accounting interface–>Accounting Code Step 1: Navigate to Setup –>General Parameters–>Parameter Values. Step 2: From… Read More »
In this blog, we will see how to add a bookmark in Sage X3 version 12 since it is different than other versions of Sage X3. Navigate to home screen. In this case we will add a bookmark of ‘Customers’. So navigate to customers and select a star to add a customer to bookmark (refer… Read More »
We might come across the scenario to find template name through the mask. We can also access using standard table name(AOBJEXTD) with abbrevation[AOD] and field name EXT. Refer to the screenshot below: Write code below in specific script ‘YPEIMPBIS’ of import/export template. Example: $Action Case Action When “IMP_OUVRE”:infbox “Script Name:”+num$([F:AOD]EXT) EndCase return The result is:… Read More »
In Sage X3, We have function timestamp$ which returns a string value containing a time stamp, which is the number of milliseconds elapsed since the first of January 1970, at 00:00:00 time GMT. timestamp$ returns a timestamp in ASCII format. Below is the snippet of example code provided by standard Sage X3. <<Code snippet>>Local decimal DLocal… Read More »
