Hi there,
I am trying to filter a report using Shortcut Dimension 5. This field is available in the Purchase Line table for the first part of the report which is fine, but I also need to get information from the Purchase Line Archive Table.
When I try to use this table, I get this error on the Jet Report debug about not having Advanced Dimensions available on the Purchase Line Archive table.
I have then tried to see if I can get the same information from the Purch. Rcpt. Line Table, but there are no shortcut dimensions here after dimension 2.
Any ideas?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Meemz,
Navision stores all dimension values in a secondary table. Only the 2 global dimensions are stored in the primary tables - for the flowfilters. An example: for the Purchase line the dimensions are stored in the Document dimension table. You may see this by opening the Purchase order form in Navision, select a line and click on Line, Dimensions. The form being displayed then is based on the secondary table. Press Ctrl+F8 (Zoom) to see the name of the table and the record contents.
For the archived documents Navision has a different secondary table to store the dimensions: Document dimension archive. I knew Jet Reports was not able to use these archive tables, but thought it woudl be solved by now. The release I use is 7.1.2, build 1820. Well, let's wait and hope it's done in the next release.
Please sign in to leave a comment.