How to get tax Break-up Value in SQL

Kartive_lfc · February 17, 2020, 6:04am

Hi,

I need to pull the invoice tax-break value as shown below in a SQL report.

The table tabPurchase Taxes and Charges has the whole tax amount.

So, can anyone please advise if there are any table for the tax break up or suggest any method to perform the calculation in SQL?

Best regards,
Kartive.

max_morais_dmm · February 20, 2020, 1:46am

@Kartive_lfc in It’s stored on a JSON field on the tabPurchase Invoice Item

You can use JSON_EXTRACT to retrieve that information

wojosc · January 11, 2022, 4:45pm

Hello people,

did anyone manage to create a report for this matter?

Rehan_Ansari · January 11, 2022, 5:08pm

can you elaborate ? which rate ?