In current scenario, if there is no adequate quantity for any product in the existing Inventory then during Sales transactions such Sales Order the shortage column is updated. What if the user does not want to show there are shortages in the system? For this there is a provision in Sage X3 where the user… Read More »
In this blog, we will look how to get the number of records in the current table. Sage X3 has the solution to know with the help of keyword ‘rowcount’ along condition. New Stuff: How to setup Auto Quality Control generation on Purchase Receipt In order to know the total number of records in the table,… 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 Go to the said path Common data > Products > Product categories New Stuff: How to add navigation buttons in left list in version 7 Select the category from the right list… Read More »
There is no limit of creating records in ERP. The main task is to navigate and find the record. Left list in Sage X3 holds and display all the records/transactions. We can add/remove the navigation buttons in left list of windows of Sage X3. In Windows under Browser tab, set the “Pointers” options to “Yes”… Read More »
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 »
