We're trying to figure out the best way to handle consignment inventory in our system. A lot of the used products we sell are consigned. These consigned machines may either be physically at our location or at the customers locaation. Upon being sold, we take a certain percentage and the customer gets the remainder (our cost on the sale).

We're struggling trying to develop an easy way for our sales reps to see what is available and where it's located (here or a customer's location). We also sell used products that we own so this complicates thing. They need to know where it's consigned or not (currently accomplished w/ a simple checkbox) and whether it's at our warehouse or the customer's location.