Hi All,
I have created the attached report using Jet Essentials 2015 and NAV 2013R2. The report lists Vendor Transactions by Project. Project is a shortcut Dimension, and therefore is not stored on the GL Entry or Vendor Ledger Entry. I use the Dimension Set Entry table to get the Projects, then link to the GL Entry table to get the GL Transactions associated with that Dimension Set ID (this line is hidden in the report - it's only needed for linking). From there, I link to the Vendor Ledger Entry table (using Transaction No.) to get the vendor transaction detail associated with the Project. The user would like to see grouping/subtotaling by vendor in the transaction detail, and this is the part of the report I'm having trouble with. If it were a simple listing of Vendor Ledger Entries by Vendor, it would be easy to group and subtotal. I think the issue is the link through GL Entry - so Jet has to get the GL Entry, then get the VLE, then get the next GL Entry, then get it's corresponding VLE…so the VLE's are not one "set" of data to group. If anyone has done something similar to this and has some ideas, they'd be much appreciated!
Thanks!
Date
Votes
2 comments
-
Jet Reports Historic Posts My G/L entries have a source no./source name field, and when they have corresponding vendor ledger entries that is filled in with the vendor details…
-
Jet Reports Historic Posts Hi - thanks for the response. I did try grouping on the Source No., but didn't have any luck with that. I attached that version of the report here.
Please sign in to leave a comment.