I am looking to create a jet report that will give me the last date that an item had any type of transaction. I am using Excel 2003. I tried =nl("last","Item Ledger Entry","Posting Date","item No.",C4) but it comes back Invalid What "Last".
Last Date an Item had a transaction