Dear All
any way to get the tax breakup in a new column next to item in sales
Regards
Frz
This would be extremely tricky; because the way the tax data is stored in the data tables currently is based on the unique item codes. So, the implication here is that if you have enabled the setting of allowing multiple same item codes in a single invoice, showing the tax breakup beside the item in the sales invoice would yield the wrong result.
E.g. In your sales invoice, in row 1, you have ITEM_1, with no tax at all. In row 2, you also have ITEM_1, but with tax of 100$. The way ERPNext stores the tax breakup is grouping all the tax amount everything into ITEM_1. So if you try to reference it, ITEM_1 in row 1 will shown tax of 100$, and ITEM_2 in row 2 will also show tax of 100$.
I have been struggling with the way ERPNext stores the line item tax data; because having the feature of allowing the same item code to be entered multiple times into a sales invoice is conflicting with the way tax data is stored; rendering it impossible to know if the tax amount is for which line.