I'm trying to produce a list of the product sold last month sorted from highest to lowest. I've struggled on whether to get this info from the Sales Line or Item Ledger Entry. If I go with the Sales Invoice Line then I must total with the Sales Cr.Memo Line as well. So, I thought pulling from Item Ledger Entries would simplify the equation. Reguardless, my report runs for over an hour with no conclusion. Would someone please give me some pointers?
Jet Reports 7.1
Nav 5.1
Filters are Location Code = SANDIEGO ($B$3)
Date Filter is 11.1.9..11.30.9 ($B$2)
=NL("Rows","Item Ledger Entry","Item No.","+=NL(""Sum"",""Item Ledger Entry"",""Quantity"",""Location Code"",$B$3,""Posting Date"",$B$2,""Entry Type"",""Sale"")","*")
Then I was totalling each row in a different column based on the Item No. returned from the line above.
I'm new to arrays and am eager to learn.
David
Date
Votes
3 comments
-
Jet Reports Historic Posts I think you need to change your formula to:
=NL("Rows","Item Ledger Entry","Item No.","+=NL(""Sum"",""Item Ledger Entry"",""Quantity"",""Location Code"","""&$B$3&""",""Posting Date"","""&$B$2&""",""Entry Type"",""Sale"")","*")note the use of """&cellref&""" in the formula. You need to "get out" of all the quotes to do a cell reference and then "get back in" the quotes to continue the formula. It's a weird format, but it works. -
Jet Reports Historic Posts refer to this…..
-
Jet Reports Historic Posts Thank you! That report shed the light I needed and it turns out to be a fairly quick report!
I look forward to spending the time to UNDERSTAND why it works!
Thanks again!
Please sign in to leave a comment.