Want to clear out your oldest inventory or see if something isn't selling?
Using the following steps you can see how long you've had each package and/or the date you received it:
Generate, download and open a Current Inventory report.
Click the "Packages" tab on the bottom of the report.
Select any part of the tab.
Click PivotTable Analyze
Click Field List.
Search for "Reception" to see the reception days or date fields.
Check the box next to "Reception Days" to show the number of days you've had each package. Click. "Reception Date" to show the date the package was received.
"Count of Reception Days/Date" will now show in "Values." You can right click it and select "Field Settings;" change the field from "Count" to "Max" and click Ok. The package days/date will not be displayed in a column for each package.
If you want to sort to show the oldest/newest packages, you can click the "Row Labels" area and click Sort By, then Reception Days/Date, then Ascending/Descending.
