SQL Query to get Transaction Origin

(0) Share

Report

Posted on by JauB

352

Hi Everybody

I'm trying to develop a SQL Query where I can list all Vouchers (which I find in my GL Entries) related to a transaction (Voucher V1) created with an Invoice Journal (AP). For this Journal, the user created one line and made a repartition using periodic Journal (which create other automatic entries in GL, Voucher V2). So When I go under : General Ledger >> Inquiries >>Voucher Transactions and filter on my Voucher V1 click OK and after click on Transaction Orifin so I can see in the list V1 and V2, my need is to develop a SQL Query which can list at the same time V1 and V2 like what AX does in standard. What will be the Tables to use ? Relations ?

Thanks :)

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JauB 352 on at

Like (0)

Report

I got it. The right Table is LedgerJournalVoucherChanged

Thanks for All :)

Was this reply helpful? Yes No