Author Archives: Greytrix

Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice Transactions

As we all know, while creating any transaction in Sage X3, we can enter quantity and price manually in detail line as per the requirement. But one of our client wanted to restrict the creation of the Sales/Purchase Invoice Transactions if the user is trying to enter ‘0’ in Gross/Net Price and Quantity fields. Even… Read More: Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice… »

Sales Group and Ship-to-State Group code in Sales Commission Module

As we have said in our previous blogs that Greytrix has developed a Sales commission add on. This sales commission add on will helps in overcoming challenges such as accuracy in sales commission calculation, timely payment to sales representatives, track of commissions of sales representatives, etc. This Sales Commission Module provides a feature of Sales… Read More: Sales Group and Ship-to-State Group code in Sales Commission Module »

How to set up commission rate in Sales Commission Module.

In Sage X3, commission module provides enhancement of existing commission feature of Sage X3. It helps in overcoming challenges such as accuracy in sales commission calculation, timely payment to sales representatives, track of commissions of sales representatives, etc. In this blog we will learn how to setup commission rate for different combinations such as customer… Read More: How to set up commission rate in Sales Commission Module. »

How to update the pay approval on a posted purchase invoice in Sage X3

There may be situation that a user needs to change the due date or pay approval on a posted sales invoice or purchase invoices . Sage x3 provides a functionality called the Open item edit function to make the changes to the due date , pay approval as well as other characteristics for open items.… Read More: How to update the pay approval on a posted purchase… »

Setting of a Sales Discount at the Line Level of a Sales Invoice

A sales discount is a reduction in the price of a product or service that is offered by the seller, in exchange for early payment by the buyer. An example of a sales discount is for the buyer to take a 1% discount in exchange for paying within 10 days of the invoice date, rather… Read More: Setting of a Sales Discount at the Line Level of… »

Additional feature in Sage X3 2021 R3 (Release 3): Recurring Date field in RAPPRO Report

The new version of Sage X3 is been released now i.e.  Sage X3 2021 R3 patch 27 and with this sage has released the new enhancement in the sage X3 application which will make user friendly handling. New Stuff:  Email Commission statement feature of Sales commission add on In this blog we will see new… Read More: Additional feature in Sage X3 2021 R3 (Release 3): Recurring… »

How to process data in Put-away plan in Sage X3

Put-away Plan or  Storage Plan is a functionality to plan stock change from dock location category to another location or internal location. Sage X3 offers flexibility to manage default location for a product within site for different operations. For instance, if a product exists in multiple locations of the site and for each operations (receipts,… Read More: How to process data in Put-away plan in Sage X3 »

How to check list of products purchased from same supplier

Sage X3 provides us functionality where we can check the number of products that are purchased from a single supplier and also can group and view them. The Grouping workbench that is found in Purchasing, Supply provides visibility of products purchased from specific suppliers and same site. Using this function and selecting the ACH Buyer transaction as an option,… Read More: How to check list of products purchased from same supplier »

How to apply payments to Supplier BP invoices

In Sage X3, outgoing payments need to be applied against the relevant invoices to properly reflect the amounts payable to vendors or suppliers in general and on specific invoices. With the application of payments to supplier BP invoices it is important to note the three main areas of the process below: Enter payments – original… Read More: How to apply payments to Supplier BP invoices »

How to write encode function on node.js by passing input argument from X3

Node.js files contain tasks that will be executed on certain events. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices. Node.js applications are written in JavaScript, and can be run within the Node.js runtime.Node.js files have extension “._js” STEP1: Creating Node.js… Read More: How to write encode function on node.js by passing input… »