Skip to Content
avatar image
Former Member

Limiting Locations Packing Slip

For our "Pick Ticket", we would like the locations field limited to just 1 (oldest date).  How can I set the locations to return just 1?

Locations.JPG (55.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 29, 2015 at 04:45 PM

    Try this:

    1.  Group by Location - if that's not unique, also group by Lot Number - the point is that you want to get the group(s) configured so that you can do each line item once.

    2.  Then sort by the Date descending.

    3.  Suppress the details section and, if you had to group also by Lot Number, also suppress the Location group header and footer.

    4.  Put your fields in the group header section (either Location or Lot Number, whichever is the inner-most group.)  Because you sorted descending by date, you'll get the most recent.

    - Dell

    Add comment
    10|10000 characters needed characters exceeded