There are many a time when we need to get the aggregate or maximum function but 4GL Language does not offer a syntax for the same. But we definitely have an option to use SQL queries in 4GL and this does the most of the job for us. Just go through the statements mentioned below:… Read More »
Sage X3 has come up with the interesting feature of Product Cost Transfer. The standard Cost Transfer (COPYCOUT) function under the costing module can be used to transfer the product cost. Cost Transfer: Costing > Miscellaneous Processes > Cost Transfer (COPYCOUT). Below is the standard screen of cost transfer: This function is used to transfer… Read More »
Ever ran into a situation where you are asked to enter dimensions (get the below screen shot) for a particular ledger account even if no Dimensions are set against the account. And you are not allowed to do the transaction unless you provide the dimensions to that Account To create/perform transactions in Sage X3 without… Read More »
In our last blog, we have discussed that how we can add the crystal report in Sage X3. After adding the report in Sage X3 it is mandatory to print the report from the respective window. In this blog, we will explain that how to attach the report to the window of sage X3.To achieve… Read More »
While working with Pricing or creating a new Price Code we can set its priority in order to increase or decrease its processing order. Priority Flag (highlighted in snap) is used to assign a priority to the price list in order to enable it to be classified in the search order. Price lists are processed… Read More »
Sage X3 enables us to help keep a track on the revisions made to Order Documents. The revision number tracking can help us determine the number of times the order had undergone changes. You will need to tweak the Parameter SALREV in VEN Sales chapter as Sage X3 do not have the feature of Revision… Read More »
In X3, we developer may come across with the requirement where we need to filter the local menu values for the fields. There are simple techniques available in X3 to filter the local menu values. Follow the below steps to filter the local menu field records: The M data type of local menu is non-modifiable… Read More »
Assigning Activity Code to the Customized development is the basic understanding in Sage X3. Often our development spreads vast in Sage X3 and we are not able to recognize that which screen, table, field, window, object, action, report, etc. we have developed/modified and assigned our activity code. Sage X3 provides a very useful feature used… Read More »
In ERP Sage X3 we can set the credit limit on different level i.e. Folder level or Company level. By default credit limit is set up on the folder level. You can change the credit limit setting through the following steps: Navigate through Setup > General Parameters > Parameter Values. You will get the below… Read More »
In Sage X3, we do not have the functionality where we restrict the product to be sale only in the state where we deal with. Normally when we create any sales order or sales quote we don’t have the functionality to mark the product as restricted to certain state that we want. To achieve this… Read More »
