Part Transaction History

Yahoo Archive
1
Well I guess I now know what I'm going to have to do to my report to get it
working the way I want to.



~ Charlie



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Monday, October 27, 2008 12:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Transaction History



Yes, that is what I believe is happening. And I feel your frustration...have
you ever opened the transaction history tracker on a part with that much
history? It can take several minutes to load because of the calculations.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
513-716-6400 (direct)
513-382-3281 (cell)
513-831-1209 (fax)
www.coldjet.com<http://www.coldjet <http://www.coldjet.com> com>
[cid:image001.jpg@ <mailto:image001.jpg%4001C93833.B2FB9710>
01C93833.B2FB9710] align=baseline>
________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Charlie Wilson
Sent: Monday, October 27, 2008 12:54 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Part Transaction History

So it goes all the way back to the start of the history for that part pulls
the quantity at that point and the add / subtracts each transaction to
generate the QTY at each transaction Per Bin then adds together all the
nettable bins for the running total?

That is a lot of work to do, especially if you had 4 or 5 years of history
for a part that has multiple transactions on a daily basis.

~ Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups
<mailto:vantage%40yahoogroups.com> .com<mailto:vantage%40yahoogroups.com>]
On Behalf Of
Michelle de la Vega
Sent: Monday, October 27, 2008 12:44 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Part Transaction History

As far as I know it is a calculation of all on hand quantities by bin,
however, it does not include bins that are non-nettable. For example if Bin
A has 20 items, Bin B has 30 and Bin C (non - nettable) has 10, the running
total will be 50

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
513-716-6400 (direct)
513-382-3281 (cell)
513-831-1209 (fax)
www.coldjet.com<http://www.coldjet <http://www.coldjet
<http://www.coldjet.com> com> com>
[cid:image001.jpg@ <mailto:image001.jpg%4001C93831.BF231470>
01C93831.BF231470]
________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Charlie Wilson
Sent: Monday, October 27, 2008 12:04 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Part Transaction History

All,

I'm attempting to determine where a field in the part tracker transaction
history is coming from. I'm interested in the running total field. I would
like to use this piece of information in a Crystal report I am working on
but can not figure out where vantage is getting this number from. I'm
inclined to think this is a calculated field that it generated when you
retrieve the history but I'm hoping it is actually kept in the DB some
where.

I know that on the PartTran table it has a before and after field but these
don't seem to be used when things such as adjustment to QTY are done. It
only seems to be used when items are take from or added to stock.

Any help?

~Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg <http://www.avg.com> com
Version: 8.0.175 / Virus Database: 270.8.2/1741 - Release Date: 10/26/2008
9:27 AM

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

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



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.2/1741 - Release Date: 10/26/2008
9:27 AM




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



I'm attempting to determine where a field in the part tracker transaction
history is coming from. I'm interested in the running total field. I would
like to use this piece of information in a Crystal report I am working on
but can not figure out where vantage is getting this number from. I'm
inclined to think this is a calculated field that it generated when you
retrieve the history but I'm hoping it is actually kept in the DB some
where.



I know that on the PartTran table it has a before and after field but these
don't seem to be used when things such as adjustment to QTY are done. It
only seems to be used when items are take from or added to stock.



Any help?



~Charlie







[Non-text portions of this message have been removed]
3
As far as I know it is a calculation of all on hand quantities by bin, however, it does not include bins that are non-nettable. For example if Bin A has 20 items, Bin B has 30 and Bin C (non - nettable) has 10, the running total will be 50

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
513-716-6400 (direct)
513-382-3281 (cell)
513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@...231470]
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Monday, October 27, 2008 12:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Transaction History


All,

I'm attempting to determine where a field in the part tracker transaction
history is coming from. I'm interested in the running total field. I would
like to use this piece of information in a Crystal report I am working on
but can not figure out where vantage is getting this number from. I'm
inclined to think this is a calculated field that it generated when you
retrieve the history but I'm hoping it is actually kept in the DB some
where.

I know that on the PartTran table it has a before and after field but these
don't seem to be used when things such as adjustment to QTY are done. It
only seems to be used when items are take from or added to stock.

Any help?

~Charlie

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



[Non-text portions of this message have been removed]
4
I'm just going from memory, but I think the running total field is a
calculation on the part transaction history tracker form and not a field in
the database.



