An ERP system that works in sync with a CRM system can achieve increased efficiencies as well as ROI for both the systems. With Sage 100 ERP – Salesforce.com integration, we have taken your ERP data to the cloud, giving salespeople round-the-clock, 360 degree view of all customer interactions. Attend upcoming webinar to see how… Read More »
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 »
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 »
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 »
You may come across the situation, where you have custom screen in your module. In that screen, if you want to create packages for the shipments. You will able to create packages but SSCC code not able generate for the respective packages. Because, X3 initiates SSCC variable only when you enter into Delivery screen New… Read More »
You may come across the situation where you would like to know the count of index(keys) in the table which may help you. Sage x3 has a special feature of getting keys of the table with the help of “nbind” keyword which will return you the value in number. New Stuff: How to create the Recurring… Read More »
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 »
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 »
Sleep is used to interrupt the execution of a process during a given time. The Sleep instruction is used to create pauses in a process. After a Sleep, the process pauses for a duration equal to the number of seconds given in the parameter, then continues normally. New Stuff: How to get SQL server user… Read More »
We came across a scenario to fetch the SQL server Database , user name and password in sage X3. Here is the step. New Stuff: Update read only field using import utility. Step 1: Create the view as per the screen shot, Step 2: Add the fields in this view as given below, Step 3: Finally… Read More »
