ERPNext.com Frappe Cloud Documentation Partners Frappe School Public Chat

How to get tax Break-up Value in SQL

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.

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

You can use JSON_EXTRACT to retrieve that information

https://database.guide/json_extract-return-data-from-a-json-document-in-mysql/

Hello people,

did anyone manage to create a report for this matter?

can you elaborate ? which rate ?