Inventory by Manufacturer (LineCode)

[Joe Slomka]

We have a large inventory of parts and over 11K part numbers that we track in our management program. Our parts are sorted in our stock room by manufacturer not by category. We keep all the Wagner parts together, all the Moog parts together, all the Parts Master parts together, etc. When we print our reports to do an inventory count update or evaluate what parts we need to stock, we do this by Manufacturer. All of the reports (except one - parts list), might show part number, quantity on hand, stocking quantity, cost, etc. but do not have the manufacturer (line code) which makes it impossible to sort out and work with one individual manufacturer (line). I would suggest that the reports be modified that any time the report shows part number that it also show line code. Without the line code it is near impossible to tell the difference between two parts that have the same part number and description, i.e. Parts Master and Moog both make tie rods and both use the same numbering system. In Manager 5.9 I used to get around this by querying the database and importing to excel. I am not aware of any way to do this in Manager 7.0. If there is, I would be very grateful if someone could give me some insight. I would be even more grateful if the reports were fixed to have that info. Anybody else sort their parts by manufacturer?

[Silky7]

Joe,

Have you tried searching the Inventory list by Manufacturer then printing that?

[Joe Slomka]

I have searched Inventory list by Manufacturer and that gives me the list of parts with the line codes, but that does not help with sales history information, stocking quantity, or reorder counts.