Skip to Content
0
Former Member
Jun 06, 2013 at 07:24 PM

Query to get all holding taxes on Credit memo

18 Views

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