TDS on Purchase of Goods: Section 194Q

By | July 30, 2021

In this blog, we will see the functionality of how TDS will be applied on Purchase Invoices in Sage X3 for Section 194Q of the Income Tax Act.

As per the requirement, the TDS rate of 0.1% is applicable to be deducted if the value or aggregate purchase value exceeds Rs. 50 Lakhs. This will also be only effective on current ongoing fiscal year of TDS module.

For this purpose, there will be a checkbox “Threshold” in TDS section as shown in the below screenshot. If it is checked then only TDS on Purchase of Goods functionality will work.

New Stuff: How to call action based screen through code in Sage X3

[TDS Section - Threshold]
[TDS Section – Threshold]

Now, we will define a new NOD code as ‘NOD194Q’ which will have 0.1% as TDS rate and cumulative cut-off value of INR 50 Lakhs and TDS section 194Q. In the same screen, we will enter the amount for Threshold for calculation purpose.


This NOD will be mapped to required Party Vendors.

[Party Details - SD0018]
[Party Details – SD0018]

TDS will be deducted on different amounts unlike the default functionality which deducts TDS on Total cumulative amount.

Let’s check with an example:

Threshold Cut-off is 50,000,00. We will create new invoice entry with the same party vendor and invoice value of 30 Lakhs.

TDS Effect: No TDS will be deducted because Invoice value is 30 Lakhs which is less than threshold cut-off. Refer below screenshot.

[1012107PINV00023 - 30 Lakhs]
[1012107PINV00023 – 30 Lakhs]

We will again create an invoice with invoice value of 21 Lakhs for the same party vendor.

TDS effect: TDS 0.1% will be deducted on 1 lakh. TDS Entry will be created i.e. 0.1% on 1 lakh.

[1012107PINV00024 - 21 Lakhs]
[1012107PINV00024 – 21 Lakhs]

If you have observed in the below screenshot, in the section highlighted in red, values are getting displayed as per the default TDS functionality which deducts TDS on Total amount i.e. 0.1% on 21 Lakhs. But, in the section which is highlighted in yellow, values are getting displayed as per the Threshold functionality which deducts TDS with 194Q Section.

[1012107PINV00024 - TDS Base Amount]
[1012107PINV00024 – TDS Base Amount]

This calculation of TDS deduction will be completely based only on Vendor code, NOD code and fiscal year combination.

If other than the mentioned NOD code is used then it will work as per the default functionality i.e. if above example is to be considered then TDS will be applicable on Total Invoice values 30 Lakhs and 21 Lakhs respectively.

In this way, TDS will be deducted for Invoices in TDS on Purchase of Goods (Threshold) functionality

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at, We would like to hear from you.