I am trying to pull the most recent date an item was invoiced. My NL is
=NL("First","Sales Invoice Line","Invoice Date","-Invoice Date","*","Customer Price Group",$D$3,"No.",$E5)
I've tried all combos of first last and + - sorting in case I was getting my orders confused, but it always gives me the same date when I run, which is the earliest date that item was invoiced.
Any ideas?
Hi Megan -
I tried to duplicate this with my sample data, but was unable to do so.
Note: Since my Cronus database does not have a Invoice Date field, I substituted Posting Date.
Here are the last few Posting Dates for a particular No. (I generated this with a simple NL(Rows) function and did an inverse sort by Posting Date):
(I did this to see what my actual data looked like).
Then, I created both an NL(First) and an NL(Last) {sorting in the opposite direction of each other}:
(I also left out your additional filter to just make the example simpler)
When I run the report (which, of course, I have to do before my sorting will be performed), I get that last value we see in the first image:
I would have to suggest submitting a support request on this, so that the Jet Tech Team and look into the issue.
