Author Archives: Greytrix

How to get the number of records modified by Update Command

You may have come across a situation where you are updating or modifying the records by Update command in X3 and want know how many records have been modified. You may be wondering of MSSQL, that whenever any updated statement is executed it gives the total count of record which is modified. Similarly in Sage… Read More: How to get the number of records modified by Update… »

Allocation Rule to Fetch Products based on Expiry date

Have you ever come across a situation in Sage X3 where you would like to move out the‘First expired product first out’.For that we should set the allocation rule. New Stuff: How to use local menus in a miscellaneous table Here is the way to set First Expired First out allocation rule. First go To Setup->Inventory->Allocation… Read More: Allocation Rule to Fetch Products based on Expiry date »

Greytrix Too Falls In Love With Sage ERP X3 Version 7

Sage ERP X3 Global Convention becomes memorable with release of Sage ERP X3 version 7 – The right ERP solution with the right technology LinkedIn | Twitter | YouTube | Google + | Facebook | Blogs May 17, 2014, Lisbon, Portugal : “The Future is already here” and we saw this happening at the recently held Sage ERP X3 Global Convention at Lisbon, Portugal. With 900+ attendees at the… Read More: Greytrix Too Falls In Love With Sage ERP X3 Version… »

Fetching the parameter values

In custom sage X3 development, we frequently use parameters for the use of constant values. New Stuff: Filtering the Selection List in Sage X3 without Object There are two ways to fetch the parameters values:      1.  Creating global variable: Creating global variable and assigning the parameter values to it.But   whenever the parameter values change, we need to… Read More: Fetching the parameter values »