Thanks for the information. Can I confirm what version of Adagio Inventory you have installed? The Physical Inventory function was improved in the 80B version.

Picking sequences can come directly from the Item Master file, or be set for a specific location. Setting for a specific location is done from the Edit menu, Item Maintenance and Picking Sequence. If you go here for any of the items in question, what do you see here for the problem location? If you see Default, this means the Item Master has the picking sequence value. If you see something else, this is the location-specific picking sequence. You can also see the picking sequences for all locations if you use Item Inquiry with Sales/Costs and the Quantities tab.

I haven't been able to duplicate a difference in the selected items between the report, the exported Excel spreadsheet or the Edit Physical Inventory function. I am using the current shipping version 8.1A and release date (090217). Items are selected for all based on the location-specific picking sequence.

Could you give an example of one of your items that uses a pick sequence of 52 and is not selected for your report? What we would need to know is what the Master Item pick sequence is, the pick sequence defined on the location, and also what locations the item is allowed at (this will be on the same Pick Sequence screen - any visible locations are allowed). Do you see 461 anywhere? You may need to get your Adagio consultant involved to look at the data and see if anything is unexpected or amiss.