Inventory Update QOH

[murraymotive]

As a whole, inventory management is very clunky. Ever tried to bulk update QOH? Be prepared for 4000 mouse clicks.

[timbre4]

I split this into it's own post as it's a different angle.

A bulk QOH update event sounds like the infrequent physical inventory? Take a look at Inventory -> Inv. Transactions -> Physical Count:

[murraymotive]

This is the tool we used. When performing inventory checks twice a year, having to update multiple QOHs using this method is extraordinarily cumbersome. No partial search. No multiple inputs. Unable to edit multiple fields at once.

So much so we wrote queries to import/export the inventory tables so we could use something manageable externally.

[Silky7]

Just to chime in; partial searches are indeed possible. Use % to fill as a wildcard.

Updates1.png (29.07 KiB) Viewed 3483 times

count2.png (39.46 KiB) Viewed 3483 times

[murraymotive]

Just to chime in; partial searches are indeed possible. Use % to fill as a wildcard.

You sir, are a magician.