Category Archives: Sage ERP X3

Get Sage ERP X3 executable Path for runtime temporary file generation

You may come across a situation where you will need a path that can be used for runtime temporary file generation. We can use the Sage ERP X3 executable path for runtime temporary file generation purposes. Sage ERP X3 has a special function to get the executable path. New Stuff: Real time Tabs in GUMU… Read More: Get Sage ERP X3 executable Path for runtime temporary file… »

How to restrict the Automatic allocation in Sage X3

An allocation is an amount of something, especially money, that is given to a particular person or used for a particular purpose. Allocation is the process of assigning product items from the inventory to shipping orders and then fulfilling the shipping orders from appropriate fulfilment sites such as drop-ship vendors, virtual sites, warehouses, or a… Read More: How to restrict the Automatic allocation in Sage X3 »

Adding run time selection criteria in SQL requester

You may come across a situation where you want to add criteria’s for SQL requester. Follow below instructions to add search criteria to the SQL requester. New Stuff: How to use Import to Excel functionality in version 7? Step 1: Go to Setup> Usage> Reports> SQL requester Parameter definition: If this field is entered, a… Read More: Adding run time selection criteria in SQL requester »

How to use export to Excel functionality in version 7

In Safe X3 Version 7 if you try to use export to excel functionality like exporting the field of the table or screen then you will find that the file will be exported with only link which holds the address that downloads ‘SyracuseOfficeAddinsSetup.EXE’ (Sage X3 for Excel add-in) Since SyracuseOffice Add-in is required to export the… Read More: How to use export to Excel functionality in version 7 »

How to Create Recurring Customer BP Invoices

Recently we came across a scenario where the client wished to recreate customer BP invoices every month or week or daily again and again. When we checked in X3 it provided us with a simple solution to this. Navigate through: A/P-A/R accounting>Invoicing>Recurring customer invoices Add the customer invoice in invoice number filed and select the… Read More: How to Create Recurring Customer BP Invoices »

How to know if the duplicate values present in the given expression…?

Function name: uniis used to verify if there are duplicated values in a series of variable or numeric expressions, alphanumeric expressions or dates. uni returns the rank of the first value equal to a previous value from the list, that is to say: If the first and the second are identical, uni returns 2 If… Read More: How to know if the duplicate values present in the… »