We designed a new Jet Report with the following Tabel and Filters.
Item Ledger Entry
Filter: Posting Date 01.06.2011..30.06.2011
Global Dimension 1 Code K7590|K6890
Location Code 02SHOP_STJ|05SHOP_SBG
After Refresh we got many Entry but if we controll them in den NAV - Classic Table with the same Filter we missing some Entry's why?
What is there wrong.
We have tryed to brake down to more Filter Exampel Document No. then we found that one Entry is missing - it was always the last one?
Date
Votes
1 comment
-
Jet Reports Historic Posts Try adding Entry no. to your report as well.
The Table Builder returns all unique records based on your query.
So if you queried just "Location Code" from your Item Ledger Entrry table, you would receive a list of all unique Location codes that exist in this table.
If you queried both "Location Code" and "Posting Date" you would receive a list of all unique combinations of Location Codes and Posting dates that exist in the table.
To get every entry number you will want to add the table key (entry no.) to your query.
Does this help?
Steve
Please sign in to leave a comment.