I am curious if anyone has been able to generate any reporting that would allow them to see a Part listing by location and with serial numbers (parent part only).
I would like to run a report by warehouse showing all serial number parts located there. Sounds easy, but in our experience it’s not.
We have one, but our items only have one serial number. I used the SerialNo table to get all the information.
Is it the fact that one item has child serial numbers what makes it difficult?
I am assuming that by “one serial number” that you make every serial number unique. That’s a smart move, would have made this easier. We can re-use a serial number for different parts - they are unique to the part. It also might get re-used for service orders as a part comes back in for repairs.
Yes a long time ago we had that happen by mistake and we took measures to make sure we didn’t do that again. Keeps things a bit cleaner for us and we definitely don’t reuse any.
You should still be able to create a BAQ with a parameter on the warehouse code. Select a warehouse and you should get all the serial numbers having that warehouse assigned regardless of how many other parts it’s associated with.