Skip to Content
0
Former Member
Mar 26, 2009 at 10:28 AM

Query - Journal Entries

663 Views

Hi all Experts.

I have the following query:

SELECT T0.[Number], T1.[Account], T1.[ShortName], T1.[Project], T1.[ProfitCode]
FROM OJDT T0  INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId

can someone please guide me on how to include Tax Currency and Tax Code (VatGroup from JDT1 table) into this selection?

Thanks.

Best regards, Runar Wigestrand.