InventoryTransferLog.Type

Discussion in 'Microsoft Point Of Sale' started by Julien Bonnier, Apr 30, 2007.

  1. Hello People!

    Where can I get list that explains the Transfers Type

    These are the values I have in my HQ DB 1,5,8

    But I need the complete list

    Thank You


    Julien
     
    Julien Bonnier, Apr 30, 2007
    #1
    1. Advertisements

  2. Julien Bonnier

    MOH. OWN Guest

    Hi Julien

    On Invenory Transferlog this which type you well find:
    1-for Inventory history (which item you issued /riceved/ po planner).
    3-Sales Item.
    4-transfear Item to Offline inventory.
    5-Manual adjustmint for qty (If happen on store).
    7-physical Inventory.
    8-HQ Adjustmint.

    I hoppe if this help you

    Best Regards
     
    MOH. OWN, May 1, 2007
    #2
    1. Advertisements

  3. Yes thanks alot!

    Regards

    Julien


     
    Julien Bonnier, May 1, 2007
    #3
  4. BTW where do you get this type of informations ?

    Because I like to know almost every fields of every tables
    Is-it documented on the microsoft website?

    Thanks

    Julien
     
    Julien Bonnier, May 1, 2007
    #4
  5. Julien Bonnier

    MOH. OWN Guest

    HI Julien

    I don't have any docmunt. How i find?
    I open inventory transferlog table on sql and start check i select type 5
    and last day i do that after that on HQ manager from Item movemint i check
    what's that? you can do for all taple only check evry table what's the
    report for that or is link to other table. (like that).

    I hoppe if this help you.
     
    MOH. OWN, May 1, 2007
    #5
  6. Julien Bonnier

    Mark Guest

    I'm kind of curious, is the inventorytransferlog what is used to determine
    the inventory quantity for a store? For example does it recalc everytime a
    quantity is changed using the values from this table?
     
    Mark, May 2, 2007
    #6
  7. No, it's a history of inventory movements. Any actions that change
    current inventory - sales, returns, receiving, tranfsers, manual
    adjustments, pbobably some more that I'm missing - all insert records
    into this table. This is the core table of the Inventory Movement
    reports. Given the current quantity on hand, you can use the
    inventoryTransferLog to calculate back to the quantity at a previous date.

    The only thing I know of that is unlogged is a direct update to quantity
    using SQL. There may be other things that are missed, I just don't know
    of any off hand.
     
    Glenn Adams [MVP - Retail Mgmt], May 2, 2007
    #7
  8. Julien Bonnier

    Mark Guest

    Thank you Glenn, that is great insight to the system that I have always
    wanted to know.
     
    Mark, May 2, 2007
    #8
  9. I made a QRY that simulate a snapshot for a selected date using this table.
    I tested like 30 times and it's always good. If anybody need it, I can post
    it.
     
    Julien Bonnier, May 3, 2007
    #9
  10. Julien Bonnier

    Mark Guest

    Moh,

    I'm really curious what table(s) are used to programmatically calculate
    headquarters OH qty for an item when a change is made at the store. As an
    example if I do an adjustment to an item at the store. When Headquarters
    server runs what table(s) are used to recalc the oh quantity for the item?
    Maybe the question should be where in headquarters would i set the record
    that tells Headquarters to recalc oh qty using this adjusted amount?

    Mark
     
    Mark, May 9, 2007
    #10
  11. Julien Bonnier

    Lam Hoang Guest

    Hi,

    I've currently used RMS and need to capture quantity in a selected date for report purpose. Can you send me this qry?

    I'm looking forward to hear from you soon.

    Thanks and regards,
    Lam Hoang


     
    Lam Hoang, May 5, 2011
    #11
  12. Julien Bonnier

    Lam Hoang Guest

    Hi,

    I've currently used RMS and need to capture quantity in a selected date for report purpose. Can you send me this qry?

    I'm looking forward to hear from you soon.

    Thanks and regards,
    Lam Hoang


     
    Lam Hoang, May 5, 2011
    #12
  13. Julien Bonnier

    Lam Hoang Guest

    Hi,

    I've currently used RMS and need to capture Inventory quantity in a specific date range. I'm very appreciated if you can send this QRY for me.

    Looking forward to hearing from you.

    Thanks and regards,
    Lam Hoang

     
    Lam Hoang, May 5, 2011
    #13
  14. Julien Bonnier

    Chris Bailey Guest

    Julien, I would greatly appreciate it you could either post our send me the qry. Thanks, Chris
     
    Chris Bailey, Feb 28, 2014
    #14
    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.
Similar Threads
There are no similar threads yet.
Loading...