Hi
I'm new to Jet Reports, but I am trying to get a column that shows the first date that an item has been sold/consumed/negative adjustment. I am using NL("First","Item Ledger Entry","Posting Date","Entry Type","Sale|Consumption|Negative Adjmt. but the report is showing the first entry (a negative adjustment dated 2012) rather than the earliest entry (consumption in 2008). Is it possible, can the Item entry table be re-sorted in date order, am I being too demanding?
Many thanks
Richard
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Richard,
NL(First) does not automatically sort so you have to add the sort yourself in the formula like this:=NL("First","Item Ledger Entry","Posting Date","Entry Type","Sale|Consumption|Negative Adjmt.","+Posting Date","*")
You also have to run the report by using Jet -> Report before the sort will be applied. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes
Many thanks for your reply. Strangely if I sorted on Posting Date the report wouldn't run, Excel called it a day after about 600 items, but I just sorted on Entry No. instead and it works perfectly, thank you so much.
Regards
Richard
Please sign in to leave a comment.