Proportional Freight Distribution Across Multiple GST Rates in Purchase Bill

Hello Everyone,

I have a scenario in a Purchase Bill where I have to handle multiple GST rates and also distribute freight charges proportionally across all items.

Example:

Item 1: ₹100 @ 5% GST
Item 2: ₹200 @ 12% GST
Item 3: ₹150 @ 18% GST

There is also Freight = ₹100, which needs to be distributed in proportion to the item amounts (ratio 100:200:150 = 2:4:3). So, the freight is apportioned to each item before calculating the GST.

After distributing freight proportionately, the tax should be calculated on the revised item amounts (Item value + allocated freight).

Question:
How can I configure ERPNext to handle this scenario automatically (either through charges template or any built-in feature), so that GST is calculated correctly for each slab?

Thanks in advance :pray:

hello everyone, anyone facing the same above issue?
please let me know.