How to configure item tax template to be selected automatically based on the type of a transaction (Sales or Purchase)?

Hello All,

I don’t know whether anybody out there has felt the need of following or not.

This case is for an item that is purchased as well sale. (Is purchase = Yes and Is Sale = Yes)

At the Item level, we can define multiple item tax templates based on tax category and effective dates. In our case, we keep separate SGST, CGST, and IGST accounts/ledger for Input (Purchase) and Output (Sales). We also define one set of item tax templates for Purchase and another set for Sales as shown below screenshot.

As per the current system working, it fetches the first matching item tax template based on tax category and applicable dates at the transaction level as shown below.

image

As it is a purchase transaction (purchase invoice), we expect the system to pick a purchase-related item tax template, it has fetched the first matching item tax template. In such cases, we have to manually and carefully select the item tax template at the transaction level as shown below.

image

Expectation

  1. Is anyone out there facing the same situation? If yes, how they are handling it?
  2. Can we have an option to specify the applicability of an item tax template to which transaction type (Sales or Purchase) in addition to tax category and effective dates under the “Tax” child table?

Extra Information

We are creating separate item tax templates for each and every tax slab under GST for Sales (Output Tax) and for Purchase (Input Tax). Also, we have separate ledgers/accounts in our COA, i.e. Input CGST, Input SGST and Input IGST for purchases, and the same way Output CGST, Output SGST and Output IGST for sales.

Somebody can also suggest how they handle this scenario and which is accepted by their accountant/CA/Auditor.

Hello,

I presume you want to automate Item Tax Template Selection for purchases and Sales.

Check for the following configurations concerning Tax Categories, and it should automatically select taxes.

  • Have you set Tax Categories for your customer and suppliers?
  • Have you set Tax Categories for the Sales Taxes and Charges Template & Purchase Taxes and Charges Template?

Once you do this, you will see item tax selections coming automatically.