Quantity Modifiers for Part Transaction Types

Well, I emailed it to you off list...check it out again...



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Monday, November 09, 2009 1:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types




That sounds like something I have seen. But I can't remember where I saw
it or where it might be now.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com> >

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Monday, November 09, 2009 10:58 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types

Thom, Do you have the Hierarchy chart for the trans types? It's an
excel sheet.

It give you everything!

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Thomas Rose
Sent: Monday, November 09, 2009 12:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types

Cool. Thanks!

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> > >

Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Charlie Wilson
Sent: Monday, November 09, 2009 10:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types

You're increasing the QTY of what ever is on the right. So If you were
wanting to do tracking on STK you could set up an if statement and if it
is
on the right add if it is on the left subtract.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of
Thomas Rose
Sent: Monday, November 09, 2009 12:44 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Quantity Modifiers for Part Transaction Types

The PartTran table has a field for TranType. The data dictionary lists
47
possible values for this field. The interesting thing I found is that a
positive entry in the TranQty field of the PartTran table may represent
either a quantity increase or a quantity decrease depending on the
TranType.
For example, a positive value in TranQty where the TranType is PUR-STK
is an
increase in the part quantity. A positive value in TranQty where the
TranType is STK-CUS is a decrease in the part quantity. Is there a list
somewhere that shows, for each TranType, whether a positive value in
TranQty
represents an increase or a decrease in the part quantity?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric
<http://www.electricmirror.com <http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> > >
mirror.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
The PartTran table has a field for TranType. The data dictionary lists 47 possible values for this field. The interesting thing I found is that a positive entry in the TranQty field of the PartTran table may represent either a quantity increase or a quantity decrease depending on the TranType. For example, a positive value in TranQty where the TranType is PUR-STK is an increase in the part quantity. A positive value in TranQty where the TranType is STK-CUS is a decrease in the part quantity. Is there a list somewhere that shows, for each TranType, whether a positive value in TranQty represents an increase or a decrease in the part quantity?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


[Non-text portions of this message have been removed]
You're increasing the QTY of what ever is on the right. So If you were
wanting to do tracking on STK you could set up an if statement and if it is
on the right add if it is on the left subtract.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Rose
Sent: Monday, November 09, 2009 12:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quantity Modifiers for Part Transaction Types





The PartTran table has a field for TranType. The data dictionary lists 47
possible values for this field. The interesting thing I found is that a
positive entry in the TranQty field of the PartTran table may represent
either a quantity increase or a quantity decrease depending on the TranType.
For example, a positive value in TranQty where the TranType is PUR-STK is an
increase in the part quantity. A positive value in TranQty where the
TranType is STK-CUS is a decrease in the part quantity. Is there a list
somewhere that shows, for each TranType, whether a positive value in TranQty
represents an increase or a decrease in the part quantity?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric <http://www.electricmirror.com>
mirror.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Cool. Thanks!

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Monday, November 09, 2009 10:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types



You're increasing the QTY of what ever is on the right. So If you were
wanting to do tracking on STK you could set up an if statement and if it is
on the right add if it is on the left subtract.

~Charlie

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Thomas Rose
Sent: Monday, November 09, 2009 12:44 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Quantity Modifiers for Part Transaction Types

The PartTran table has a field for TranType. The data dictionary lists 47
possible values for this field. The interesting thing I found is that a
positive entry in the TranQty field of the PartTran table may represent
either a quantity increase or a quantity decrease depending on the TranType.
For example, a positive value in TranQty where the TranType is PUR-STK is an
increase in the part quantity. A positive value in TranQty where the
TranType is STK-CUS is a decrease in the part quantity. Is there a list
somewhere that shows, for each TranType, whether a positive value in TranQty
represents an increase or a decrease in the part quantity?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric <http://www.electricmirror.com>
mirror.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
Thom, Do you have the Hierarchy chart for the trans types? It's an
excel sheet.

It give you everything!



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Monday, November 09, 2009 12:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types




Cool. Thanks!

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com> >

Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Charlie Wilson
Sent: Monday, November 09, 2009 10:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types

You're increasing the QTY of what ever is on the right. So If you were
wanting to do tracking on STK you could set up an if statement and if it
is
on the right add if it is on the left subtract.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of
Thomas Rose
Sent: Monday, November 09, 2009 12:44 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Quantity Modifiers for Part Transaction Types

The PartTran table has a field for TranType. The data dictionary lists
47
possible values for this field. The interesting thing I found is that a
positive entry in the TranQty field of the PartTran table may represent
either a quantity increase or a quantity decrease depending on the
TranType.
For example, a positive value in TranQty where the TranType is PUR-STK
is an
increase in the part quantity. A positive value in TranQty where the
TranType is STK-CUS is a decrease in the part quantity. Is there a list
somewhere that shows, for each TranType, whether a positive value in
TranQty
represents an increase or a decrease in the part quantity?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric
<http://www.electricmirror.com <http://www.electricmirror.com> >
mirror.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
That sounds like something I have seen. But I can't remember where I saw it or where it might be now.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Monday, November 09, 2009 10:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types



Thom, Do you have the Hierarchy chart for the trans types? It's an
excel sheet.

It give you everything!



M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Thomas Rose
Sent: Monday, November 09, 2009 12:29 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types

Cool. Thanks!

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com> >

Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Charlie Wilson
Sent: Monday, November 09, 2009 10:27 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Quantity Modifiers for Part Transaction Types

You're increasing the QTY of what ever is on the right. So If you were
wanting to do tracking on STK you could set up an if statement and if it
is
on the right add if it is on the left subtract.

~Charlie

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of
Thomas Rose
Sent: Monday, November 09, 2009 12:44 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Quantity Modifiers for Part Transaction Types

The PartTran table has a field for TranType. The data dictionary lists
47
possible values for this field. The interesting thing I found is that a
positive entry in the TranQty field of the PartTran table may represent
either a quantity increase or a quantity decrease depending on the
TranType.
For example, a positive value in TranQty where the TranType is PUR-STK
is an
increase in the part quantity. A positive value in TranQty where the
TranType is STK-CUS is a decrease in the part quantity. Is there a list
somewhere that shows, for each TranType, whether a positive value in
TranQty
represents an increase or a decrease in the part quantity?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric
<http://www.electricmirror.com <http://www.electricmirror.com> >
mirror.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]