[AccessD] Cost Rollup Logic Using Lower Level Code

Joe:

>From the APICS dictionary: "LOW LEVEL CODE - Identifies the lowest level in
any bill of material at which a particular component may appear. Net
requirements for a given component are not calculated until all the gross
requirements for that level have been calculated down to that level.  Low
level codes are normally calculated and maintained automatically by the
computer software."

I use a level code in my BOM Processor - level zero is the component level -
and the levels are assigned during the cost roll up process. So I'm not
using the level code in the standard way.  I had to design a bit of a
different approach to the cost roll-up and MRP calculating algorithm in
order to make it fast enough to run on an original IBM PC AT even though it
had that huge 10MB hard drive and ran at a blazing 5MHz. 

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: Tuesday, December 05, 2006 5:41 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Cost Rollup Logic Using Lower Level Code

Hello,

I know that at some users on the list have worked on ERP systems, which
is why I am posting this question to this group.

I created a function that rolls the cost of part numbers using both the
production detail of how to make the part as well as the bill of
material. This function works great but I noticed in a couple of ERP
systems that I have worked with that they use the concept of a "lower
level code" to indicate the cost roll sequence.

I was wondering if someone could explain how the lower level code is
used in a cost roll up and what the outline of a rollup function would
look like using the lower level code.

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/568 - Release Date: 12/4/2006
3:20 PM