InventoryTransferLog.Type


J

Julien Bonnier

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
 
M

MOH. OWN

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
 
Ad

Advertisements

J

Julien Bonnier

Yes thanks alot!

Regards

Julien


MOH. OWN said:
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
 
J

Julien Bonnier

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
 
M

MOH. OWN

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.
 
M

Mark

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?
 
G

Glenn Adams [MVP - Retail Mgmt]

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.
 
M

Mark

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

Advertisements

J

Julien Bonnier

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.
 
M

Mark

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
 
L

Lam Hoang

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


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
On Tuesday, May 01, 2007 3:13 AM 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




news:OJUrQE2iHHA.1216@TK2MSFTNGP03.phx.gbl...
On Wednesday, May 02, 2007 4:26 PM 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.




Mark wrote:
On Wednesday, May 02, 2007 4:33 PM Mar wrote:
Thank you Glenn, that is great insight to the system that I have always
wanted to know.

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

Lam Hoang

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


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
On Tuesday, May 01, 2007 3:13 AM 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




news:OJUrQE2iHHA.1216@TK2MSFTNGP03.phx.gbl...
On Wednesday, May 02, 2007 4:26 PM 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.




Mark wrote:
On Wednesday, May 02, 2007 4:33 PM Mar wrote:
Thank you Glenn, that is great insight to the system that I have always
wanted to know.

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

Lam Hoang

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

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
On Tuesday, May 01, 2007 3:13 AM 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




news:OJUrQE2iHHA.1216@TK2MSFTNGP03.phx.gbl...
On Wednesday, May 02, 2007 4:26 PM 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.




Mark wrote:
On Wednesday, May 02, 2007 4:33 PM Mar wrote:
Thank you Glenn, that is great insight to the system that I have always
wanted to know.

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

Advertisements

C

Chris Bailey

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

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top