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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
Sage X3 have the functionality in which we can get all the information of all the Sage X3 tables along with the size of tables in a database from one screen only. New Stuff: How to validate a customer while importing Navigate to: Development > Utilities > Verification > Database > Table report Enter your folder… Read More »
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 »
