Author Archives: Greytrix

How to filter out left list in Sage X3

You may come across the situation where you need to see only filtered transaction according to your criteria. Consider an example where we only need to see those customer BP invoice where currency exchange rate is 2, to do so we can go to advance selection. 1.1 Reference Screenshot In advance selection screen give the… Read More »

How to upgrade Apache Service with binary files

We may came across a scenario where we want to upgrade apache service using binary files. We can achieve this by using below steps: Note: Here we are upgrading apache from 2.2.17 to 2.2.34. Download the zip file for apache 2.2.34. Extract it in the system. Stop the apache service. Copy all the files from extracted… Read More »

How to set condition for purchase order close

Sometimes we come across a scenario where user needs the purchase order to be closed only after certain conditions or never. Sage provides a functionality ‘PO line closing method’ which helps the user in setting them.  Navigate: Parameter –> Parameter values –> Purchase  Click on Rest Management — > PO line closing method Set the… Read More »

How to secure MongoDb in Sage Enterprise Management

We may came across a scenario where we want to secure a mongodb service. We can achieve this functionality by using below steps: Uninstall mongodb service.now re-install MongoDB with SSL certificate checkbox checked. This will generate “client.pem” file to secure MongoDB access. After re-installation of MongoDB, “Client.pem” file will generate in D:\Sage\Syracuse\syracuse\certs\mongodb(In this case I… Read More »

How to create back to back orders in bulk

In some industries the supply is totally depends on the demand for selective products. For these products whenever the sales order is created, the user creates a purchase order to fulfill the sales order. In such scenarios, the product is not stocked in-advance but purchased on demand and sold simultaneously. As soon as the product… Read More »