Moving broken inventory out of database

Discussion in 'Microsoft Point Of Sale' started by David H., May 28, 2006.

  1. David H.

    David H. Guest

    What is the best way to move my broken inventory out. I HAVE AN EXCEL
    SPREADSHEET WITH ABOUT 400 ITEMS THAT NEED TO BE REMOVED FROM INVENTORY AND
    QUANTITIES ADJUSTED.

    THANK YOU,
     
    David H., May 28, 2006
    #1
    1. Advertisements

  2. David H.

    GregDxb Guest

    If you HQ ,Use Worksheet style 307: Adjust Item Quatities
     
    GregDxb, May 29, 2006
    #2
    1. Advertisements

  3. David H.

    Rob Guest

    The best way to move your broken inventory out is setup a 'Return to offline
    inventory' Reason Code. Then at the POS when you are returning the item
    select this reason code. This way the items don't show up in your Quantity
    On Hands. At the end of the week or month when ever you return all you
    defective stock you can transfer the items back to your Supplier and have a
    paper trail.

    I know this doesn't help you right now but it should help you control this
    in the future.

    Rob
     
    Rob, May 29, 2006
    #3
  4. David H.

    David H. Guest

    Rob thanx for the input, but for my current need, is there a way to to a
    text file import of the items an quantities I want to send to 'offline
    inventory'
    Thanx
     
    David H., May 29, 2006
    #4
  5. David H.

    Rob Guest

    There is no automatic way in RMS Store Ops to do what you are asking.

    You could try Importing your information into the InventoryOffline table in
    the database. You will need the ItemID and the Quantity for each item in
    order to do this.

    Rob
     
    Rob, May 29, 2006
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.