In NAV2013 and later dimension values are stored in the Dimension Set Entry while the usual source table such as for example Cust. Ledger Entry table contains only Dimension Set ID. If for example Cust. Ledger Entry table contains Dimension Set ID = 21, this may involve several records in the Dimension Set Entry Table, for example
SM 100
SN ADM
PROJECT Mercedes
Using Jet Reports Express I would like to export to Excel the above records as part of the customer ledger entry table export, for example:
Entry No. Customer No. Posting Date Document type Document No. Amount Value_of_DC1 Value_of_DC2 Value_od_DC3
1121 C10000 04/04/2014 Invoice INV14-0010 100.00 100 ADM Mercedes
Can this be done using Jet Reports Express? Could you please explain how?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello,
Jet does all the hard work of connecting the tables with the dimensions.
You should find the dimensions in the field list for the table, and choose them like any other field.
Regards, -
Jet Reports Historic Posts Thank you very much for that topic. It is very informative and useful for me. BTW. Hello to everyone I am new here and it is my first post.
Please sign in to leave a comment.