Hi in my country there are several holing taxes on invoices and credit memos, this is my query, but it gets nothing because ORIN (Credit memo) does not have a direct relationship with INV5 (Holding taxes, any help will be apreciated, thanks
select T0.DocNum, t0.DocDate,t0.CardName,t2.Wtcode FROM ORIN T0
INNER JOIN RIN1 T1
ON T0.DocEntry = T1.DocEntry
INNER JOIN INV5 T2
ON T2.AbsEntry = T0.DocEntry