Material Qty Adjustment - Material Cost

Yahoo Archive
1
I am seeing it in Part Transaction screen, however we didn't buy any
parts at the point the cost changed. We had made a qty adjustment only
which is why we are so confused as to why the cost basis was changed as
well.





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Thursday, January 24, 2008 10:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Material Qty Adjustment - Material Cost



Keith,

Can I ask were you are seeing the Mtl Cost change. Is it in the Part
Cost
Table (Cost Adjustment screen) or is it in Part Transaction History
Tracker.

If it is in the Tracker the system will do an adjustment for a Receipt
of a
Part if it was purchased at a different cost than your standard cost is
set
at and if the part is setup for std cost. So if your std cost is $1 and
you
purchased and received a part for $0.50 that the system will adjust
those
parts to the std cost for inventory valuation.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Keith Mailloux
Sent: Thursday, January 24, 2008 8:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re:Material Qty Adjustment - Material Cost

That's what we thought. I have reviewed the transaction history and the
only transactions which took place were of type ADJ-QTY. PO receipts and
cost adjustments typically show up and have specific type codes. I
attached a screen print, maybe I am missing something, the transaction
date was 1/9/07.

Thanks for looking at this. I have a call into Epicor and they agree
with you as well.

Keith

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Claudia Stone
Sent: Wednesday, January 23, 2008 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re:Material Qty Adjustment - Material Cost

>Posted by: "Keith Mailloux" keith.mailloux@...
<mailto:keith.mailloux%40fergusonperf.com>
<mailto:keith.mailloux%40fergusonperf.com> kmailloux1959
>Wed Jan 23, 2008 7:38 am (PST)
>We recently made a quantity adjustment to a raw material part number
>(ADJ-QTY). Prior to the adjustment our Mtl Unit Cost was 1,286.59294
>after the adjustment and subsequent transactions the Mtl Unit Cost was
>1,807.70095. Does anyone know how the new value is calculated? We have
>tried all kinds of aberrations on prior costs, avg. costs and can't
seem
>to figure it out.

Quantity adjustments don't change costs. The only way the average or
last cost gets updated is by a PO receipt. If you are using standard
costing then you have to enter the change via either a cost roll-up or a
cost adjustment.

Claudia Stone
Aspacia Systems Inc

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

---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links





---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
2
We recently made a quantity adjustment to a raw material part number
(ADJ-QTY). Prior to the adjustment our Mtl Unit Cost was 1,286.59294
after the adjustment and subsequent transactions the Mtl Unit Cost was
1,807.70095. Does anyone know how the new value is calculated? We have
tried all kinds of aberrations on prior costs, avg. costs and can't seem
to figure it out.



Thanks



Keith Mailloux







---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
3
>Posted by: "Keith Mailloux" keith.mailloux@... kmailloux1959
>Wed Jan 23, 2008 7:38 am (PST)
>We recently made a quantity adjustment to a raw material part number
>(ADJ-QTY). Prior to the adjustment our Mtl Unit Cost was 1,286.59294
>after the adjustment and subsequent transactions the Mtl Unit Cost was
>1,807.70095. Does anyone know how the new value is calculated? We have
>tried all kinds of aberrations on prior costs, avg. costs and can't seem
>to figure it out.

Quantity adjustments don't change costs. The only way the average or last cost gets updated is by a PO receipt. If you are using standard costing then you have to enter the change via either a cost roll-up or a cost adjustment.

Claudia Stone
Aspacia Systems Inc


[Non-text portions of this message have been removed]
4
That's what we thought. I have reviewed the transaction history and the
only transactions which took place were of type ADJ-QTY. PO receipts and
cost adjustments typically show up and have specific type codes. I
attached a screen print, maybe I am missing something, the transaction
date was 1/9/07.



Thanks for looking at this. I have a call into Epicor and they agree
with you as well.



Keith



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Claudia Stone
Sent: Wednesday, January 23, 2008 5:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Material Qty Adjustment - Material Cost



>Posted by: "Keith Mailloux" keith.mailloux@...
<mailto:keith.mailloux%40fergusonperf.com> kmailloux1959
>Wed Jan 23, 2008 7:38 am (PST)
>We recently made a quantity adjustment to a raw material part number
>(ADJ-QTY). Prior to the adjustment our Mtl Unit Cost was 1,286.59294
>after the adjustment and subsequent transactions the Mtl Unit Cost was
>1,807.70095. Does anyone know how the new value is calculated? We have
>tried all kinds of aberrations on prior costs, avg. costs and can't
seem
>to figure it out.

Quantity adjustments don't change costs. The only way the average or
last cost gets updated is by a PO receipt. If you are using standard
costing then you have to enter the change via either a cost roll-up or a
cost adjustment.

Claudia Stone
Aspacia Systems Inc

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





---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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

Can I ask were you are seeing the Mtl Cost change. Is it in the Part Cost
Table (Cost Adjustment screen) or is it in Part Transaction History Tracker.

If it is in the Tracker the system will do an adjustment for a Receipt of a
Part if it was purchased at a different cost than your standard cost is set
at and if the part is setup for std cost. So if your std cost is $1 and you
purchased and received a part for $0.50 that the system will adjust those
parts to the std cost for inventory valuation.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Keith Mailloux
Sent: Thursday, January 24, 2008 8:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Material Qty Adjustment - Material Cost

That's what we thought. I have reviewed the transaction history and the
only transactions which took place were of type ADJ-QTY. PO receipts and
cost adjustments typically show up and have specific type codes. I
attached a screen print, maybe I am missing something, the transaction
date was 1/9/07.



Thanks for looking at this. I have a call into Epicor and they agree
with you as well.



Keith



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Claudia Stone
Sent: Wednesday, January 23, 2008 5:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Material Qty Adjustment - Material Cost



>Posted by: "Keith Mailloux" keith.mailloux@...
<mailto:keith.mailloux%40fergusonperf.com> kmailloux1959
>Wed Jan 23, 2008 7:38 am (PST)
>We recently made a quantity adjustment to a raw material part number
>(ADJ-QTY). Prior to the adjustment our Mtl Unit Cost was 1,286.59294
>after the adjustment and subsequent transactions the Mtl Unit Cost was
>1,807.70095. Does anyone know how the new value is calculated? We have
>tried all kinds of aberrations on prior costs, avg. costs and can't
seem
>to figure it out.

Quantity adjustments don't change costs. The only way the average or
last cost gets updated is by a PO receipt. If you are using standard
costing then you have to enter the change via either a cost roll-up or a
cost adjustment.

Claudia Stone
Aspacia Systems Inc

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





---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links