Query to get all holding taxes on Credit memo

[Former Member]

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

[KennedyT21 · Accepted solution]

Hi Jose Espinosa...

Welcome to SAP Business One Forum

You have opened multiple thread for the same question which you should not do...

Please Read the

http://scn.sap.com/docs/DOC-19331

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

Please close this thread. Already replied to you  on another thread.

Thanks & Regards,

Nagarajan