InventoryTransferLog.Type

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

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
THE BODY SHOP
K.S.A
MOB:+966 557266607




"Julien Bonnier" <> wrote in message
news:...
> 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
>

Yes thanks alot!

Regards

Julien


"MOH. OWN" <> wrote in message
news:...
> 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
> THE BODY SHOP
> K.S.A
> MOB:+966 557266607
>
>
>
>
> "Julien Bonnier" <> wrote in message
> news:...
>> 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
>>
>
>

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

"MOH. OWN" <> wrote in message
news:...
> 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
> THE BODY SHOP
> K.S.A
> MOB:+966 557266607
>
>
>
>
> "Julien Bonnier" <> wrote in message
> news:...
>> 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
>>
>
>

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
THE BODY SHOP
K.S.A
MOB:+966 557266607

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?

"MOH. OWN" wrote:

> 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
> THE BODY SHOP
> K.S.A
> MOB:+966 557266607
>
>
>

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 Consulting
http://www.tibercreek.com

----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.


Mark wrote:
> 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?
>
> "MOH. OWN" wrote:
>
>> 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
>> THE BODY SHOP
>> K.S.A
>> MOB:+966 557266607
>>
>>
>>

Thank you Glenn, that is great insight to the system that I have always
wanted to know.

"Glenn Adams [MVP - Retail Mgmt]" wrote:

> 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 Consulting
> http://www.tibercreek.com
>
> ----------------------------------------------
> Please DO NOT respond to me directly but post all responses here in the
> newsgroup so that all can share the information.
>
>
> Mark wrote:
> > 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?
> >
> > "MOH. OWN" wrote:
> >
> >> 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
> >> THE BODY SHOP
> >> K.S.A
> >> MOB:+966 557266607
> >>
> >>
> >>
>

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.


"Mark" <> wrote in message
news:F57D9084-33D7-4C7C-B728-...
> 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?
>
> "MOH. OWN" wrote:
>
>> 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
>> THE BODY SHOP
>> K.S.A
>> MOB:+966 557266607
>>
>>
>>

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:

> 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
> THE BODY SHOP
> K.S.A
> MOB:+966 557266607
>
>
>
>
> "Julien Bonnier" <> wrote in message
> news:...
> > 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
> >
>
>
>