How to get 'Voucher transactions' report from General Ledger exported?

(0) Share

Report

Posted on by 72camaross

283

Hey,

I'm working with a client that wants to run the 'Voucher Transactions' in the General Ledger Module, then in their current process, they copy the results into an excel file and move on.

I would like to export that data using the entities to either BYOD or into an azure data lake or synapse database and then have them connect power bi to it. Then have the process automated.

So first, I am asking how to find which entities I can find the data in? And second, is there a way to see how that report is put together, or the query structure it uses?

All responses (4)

Answers (2)

Amanda McKenzie 5 on at

Like (0)

Report

RE: How to get 'Voucher transactions' report from General Ledger exported?

Alireza,

Thank you for posting this. Total game changer for my users!
Verified answer

Alireza Eshaghzadeh 13,589 Super User 2025 Season 1 on at

Like (1)

Report

RE: How to get 'Voucher transactions' report from General Ledger exported?

Hi J D,

You can use standard entity "General journal account entry". Publish it against your Azure SQL DB and try to export data.

You can also use "General journal account entry reporting" for exporting voucher transactions.
72camaross 283 on at

Like (0)

Report

RE: How to get 'Voucher transactions' report from General Ledger exported?

Thanks saurabh bharti I will give that a shot and report back.
Verified answer

saurabh bharti 15,033 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to get 'Voucher transactions' report from General Ledger exported?

Hi There is one entity which gives you limited information on voucher transactions:

General journal account entry

But if you wish to get exact same information as Voucher transactions then you might need to consider following tables as well

General journal entry

Main account

Financial calendar

Dimension code