Building a GI where I need to get the most recent “Effective Date” for all inventory items that are a “STAFF” price code. The ways I’ve seen to get the most recent record in GI’s won’t work here because the effective date only lives on the ARPriceWorksheet table and not on the ARPriceWorksheetDetails table where the inventory item, price code, and pending price are.
Thanks for the help!
Best answer by nickcerri32
Then you can group by the Price Code and Inventory (I used nventoryCD, but you could just as easily use the ID field.) This should return the most recent effective date.
+6
Then you can group by the Price Code and Inventory (I used nventoryCD, but you could just as easily use the ID field.) This should return the most recent effective date.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
