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/
wojosc
3
Hello people,
did anyone manage to create a report for this matter?
can you elaborate ? which rate ?