GST on P&F/Freight/Insurance charges with e-Invoice and e-Waybill integration

ERPNext
,
1

Hi everyone,

I have a requirement where I need to charge GST (CGST+SGST for intrastate and IGST for interstate) on Packing & Forwarding, Freight and Insurance charges in addition to the item value.

My Setup:

  • ERPNext v15

  • GST India app installed

  • e-Invoice enabled

  • e-Waybill enabled

What I want:

  • Taxable Value = Item Net Total + Packing Charges + Freight Charges + Insurance Charges

  • CGST and SGST both calculated on this combined taxable value

  • All amounts should post correctly to accounting

  • Should work correctly with e-Invoice and e-Waybill generation

What I have tried:

  1. Adding P&F/Freight/Insurance as Actual rows and CGST/SGST as On Previous Row Total — ERPNext only allows one GST row to reference the same previous row

  2. SGST as On Previous Row Amount referencing CGST row — ERPNext blocks this for GST accounts

  3. Both CGST and SGST as On Net Total — does not include P&F/Freight/Insurance in the base

  4. Server script to calculate before save — risk of being overridden during e-Invoice/e-Waybill generation

Question: What is the correct way to handle this scenario in ERPNext with GST India app while keeping e-Invoice and e-Waybill working correctly?

Any help is greatly appreciated. Thank you.

2

Got it solved,

Packing Charges — Actual

  1. Freight Charges — Actual

  2. Insurance Charges — Actual

  3. CGST 9% — On Previous Row Total → Reference Row = 3

  4. SGST 9% — On Previous Row Total → Reference Row = 3

Both CGST and SGST now calculate on the total of items + P&F + Freight + Insurance correctly, accounting posts correctly, and e-Invoice/e-Waybill should work fine too.

1 Like