How are most stores handling advance sales for items?
We make offerings to the public based on offerings from distributors before we commit to a set # of units - so we can't get and post a standard purchase order. So we end up with these negatives across the boards (figure 4-10 items per offering 1-2 a week with the goods coming in anywhere from 1 month to 2 years)
Does anyone know of a way to handle presale with RMS and keep your numbers from messing with your inv count?
We solved this for a client by writing an small add-in that would transfer any item on the transaction marked with a Discount Code of 'Pre Sale' to a work order during the tendering process.
On the day of the sale the cashiers would pick up the work orders and finalize the transaction.
- Evan Culver New West Technologies
The Comedian wrote:
Work Orders or Layaways seem the best way to handle this, unless you're going to keep a manual system for tracking these orders/presales.
You're not necessarily getting a negative inventory, just a negative amount available because you have 0 in stock and 1 committed. This gets corrected when the item finally arrives in to your inventory, 1 in stock, 1 committed. Then when the customer picks the item up, it all goes back to 0.
Yup. If you look the Inventory tab on the Item Properties, you'll see:
- On Hand (what's in stock)
- Committed (what customers have on order with a Layaway, Back Order or Work Order)
- Available (On Hand less Committed)
- On Order (what's on order with an open Purchase Order)
- Transfer Out (what's going to be transferred out with an open Transfer Out Order).
There's also Offline which is a separate inventory from the On Hand inventory, usually used for keeping track of damaged items or items thare held in the back of the store or at a warehouse.
Hope this helps.
Did anyone ever get a method worked out for this? I am trying to do the same thing and have run up against a "feature" or two in RMS that keeps it from working well.
Rob
"The Comedian" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required