Hi, I’m just trying to create a simple query on both the Sales Invoice and Sales Taxes and Charges tables. here is my SQL:
SELECT si.name, si.posting_date, si.title, si.shipping_address, si.base_total, sc.description, sc.tax_amount, si.grand_total
FROM tabSales Invoice
si INNER JOIN tabSales Taxes and Charges
sc ON tabSales Invoice
.name = tabSales Taxes and Charges
.parent;
But when I run it, I don’t get any results. I thought i was doing something wrong, so I quickly just pulled both tables into MS Access and ran the same SQL and I got my results. Can someone assist?
For the custom query report, i put the DocType as Sales Invoice. Not sure that matters.
Thanks.
JR