Create a Journal Voucher Report

Hi ​@sabrinarzk ,

Can you please attach the rpx file for your report?

Hi Laura,
Attached the rpx file.

Hi ​@sabrinarzk ,

Thanks for sharing your report.  The BatchNbr field on the GLDocBatch field does not correspond to the BatchNbr on the transaction itself.  You need to use the GLTranDoc table as an intermediary table to get the correct linkages.  The revised version of the report is attached.  Hope this helps!

Laura

Hi Laura,
I amend the report using your revised version, but the line details still do not appear on the report.

Hi ​@sabrinarzk ,

Do the joins match exactly, or have you tested using the version that I uploaded?  On my demo data, the report did show details.  You could also test in a GI, using only the three tables GLDocBarch, GLTranDoc and GLTran.  Give that a try and let me know how it goes.

Laura