Accountant Forums


Reply
Thread Tools

InventoryTransferLog.Type

 
 
Julien Bonnier
Guest
Posts: n/a
Thanked:
 
      04-30-2007, 07:51 PM
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


 
Reply With Quote
 
 
 
 
MOH. OWN
Guest
Posts: n/a
Thanked:
 
      05-01-2007, 07:13 AM
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
 
 
 
 
Julien Bonnier
Guest
Posts: n/a
Thanked:
 
      05-01-2007, 03:34 PM
Yes thanks alot!

Regards

Julien


"MOH. OWN" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>

>
>



 
Reply With Quote
 
Julien Bonnier
Guest
Posts: n/a
Thanked:
 
      05-01-2007, 03:49 PM
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>

>
>



 
Reply With Quote
 
MOH. OWN
Guest
Posts: n/a
Thanked:
 
      05-01-2007, 04:48 PM
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


 
Reply With Quote
 
Mark
Guest
Posts: n/a
Thanked:
 
      05-02-2007, 07:58 PM
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
>
>
>

 
Reply With Quote
 
Glenn Adams [MVP - Retail Mgmt]
Guest
Posts: n/a
Thanked:
 
      05-02-2007, 08:26 PM
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
(E-Mail Removed)
----------------------------------------------
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
>>
>>
>>

 
Reply With Quote
 
Mark
Guest
Posts: n/a
Thanked:
 
      05-02-2007, 08:33 PM
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
> (E-Mail Removed)
> ----------------------------------------------
> 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
> >>
> >>
> >>

>

 
Reply With Quote
 
Julien Bonnier
Guest
Posts: n/a
Thanked:
 
      05-03-2007, 04:58 PM
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>>
>>
>>



 
Reply With Quote
 
Mark
Guest
Posts: n/a
Thanked:
 
      05-09-2007, 07:33 PM
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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off



All times are GMT. The time now is 04:28 PM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.