I need to pull the invoice tax-break value as shown below in a SQL report.
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?
@Kartive_lfc in It’s stored on a JSON field on the
tabPurchase Invoice Item
You can use JSON_EXTRACT to retrieve that information
did anyone manage to create a report for this matter?
can you elaborate ? which rate ?