Cost Roll Weirdness (V8)

Hi Joe,



We're on 6.1, so I'm not sure if this is an issue for you - but we found
similar discrepancies on parts that have Lot Tracking, even though we're
on Standard Costing.



Tanya Jernigan

tjernigan@... <mailto:tjernigan@...>

www.waterjetparts.com <http://www.waterjetparts.com/>


H2O Jet, Inc.


1043-D Kaiser Rd. SW

Olympia, WA 98512

360-866-7161 Phone

360-866-7610 Fax





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Monday, December 04, 2006 10:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Cost Roll Weirdness (V8)



Hello,

I am going to place a call to tech support but I thought I would also
throw this out to the group in case someone else had this same problem.

We have been having problems with getting the cost rollup function to
work properly for a long time now.

We had a couple of problems with out initial data conversion which
attributed to much of it. We corrected all those issue but are still
having problems.

Now our problem is that after we load the costs into the costing
workbench, we rolled the cost 5 times. After each time, we took a
snapshot of the CostPart table using MS Access. We then compared the 5
rolled cost sets and found that many parts had a different cost in each
cost set!

It looks like the "This Level" costs are always accurate and consistent
but it's the rolled up costs that accumulate in StdMaterialCost that
keeps varying.

I keep staring at the BOMs and I can't find anything that would be
causing this problem. The only thing I can think of is that it has
something to do with the fact that we have a lot of lower level
components that are used in many different BOMs and that there is a
timing issue with the cost roll.

What I don't get is even if there was another problem with our
conversion; I would expect the cost roll to be consistent across several
rolls even if it were incorrect!

Any ideas out there?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>








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



I am going to place a call to tech support but I thought I would also
throw this out to the group in case someone else had this same problem.



We have been having problems with getting the cost rollup function to
work properly for a long time now.

We had a couple of problems with out initial data conversion which
attributed to much of it. We corrected all those issue but are still
having problems.



Now our problem is that after we load the costs into the costing
workbench, we rolled the cost 5 times. After each time, we took a
snapshot of the CostPart table using MS Access. We then compared the 5
rolled cost sets and found that many parts had a different cost in each
cost set!

It looks like the "This Level" costs are always accurate and consistent
but it's the rolled up costs that accumulate in StdMaterialCost that
keeps varying.



I keep staring at the BOMs and I can't find anything that would be
causing this problem. The only thing I can think of is that it has
something to do with the fact that we have a lot of lower level
components that are used in many different BOMs and that there is a
timing issue with the cost roll.



What I don't get is even if there was another problem with our
conversion; I would expect the cost roll to be consistent across several
rolls even if it were incorrect!



Any ideas out there?



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



[Non-text portions of this message have been removed]
Are you making sure to roll all parts? I know that we were having a
similar problem but we discovered that the person doing the roll was
selecting only specific parts. So, if you rolled a component but then
didn't roll all parents you would have a disconnect.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Monday, December 04, 2006 10:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Cost Roll Weirdness (V8)



Hello,

I am going to place a call to tech support but I thought I would also
throw this out to the group in case someone else had this same problem.

We have been having problems with getting the cost rollup function to
work properly for a long time now.

We had a couple of problems with out initial data conversion which
attributed to much of it. We corrected all those issue but are still
having problems.

Now our problem is that after we load the costs into the costing
workbench, we rolled the cost 5 times. After each time, we took a
snapshot of the CostPart table using MS Access. We then compared the 5
rolled cost sets and found that many parts had a different cost in each
cost set!

It looks like the "This Level" costs are always accurate and consistent
but it's the rolled up costs that accumulate in StdMaterialCost that
keeps varying.

I keep staring at the BOMs and I can't find anything that would be
causing this problem. The only thing I can think of is that it has
something to do with the fact that we have a lot of lower level
components that are used in many different BOMs and that there is a
timing issue with the cost roll.

What I don't get is even if there was another problem with our
conversion; I would expect the cost roll to be consistent across several
rolls even if it were incorrect!

Any ideas out there?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

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




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________



[Non-text portions of this message have been removed]
Turns out that all I had to do was run conversion program 5100 to
recalculate the lower level codes.

I can't believe that the people in data conversion did not tell me that
that this was a required step!



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Monday, December 04, 2006 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Cost Roll Weirdness (V8)



Are you making sure to roll all parts? I know that we were having a
similar problem but we discovered that the person doing the roll was
selecting only specific parts. So, if you rolled a component but then
didn't roll all parents you would have a disconnect.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Monday, December 04, 2006 10:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Cost Roll Weirdness (V8)

Hello,

I am going to place a call to tech support but I thought I would also
throw this out to the group in case someone else had this same problem.

We have been having problems with getting the cost rollup function to
work properly for a long time now.

We had a couple of problems with out initial data conversion which
attributed to much of it. We corrected all those issue but are still
having problems.

Now our problem is that after we load the costs into the costing
workbench, we rolled the cost 5 times. After each time, we took a
snapshot of the CostPart table using MS Access. We then compared the 5
rolled cost sets and found that many parts had a different cost in each
cost set!

It looks like the "This Level" costs are always accurate and consistent
but it's the rolled up costs that accumulate in StdMaterialCost that
keeps varying.

I keep staring at the BOMs and I can't find anything that would be
causing this problem. The only thing I can think of is that it has
something to do with the fact that we have a lot of lower level
components that are used in many different BOMs and that there is a
timing issue with the cost roll.

What I don't get is even if there was another problem with our
conversion; I would expect the cost roll to be consistent across several
rolls even if it were incorrect!

Any ideas out there?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

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

__________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
<http://www.messagelabs.com/email>
__________________________________________________________

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





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