Karen:

Normally the banks don't want to finance slow moving inventory items so they want the last date sold, not the last date some adjustment was made to the item.

Are you saying that most sales are recorded as an adjustment? that seems odd, particularly if you are using an Adagio module to post sales. Which Adagio module are you using to post sales?

Most likely the Adagio Consultant who created the GridView for you would be your best choice to get this fixed. Sounds like some effort will be required to understand how to identify the last sale and set that date onto your report.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com