There can be occasions when you want to Move focus/cursor to a particular tab, edit box or drop down programatically. In a custom development we have come across the above scenario where in we need to move cursor to second tab automatically when user enters valid sales order number in first tab. New Stuff: How to… Read More: How to Set Cursor to a given edit box via… »
Sage X3 has a special feature for search product price list before ordering a product from a customer, or even for checking reasons, it is possible to check which price list will be applied at a given date, for a given currency, for given sites and finally a given quantity, for the product-customer pair. New Stuff: How… Read More: How to search product price list »
In our development, we rarely execute the Sql statement using Exesql instruction. But how will you come to know that your statement has executed successfully or not. To check the status of your last executed sql statement we will use Adxsqlrec keyword in our code soon after executing Exesql instruction. New Stuff: How to restrict products… Read More: How to know the status of the last executed sql… »
In a business scenario you may want to restrict some products being added to a particular location. Sage X3 has a feature to handle this scenario. We can set up this in Location type of that location. New Stuff: How to setup Auto Quality Control generation on Purchase Receipt Navigate to Common data>Product tables>Location types And… Read More: How to restrict products by assigning to a particular location »
There might be a scenario where you would like to create auto Quality Control against Purchase Receipt, you can do the setup as follows New Stuff: How to restrict to modify the delivery address on the detail line Go to the said path Common data > Products > Product categories Select the category from the right… Read More: How to setup Auto Quality Control generation on Purchase Receipt »
There might be a scenario where you have to restrict to modify the delivery address on the detail line of a Sales order, Deliveries and Quotes. New Stuff: How to restrict to modify the Sales representative on the detail line Sage X3 provide the feature to restrict to modify the delivery address on the detail line… Read More: How to restrict to modify the delivery address on the… »
There might be a scenario where you have to restrict to modify the Sales representative on the detail line of a Sales order, Invoices and Quotes.. New Stuff: How to resolve “Too many published fields” web service publication error…? Sage X3 provide the feature to restrict to modify the Sales representative on the detail line of… Read More: How to restrict to modify the Sales representative on the… »
While working with the Sage X3 web services you may come across the error “Too many published fields” errors while web service publication. New Stuff: Know all X3 table details on the go from one screen This error is due to the dimension value set maximum level on the transaction lines screen. To overcome the error… Read More: How to resolve “Too many published fields” web service publication… »
One of our client come up with new requirement where the user will import customer’s raw data from their third party application and validated before making the customer active even if customer flag is set to Active in the importing file. New Stuff: How to determine number (N) of combinations in X3? This can be achieved… Read More: How to validate a customer while importing »
You may come across the situation where you like to know the name of the fields in the table. Sage ERP X3 has a special feature of getting fields name of the table with the help of “adxfname” keyword which will return you the value. New Stuff: How to determine number (N) of combinations in X3?… Read More: How to find fields of the table »
