[AccessD] MRP Coding Examples

Joe Rojas JRojas at tnco-inc.com
Wed Jul 20 07:16:55 CDT 2005


Thanks for the reply Jim,

I would be willing to take what ever you have. I am trying to get a look at
the big picture to see what would be involved it creating this project.

Thanks!
JR

-----Original Message-----
From: Jim Dettman [mailto:jimdettman at earthlink.net]
Sent: Tuesday, July 19, 2005 6:58 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MRP Coding Examples

Joe,

  I have BOM explosion logic that is SQL based and VBA based, which will
generate material requirements that can be time phased.  There are a bunch
of other things that then come into play; Planed orders, demand time fences,
fixed and/or variable lead times, safety stock, minimum order qty, economic
order qty, independent demands, etc

 I can recommend a DB design that has worked well for me over the years.

 But it's a lot of work and a major undertaking to do it right.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Rojas
Sent: Tuesday, July 19, 2005 1:01 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] MRP Coding Examples


Determining requirements, really.
Assuming that I have all the underlying data, I need to figure out how to
generate a Make/Buy report looking at it by time periods.

I just talked to Rocky and using EZ-MRP maybe a solution...
I don't know what is involved in creating my own system so it is hard to
determine which way to go...

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com

-----Original Message-----
From: Jim Dettman [mailto:jimdettman at earthlink.net]
Sent: Monday, July 18, 2005 5:10 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MRP Coding Examples

JR,

  What is it that your looking of examples for? "MRP" covers a lot of
ground; BOM's, Routings, Time Phased Inventory, Purchasing, Quality control,
Scrap and Rejection, Capacity planning, etc.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Rojas
Sent: Monday, July 18, 2005 3:03 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] MRP Coding Examples


Hi All,

I need to create an application that can perform Material Requirements
Planning (MRP) generation.
I have done a lot of Google searching looking for programming examples with
no luck.

I don't want to recreate the wheel here if there are already some examples
that I could learn from.

Anyone know of how to achieve this or have any links that might point me in
the right direction?

Thanks,
JR




This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.



More information about the AccessD mailing list