Customer Retention is the important business sense for the growth of an organization. We have to keep our customers engaged and interested in our products and services. With some improvement in service quality and loyalty incentives, it is easier to retain the existing customer base and keep them happy. The 3 pronged approach to retaining… Read More: Integrating Loyalty program with Sage X3 system »
You may come across a scenario where you would like to mandate Dimension Types at transaction level, you can do the same with the following setups. Go to- Setup> Organizational Structure > Companies New Stuff:How to Disable Inventory Shortage generation in Transactions and Inquiries Select Company for which you would like to impose the same… Read More: How to mandate Dimension Types in any transaction wherever required… »
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: How to Disable Inventory Shortage generation in Transactions and Inquiries »
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: How to get Rowcount in Sage X3? »
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: How to setup Auto Quality Control generation on Purchase Receipt »
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: How to add navigation buttons in left list in version… »
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 »
