Tag Archives: Sage X3 technical blogs

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 »

Add the Comment (Line level Text) in the Detail line

In some cases, we need to add the comment or some text in the detail line level. In Sage X3 we have that functionality to add the comment and some text at line level. We can add the text to line level as follows. Step 1: In the detail line level, we need to click… Read More »

Stock Change in Sage X3

We may come across a scenario where you want to move the stock from one location to another location. Sage X3 have the special feature to achieve this functionality. Follow below steps to achieve this feature: Navigate to Stock > Internal Transactions > Stock changes Enter the quantity that you want to move from one… Read More »

Find a particular value from a series of Numerical, Alphanumerical or Date Expressions or Variables

We may have come across a situation where you need to find a particular value from a series of numerical, alphanumerical or date expressions or variables. This can be achieved using “find”. Syntax: find(value_to_seek, list_exprg) value_to_seek is the value that needs to be found list_exprg is the series of numerical/alphanumerical/date expressions/variables Example: Consider an example… Read More »

Deferred Deletion in Sage ERP X3

In Sage X3 while performing deferred deletion we may get the below error message.”Deferred deletion is not active for this object”. Navigate to:  Development > Utilities > Miscellaneous > Deletions To avoid this message navigate to  Development > Processing dictionary > Objects Checked the Deferred validation checkbox. Save and validate the object. Hope this blog… Read More »

Optimize the Performances when several Insertions of Database Lines must be done

Sage X3 provides a special function Writeb to write into a table. It works similar to Write function but it allows us to optimize the performances when several insertions of database lines must be done. Syntax: Writeb Writeb[CLASS] where, CLASS: a classidentifier that corresponds to the abbreviation used to open a database table. Writeb allows… Read More »

How to generate a Sequence Number manually

You may come across the situation where we have to generate a sequence number manually, consider the following example. Where sale order number is ALLSONAO0110005, we want next sales order number to be generated is ALLSONAO0110008 to do so we have to go to the sequence number values screen. Add the seq counter, give next… Read More »

How to Validate Postal code Field in Sage X3

In Sage X3, we can enter the Postal code on the addresses of entities as Company, Site and all the BP entities (BP, Prospect, Customer, Supplier, Carrier and Sales rep). In Sage X3, we can manage the entered postal code by verifying with existing postal code. Kindly follow the below steps to enable this validation.… Read More »