Look up a location in reverse
Read every code row your file lists at an exact rack.
For operators
Read these instructions on any device. Watch or practise a chapter on a desktop or laptop, with a desktop or mobile application layout. Demonstrations use sample data and simulated scanners.
Look up a location in reverse
- Start a lookup
Start a lookup.
FindBench reads the local reference you choose. It does not fetch stock data or confirm where goods are now. All values in this lesson are synthetic.
- Choose the prepared reference CSV
Choose the prepared reference CSV.
This prepared CSV enters the real file chooser. Review the rows and choose the columns before loading. Nothing has been uploaded.
- Map the exact code column
Map the exact code column.
Choose Part as the code column. Every value stays exact text, including leading zeroes.
- Map the description column
Map the description column.
Choose Text for the descriptions. Different descriptions for one code remain visible.
- Map every listed location
Map every listed location.
Choose Bin for locations. Repeated rows are retained, and a blank location stays explicitly not supplied.
- Keep the relevant note column
Keep the relevant note column.
Choose Comment for notes. The Ignore column is left out and will not be saved with the reference.
- Name the reference
Name the reference.
A clear title appears with the lookup, downloads and saved work. It is your declared context, not a verified authority.
- Declare when the reference was prepared
Declare when the reference was prepared.
This date comes from the file owner. Loading it today does not prove it is current.
- Load the reviewed reference
Load the reviewed reference.
Load all six mapped rows. The original file and excluded column are discarded; the exact mapped values and row numbers remain.
- Change to a location lookup
Change to a location lookup.
Reverse lookup finds all codes listed against an exact location. Changing direction clears any previous answer.
- Read all codes listed at this rack
Read all codes listed at this rack.
RACK-B has two rows with conflicting descriptions. A listed rack is source-file information, not proof that the part is there now.