I'm trying to create a report based on the Requested Receipt Date (RRD) from the Purchase Line table. On a Purchase Order I have the same item but with three separate lines and RRDs and I need the report to show the total quantity for all the lines with the RRD being the earliest date. It won't always be the case that the first line has the earliest date. In my example the first line has a RRD of 10/05/11 and the second line has a RRD of 04/05/11. I've tried using the following formula =NL("First","Purchase Line","Requested Receipt Date","Document No.","G12") but this picks up the first line of the order rather than the first calendar date. Does anyone have any ideas as to how I can resolve this?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi!
Sounds like you just need to sort by the Requested Receipt Date field in your formula like this:=NL("First","Purchase Line","Requested Receipt Date","Document No.",G12,"+Requested Receipt Date","*")
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Yes that seemed to work thanks, although I had to change a few other fields as well to get the information I needed. I must have had a mental block, I haven't written a new Jet report for about 6 months!
Please sign in to leave a comment.