I am creating a Jet Report: Sales by Province/State. However, the Province/State field on both the Customer and Ship-to cards are text. This has lead to users entering variations for the province of Ontario like ON and On.
Therefore, when the following NL is executed the same results are returned for province ON and On:
=NL("Sum","21 Cust. Ledger Entry","Sales (LCY)","Document Type","Invoice","Posting Date",$C$7,"LINK=","112 Sales Invoice Header","3 No.", "=6 Document No.","92 Ship-to County","@@"&$F15)
Bear in mind the Province/State field is optional so can have a value of blank in the Sales Invoice Header table. In column F15 there is one row with a value of On and another row with a value of ON and both yield the same value which is impossible. How can the NL function syntax be changed to indicate EXACT match on case?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
This actually has nothing to do with Jet and everything to do with Nav itself. The Ship-to Country of the Sales Invoice Header table is a Code field in Nav. Any text you enter for a code field always is changed to upper case in Nav and thus filtering by them is always case insensitive. This works the same in both Jet and Nav and I don't believe there is any way to make this filter case sensitive. It actually doesn't make any sense to do a case sensitive filter since the values are all always upper case. Actual text fields in Nav (rather than code fields) are case sensitive, but the Ship-to Country field is not a text field. Does this help?
Regards,
Hughes
Please sign in to leave a comment.