Limiting Locations Packing Slip

[Former Member]

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?

[DellSC · Accepted solution]

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

[Former Member · Accepted solution]

Ok, I added the "group by" and it added "Group 5", but I could not find where to add the option of date descending.  Do I have to write a formula for that in the "In Date"  (3rd Screenshot)?

[abhilash_kumar · Accepted solution]

Go to the 'Record Sort Expert' and insert the Date field.

-Abhilash

[Former Member · Accepted solution]

What if 2 different lot numbers have the same "In_Date" ?  Is there a way to just return 1 value?

[abhilash_kumar · Accepted solution]

When you place fields on the Group Header, it always returns the first row from that group.

So, even if you had two same dates, it would return the first row.

-Abhilash