How to restrict products by assigning to a particular location

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 »

How to setup Auto Quality Control generation on Purchase Receipt

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 »

How to restrict to modify the delivery address on the detail line

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… »

How to restrict to modify the Sales representative on the detail line

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… »

How to resolve “Too many published fields” web service publication error…?

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… »

Know all Sage X3 table details on the go from one screen

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: Know all Sage X3 table details on the go from… »

How to validate a customer while importing

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 »

How to determine number (N) of combinations in X3?

In Sage X3 customization you may come across the scenarios where you want to calculate the number of combination. You can easily determine the number of combination by CNP. New Stuff: How to create Sales delivery from Sales order by programmatically? cnp(N,P) returns fac(N) / (fac(P) * fac(N-P)). About Us Greytrix – a globally recognized Premier… Read More: How to determine number (N) of combinations in X3? »

How to create Sales delivery from Sales order by programmatically?

You may come across a situation, where you may want to create Sale delivery from Sales order programmatically. New Stuff: Disallow user login password to blank Here we are describing, please refer below code snippet for the same- Below is the snippet of code for reference. Below is the delivery created for order. About Us… Read More: How to create Sales delivery from Sales order by programmatically? »