Moving from Average Cost to Standard

Yahoo Archive
1
Talk to Epicor Custom Programming about an Export/Import utility. I used
one back in the 4.00 days to change cost methods without having to zero
out the quantity. It also let us input standard costs that we
manipulated in excel.



Steve Ashton
Database Specialist
Decoustics Limited
65 Disco Road
Toronto, Ontario
Canada M9W 1M2
T (647) 259-4260
F (416) 679-8838

sashton@... <mailto:sashton@...>
Steve.Ashton@... <mailto:Steve.Ashton2@...>


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Toby Boogerd
Sent: Monday, March 10, 2008 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Moving from Average Cost to Standard



We have a database of about 60,000 + parts. We are using the average
costing method and are in the process of moving to standard costing. We
know we will not update all 60,000+ parts but at least those active in
the last xxx(say 3) months. We are using Vantage 6.1 and also have
8.03.4xx setup in a test environment (in case someone has a solution for
8 and not 6). We rolled our average to standard so that we would
populate fields with standard data that we can report against. Here is
what we are looking for and I just want opinions, thoughts, reports,
ANYTHING that can help us move forward.

We have historical data, just not up-to-date standards. Worst case, we
would write a program/report to mine the historical data, throw out the
best and worst 10 or 20% and use the average of that as the standard.
The issue is that we are then locking in the historical performance,
even if it is poor. This was the route we were heading anyway.


Toby Boogerd
Rosenboom Machine & Tool, Inc.
Information Systems
1530 Western Ave, PO BOX 280
Sheldon, IA 51201
office: (712) 324-4854
fax: (712) 324-4522
RMT Privacy Policy
This email may contain confidential and proprietary information of
Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.



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





[Non-text portions of this message have been removed]
2
We have a database of about 60,000 + parts. We are using the average
costing method and are in the process of moving to standard costing. We
know we will not update all 60,000+ parts but at least those active in
the last xxx(say 3) months. We are using Vantage 6.1 and also have
8.03.4xx setup in a test environment (in case someone has a solution for
8 and not 6). We rolled our average to standard so that we would
populate fields with standard data that we can report against. Here is
what we are looking for and I just want opinions, thoughts, reports,
ANYTHING that can help us move forward.

We have historical data, just not up-to-date standards. Worst case, we
would write a program/report to mine the historical data, throw out the
best and worst 10 or 20% and use the average of that as the standard.
The issue is that we are then locking in the historical performance,
even if it is poor. This was the route we were heading anyway.


Toby Boogerd
Rosenboom Machine & Tool, Inc.
Information Systems
1530 Western Ave, PO BOX 280
Sheldon, IA 51201
office: (712) 324-4854
fax: (712) 324-4522
RMT Privacy Policy
This email may contain confidential and proprietary information of
Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.




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