Stock History

Yahoo Archive
1
Hi Mike



The historical value on the stock status report (V8), from what I have
found has a bug.



If you make an adjustment to cost with a backdated transaction date
(tested with average), the average can go even lower than any average in
its transaction history.



I have looked into it and I think it's due to the average calculation in
the system working off the system date, but the report must work off the
transaction date.



I think that explains it



Gary Parfrey

Steatite Limited



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: 26 June 2006 18:52
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Stock History



One thing to be aware of on the Stock Status report is that when you run
this report in the past to get a historical on-hand quantity and value,
the cost is the cost for the part at the time that the report is run,
not what it was on the historical date.

Hope this helps,

Mike Lowe

Connor Manufacturing Services

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of brychanwilliams
Sent: Monday, June 26, 2006 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Stock History

Hi Gary,

I can get the qtys right ok, but in terms of value I can't get it to
work on some parts. One part in particular is lot costed , always
has been, but there are some very strange ADJ-CST transactions which
I can't tie up. The stock status report is correct but mine is
failing.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Gary Parfrey" <garyp@...> wrote:
>
> Hi Brychan
>
>
>
> I would start with the current stock position (ie Part, Part Class
and
> PartWhse table) then subtract or add inventory transaction
(parttran)
> from it/to it based on the transaction date.
>
>
>
> One of the issues might be the last cost that is in the part master
> (6.1) partcost table (8.0) may have been a different cost in the
> previous month.
>
>
>
> Gary
>
>
>
> ________________________________
>
> 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 brychanwilliams
> Sent: 26 June 2006 17:19
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Stock History
>
>
>
> Hi,
>
> I am trying to create a report that provides the current stock
total
> and previous month totals split by part class. My starting point
has
> been the Parttran table. Is it possible to do this via that
Parttran?
> My initial attempts don't seem very encouraging. I can get the
> quantities to match up against the stock status but I can't seem
to
> obtain the correct valuation. We are using a mixture of Lot and
Last
> costed parts.
>
> Thanks in advance.
>
>
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If
you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended
recipient, you must not use, disclose or distribute this e-mail
without the author's prior permission. We have taken precautions to
minimize the risk of transmitting software viruses, but we advise
you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by
software viruses.
>
>
>
> [Non-text portions of this message have been removed]
>

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





This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.



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

I am trying to create a report that provides the current stock total
and previous month totals split by part class. My starting point has
been the Parttran table. Is it possible to do this via that Parttran?
My initial attempts don't seem very encouraging. I can get the
quantities to match up against the stock status but I can't seem to
obtain the correct valuation. We are using a mixture of Lot and Last
costed parts.

Thanks in advance.
3
Hi,

I am trying to create a report that provides the current stock total
and previous month totals split by part class. My starting point has
been the Parttran table. Is it possible to do this via that Parttran?
My initial attempts don't seem very encouraging. I can get the
quantities to match up against the stock status but I can't seem to
obtain the correct valuation. We are using a mixture of Lot and Last
costed parts.

Thanks in advance.
4
Hi Brychan



I would start with the current stock position (ie Part, Part Class and
PartWhse table) then subtract or add inventory transaction (parttran)
from it/to it based on the transaction date.



One of the issues might be the last cost that is in the part master
(6.1) partcost table (8.0) may have been a different cost in the
previous month.



Gary



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: 26 June 2006 17:19
To: vantage@yahoogroups.com
Subject: [Vantage] Stock History



Hi,

I am trying to create a report that provides the current stock total
and previous month totals split by part class. My starting point has
been the Parttran table. Is it possible to do this via that Parttran?
My initial attempts don't seem very encouraging. I can get the
quantities to match up against the stock status but I can't seem to
obtain the correct valuation. We are using a mixture of Lot and Last
costed parts.

Thanks in advance.





This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.



[Non-text portions of this message have been removed]
5
Hi Gary,

I can get the qtys right ok, but in terms of value I can't get it to
work on some parts. One part in particular is lot costed , always
has been, but there are some very strange ADJ-CST transactions which
I can't tie up. The stock status report is correct but mine is
failing.

--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Hi Brychan
>
>
>
> I would start with the current stock position (ie Part, Part Class
and
> PartWhse table) then subtract or add inventory transaction
(parttran)
> from it/to it based on the transaction date.
>
>
>
> One of the issues might be the last cost that is in the part master
> (6.1) partcost table (8.0) may have been a different cost in the
> previous month.
>
>
>
> Gary
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of brychanwilliams
> Sent: 26 June 2006 17:19
> To: vantage@yahoogroups.com
> Subject: [Vantage] Stock History
>
>
>
> Hi,
>
> I am trying to create a report that provides the current stock
total
> and previous month totals split by part class. My starting point
has
> been the Parttran table. Is it possible to do this via that
Parttran?
> My initial attempts don't seem very encouraging. I can get the
> quantities to match up against the stock status but I can't seem
to
> obtain the correct valuation. We are using a mixture of Lot and
Last
> costed parts.
>
> Thanks in advance.
>
>
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If
you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended
recipient, you must not use, disclose or distribute this e-mail
without the author's prior permission. We have taken precautions to
minimize the risk of transmitting software viruses, but we advise
you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by
software viruses.
>
>
>
> [Non-text portions of this message have been removed]
>
6
One thing to be aware of on the Stock Status report is that when you run
this report in the past to get a historical on-hand quantity and value,
the cost is the cost for the part at the time that the report is run,
not what it was on the historical date.



