Tag Archives: Sage X3 Blogs

How to Solve “Record already exist error” while creation of Transaction and Masters

We may come across a scenario where we get “record already exist’ error while creation of transactions and masters. The problem can be solved by using below steps: In below screenshot, we have faced an error while creating a product. This error occurs because the product of sequence number BMS089 already exists in the X3 for… Read More »

How to add analytical dimension in report parameter

In Sage X3 we have come across a situation where we need to add analytical dimension in report parameter. Example: Let us consider adding analytical dimension Cost Center for report parameters. In Report Dictionary –>Parameters we will add the Parameter filed Cost Center with its respective type i.e. CCE. Now in Object/dependency parameter we will… Read More »

How to find out the Local menu number of any message

You may come across the situation where you get any error message, and you need to find out the local menu of that message. You can go to the >>Transaction>>text search Hope this helps!   About Us Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance… Read More »

How to Prohibit Zero lines in Invoice

We came across the requirement where client wants to disallow the user from entering Zero Amount in line level in Invoice. In Sage X3 we have setup in Parameters values where we can stop the user to enter zero values in line level. Goto–> Setup–> General Parameter– Parameter Values -TC Commondata- We need to enter… Read More »

Inactive/active setup for assets import

In Sage X3, we may come across a scenario where we want to import fixed assets by using an import template. As imported asset is automatically considered as “Inactive”, Sage X3 has a functionality where we can set the imported parameter to”Active”. Navigate To: Set UP>General parameter>Parameter values>AAS Fixed assets Fixed Assets Parameter Set-up Screen-1… Read More »

How to get the Length of a Character String in Sage X3?

In Sage X3, we may come across various scenarios where we need to get the length of a character string from an existing string. Sage X3 provides “LEN” keyword which returns the length of a character string. Syntax: len(expr_c) Example: # Display the content of the variable DATA with blanks spaces to 25 characters. Output:… Read More »

How to solve “Valuation Method Not Found” error

We may face an error that “Valuation method not found” during the creation of miscellaneous receipt. Follow steps to overcome this error: Below is the screenshot of the error message you may face during the creation of miscellaneous receipt. To solve this error Navigate to Products >Products Site>Cost tab (Refer screenshots). Select Valuation method from… Read More »