As we know, we can deploy customization or changes on client system through patch. If patch integration does not go well, the log gets displayed with errors. We will see in this blog how to resolve error in below screenshot. Here, I tried to integrate patch containing table “YONEPAY”. But, I received the above error.… Read More »
In Sage x3, we may come across a situation where we have to get the version number of the product installed and use it in our code to display the same. Sage X3 provides a Method ‘AGETLIC_PRODUCTVER’ that returns the product version. Method: fmet GACTX. AGETLIC_PRODUCTVER (“1”) Code snippet: Local char YLICINFO (30) YLICINFO= fmet… Read More »
In this blog, we will see how to add State field in BP Master.This can be done by following below mentioned steps. Step 1: As seen from below Screenshot no State field is there in BP Master Screen. Follow the below steps Navigate:Common Data->Common Tables->Countries->Details Tab Do the following setting 1. Select Subdivision checkbox 2.… 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 may come across the scenario where we face the below issue while importing file in ‘INV’ template for creating stock counts. Fig1.1 shows an error message which displays in the log while importing file. Above error gets resolved by the following steps: STEP I: Navigate to :Setup->Stock->Stock Parameters. STEP II: In Reordering Tab enter all… Read More »
In Sage X3, we can add a customized field in existing inquiry screens. To reflect the changes we perform entry transaction validation of respective Inquiry code. However, sometimes, it may happen in spite of validating it the changes do not reflect. In such cases, you need to check whether you have set order for the… Read More »
In Sage Enterprise Management, we may come across a scenario where we may face the below journal, not open error while running the accounting interface. This error resolve by following steps: Navigate to: Common data → G/L accounting tables → Journal codes Enter the company and opening date and click on the OK button. Hope… Read More »
In Sage Enterprise Management, as you know we have a special function to print the reports. To print a report, we need to enter the values in report parameters. In case, there are multiple parameters and you want to print the report for same parameters in future then instead of entering all the parameter values… Read More »
As you know, Sage Enterprise Management provides its own select, update statements like SQL. For efficiency, we can use SQL queries in Sage X3. Sage X3 provides special function to execute SQL statements/ commands. The special function is Execsql. It is used to launch a SQL request that does not require the return of information,… Read More »
As you know, whenever we want to upload any file either in Sage X3 or in any programming, we get drop box from standard for file selection where we can select the file to be uploaded. As said, this pop up comes from standard. But, in Sage X3 we can pop up dropbox through our… Read More »