Hope this helps,



Mike Lowe

Connor Manufacturing Services







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Monday, June 26, 2006 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Stock History



Hi Gary,

I can get the qtys right ok, but in terms of value I can't get it to
work on some parts. One part in particular is lot costed , always
has been, but there are some very strange ADJ-CST transactions which
I can't tie up. The stock status report is correct but mine is
failing.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Gary Parfrey" <garyp@...> wrote:
>
> Hi Brychan
>
>
>
> I would start with the current stock position (ie Part, Part Class
and
> PartWhse table) then subtract or add inventory transaction
(parttran)
> from it/to it based on the transaction date.
>
>
>
> One of the issues might be the last cost that is in the part master
> (6.1) partcost table (8.0) may have been a different cost in the
> previous month.
>
>
>
> Gary
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of brychanwilliams
> Sent: 26 June 2006 17:19
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Stock History
>
>
>
> Hi,
>
> I am trying to create a report that provides the current stock
total
> and previous month totals split by part class. My starting point
has
> been the Parttran table. Is it possible to do this via that
Parttran?
> My initial attempts don't seem very encouraging. I can get the
> quantities to match up against the stock status but I can't seem
to
> obtain the correct valuation. We are using a mixture of Lot and
Last
> costed parts.
>
> Thanks in advance.
>
>
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If
you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended
recipient, you must not use, disclose or distribute this e-mail
without the author's prior permission. We have taken precautions to
minimize the risk of transmitting software viruses, but we advise
you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by
software viruses.
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
Hi Mike,

Thanks for the below, there seems to be a cost adjustment on a lot
tracked component. Someone has been playing. Another tip I have
found, on lot tracked parts is to only select part tran records
where is a lot number.

I just need to verify what the adj-cst is doing. I'm quite happy to
include it and see the variance, this should match up closer to gl
once I get that far.


--- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@...> wrote:
>
> One thing to be aware of on the Stock Status report is that when
you run
> this report in the past to get a historical on-hand quantity and
value,
> the cost is the cost for the part at the time that the report is
run,
> not what it was on the historical date.
>
>
>
> Hope this helps,
>
>
>
> Mike Lowe
>
> Connor Manufacturing Services
>
>
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of brychanwilliams
> Sent: Monday, June 26, 2006 10:41 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Stock History
>
>
>
> Hi Gary,
>
> I can get the qtys right ok, but in terms of value I can't get it
to
> work on some parts. One part in particular is lot costed , always
> has been, but there are some very strange ADJ-CST transactions
which
> I can't tie up. The stock status report is correct but mine is
> failing.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Gary Parfrey" <garyp@> wrote:
> >
> > Hi Brychan
> >
> >
> >
> > I would start with the current stock position (ie Part, Part
Class
> and
> > PartWhse table) then subtract or add inventory transaction
> (parttran)
> > from it/to it based on the transaction date.
> >
> >
> >
> > One of the issues might be the last cost that is in the part
master
> > (6.1) partcost table (8.0) may have been a different cost in the
> > previous month.
> >
> >
> >
> > Gary
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of brychanwilliams
> > Sent: 26 June 2006 17:19
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Stock History
> >
> >
> >
> > Hi,
> >
> > I am trying to create a report that provides the current stock
> total
> > and previous month totals split by part class. My starting point
> has
> > been the Parttran table. Is it possible to do this via that
> Parttran?
> > My initial attempts don't seem very encouraging. I can get the
> > quantities to match up against the stock status but I can't seem
> to
> > obtain the correct valuation. We are using a mixture of Lot and
> Last
> > costed parts.
> >
> > Thanks in advance.
> >
> >
> >
> >
> >
> > This e-mail is for the use of the intended recipient(s) only. If
> you have received this e-mail in error, please notify the sender
> immediately and then delete it. If you are not the intended
> recipient, you must not use, disclose or distribute this e-mail
> without the author's prior permission. We have taken precautions
to
> minimize the risk of transmitting software viruses, but we advise
> you to carry out your own virus checks on any attachment to this
> message. We cannot accept liability for any loss or damage caused
by
> software viruses.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>