You may come across the situation where you need to call a bat file from Sage X3. Consider the following example: – where you need to copy the GTM file with .txt extension to the test folder with some different file name, to do so write your command line code in a file and save… Read More »
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 »
In some industries where the Company has only one Site which actually stores and deliver goods and other sites are only financial sites which manage the payments. i.e. the financial sites can be stores and the Storage site is a warehouse where goods are stored. E.g. Car showrooms can be financial sites in different part… Read More »
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 »
You may come across the situation, where you may want to give user-level access to fields present on Screen. In this case first create access code by navigating to below given path. Setup → users → access code Now assign this access code on required fields as shown below. Now this fields are accessible to… Read More »
In Sage X3, we may come across a scenario where you may need to set a particular dimension type as a default dimension for Sage X3 users. For example, we have created a new dimension type X and we want to set it as a default dimension type for users then we can easily do… Read More »
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 »
Sage X3 provides a functionality to restrict certain products to be sold on the Sales Order, when the products cannot be sold to the customer unless the customer is authorized to buy such products. e.g. liquor products, medicine products etc. Follow below steps to create a restricted pricelist. Navigate: Setup -> Sales -> Pricelists ->… Read More »
We may come across a scenario where we want to lock the folder in Sage X3. Sage X3 have a special feature to achieve this functionality. Follow below steps to achieve this feature: Click on Welcome Panel. Select Sage X3 folder (Refer below screenshot). Now navigate to Development > Utilities > Folders > Folder lock… Read More »
One of the date function which will return the number of days passed between 1/1/1600 and the parameter date. Syntax : nday(date_exp) Parameters: date_exp – date expression Example : X = nday(date$) Description : The nday function allows us to go from a date to a number of days. We may replace nday(DATE) with DATE… Read More »