Daniel

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Monday, October 27, 2008 12:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Transaction History



All,

I'm attempting to determine where a field in the part tracker transaction
history is coming from. I'm interested in the running total field. I would
like to use this piece of information in a Crystal report I am working on
but can not figure out where vantage is getting this number from. I'm
inclined to think this is a calculated field that it generated when you
retrieve the history but I'm hoping it is actually kept in the DB some
where.

I know that on the PartTran table it has a before and after field but these
don't seem to be used when things such as adjustment to QTY are done. It
only seems to be used when items are take from or added to stock.

Any help?

~Charlie

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





[Non-text portions of this message have been removed]
5
So it goes all the way back to the start of the history for that part pulls
the quantity at that point and the add / subtracts each transaction to
generate the QTY at each transaction Per Bin then adds together all the
nettable bins for the running total?



That is a lot of work to do, especially if you had 4 or 5 years of history
for a part that has multiple transactions on a daily basis.



~ Charlie



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Monday, October 27, 2008 12:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Transaction History



As far as I know it is a calculation of all on hand quantities by bin,
however, it does not include bins that are non-nettable. For example if Bin
A has 20 items, Bin B has 30 and Bin C (non - nettable) has 10, the running
total will be 50

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
513-716-6400 (direct)
513-382-3281 (cell)
513-831-1209 (fax)
www.coldjet.com<http://www.coldjet <http://www.coldjet.com> com>
[cid:image001.jpg@ <mailto:image001.jpg%4001C93831.BF231470>
01C93831.BF231470]
________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Charlie Wilson
Sent: Monday, October 27, 2008 12:04 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Part Transaction History

All,

I'm attempting to determine where a field in the part tracker transaction
history is coming from. I'm interested in the running total field. I would
like to use this piece of information in a Crystal report I am working on
but can not figure out where vantage is getting this number from. I'm
inclined to think this is a calculated field that it generated when you
retrieve the history but I'm hoping it is actually kept in the DB some
where.

I know that on the PartTran table it has a before and after field but these
don't seem to be used when things such as adjustment to QTY are done. It
only seems to be used when items are take from or added to stock.

Any help?

~Charlie

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

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



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.2/1741 - Release Date: 10/26/2008
9:27 AM




[Non-text portions of this message have been removed]
6
Yes, that is what I believe is happening. And I feel your frustration...have you ever opened the transaction history tracker on a part with that much history? It can take several minutes to load because of the calculations.


Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
513-716-6400 (direct)
513-382-3281 (cell)
513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01C93833.B2FB9710] align=baseline>
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Monday, October 27, 2008 12:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Transaction History


So it goes all the way back to the start of the history for that part pulls
the quantity at that point and the add / subtracts each transaction to
generate the QTY at each transaction Per Bin then adds together all the
nettable bins for the running total?

That is a lot of work to do, especially if you had 4 or 5 years of history
for a part that has multiple transactions on a daily basis.

~ Charlie

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Michelle de la Vega
Sent: Monday, October 27, 2008 12:44 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Part Transaction History

As far as I know it is a calculation of all on hand quantities by bin,
however, it does not include bins that are non-nettable. For example if Bin
A has 20 items, Bin B has 30 and Bin C (non - nettable) has 10, the running
total will be 50

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
513-716-6400 (direct)
513-382-3281 (cell)
513-831-1209 (fax)
www.coldjet.com<http://www.coldjet <http://www.coldjet.com> com>
[cid:image001.jpg@ <mailto:image001.jpg%4001C93831.BF231470>
01C93831.BF231470]
________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Charlie Wilson
Sent: Monday, October 27, 2008 12:04 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Part Transaction History

All,

I'm attempting to determine where a field in the part tracker transaction
history is coming from. I'm interested in the running total field. I would
like to use this piece of information in a Crystal report I am working on
but can not figure out where vantage is getting this number from. I'm
inclined to think this is a calculated field that it generated when you
retrieve the history but I'm hoping it is actually kept in the DB some
where.

I know that on the PartTran table it has a before and after field but these
don't seem to be used when things such as adjustment to QTY are done. It
only seems to be used when items are take from or added to stock.

Any help?

~Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.2/1741 - Release Date: 10/26/2008
9:27 AM

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



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