InventoryTransferLog.Type

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

Yes thanks alot!

Regards

Julien

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

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.

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 Tiber Creek C> I'm kind of curious, is the inventorytransferlog what is used to determine

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.

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

"MOH. OWN" wrote:

Julien, I would greatly appreciate it you could either post our send me the qry. Thanks, Chris