While creating or modifying the template of xml file type you may come across some validation errors, this blog will guide you to overcome this error. While creating the template you may get the error as ‘indicator is mandatory’ to resolve this error you have to add the table in the ‘Identifiers’ tab. New Stuff:… Read More »
If you want to scan the product by UPC code then the first thing that will come in your mind to achieve it will be through coding in that field. But that will choke you to change the data type of the field too from “ITM” to “A”. Coding and changing the data type will… Read More »
You may come across the situation, where you may want to get the sum of table column in Sage X3. Sage X3 has a special function to get the sum of table column. New Stuff: How to get the random decimal number between 0 to particular digit sum: This function is used to get sum… Read More »
You may come across the situation, where you may want to get the random decimal number from 0 to particular digit in Sage X3. New Stuff: Export menu items in JSON file format in Sage X3 V7 Sage X3 has a special function to get the random decimal number between 0 to particular digit. rnd: This… Read More »
Menu Items is a new concept introduced in Sage X3 Version 7. We need to create a menu item in order to access the window or any function. But what if we need to deploy our customization (which contains numerous menu items) on different endpoints. Then we have to create separate menu items in every… Read More »
In our previous blog, you saw the how to do pre-payment of a particular sales order? In this blog, you will see how to do the delivery of an order if prepayment is not received. Sage ERP X3 has provided a feature for that. New Stuff: Find number of users logged in Sage ERP X3 1.… Read More »
While trying to import a file into X3 using import/export template you may come across a situation where data gets truncated and incomplete value gets imported. The reason may be the file you are trying to import contains the ‘CR’ (carriage return)’and ‘LF’ (line feed) at the last record of the line. To import this… Read More »
You may come across a situation where you would like to restrict the user to enter limited characters in a field. Sage Enterprise Management has a special feature in which you can validate the fields with the help of “Chgfmt” keyword. Chgfmt: It is used to change the format of the mask field. It is also used… Read More »
When you quick search in a left list in X3 Version 6, you have to enter “*-search string-*” each time, otherwise the search won’t work and you will get no results. New Stuff:How to use columns in Sage X3 ERP? We can avoid including the * in quick search by writing a small logic into… Read More »
You may come across a situation where you would like to update only few fields from the table. So we are using “Columns” keyword in Sage X3 to accomplish desired requirement. New stuff: How to find the name of the window Description: The “Columns” instruction is only taken into account by the For loop and Rewrite instructions.… Read More »
