[AccessD] 'Heirarchal Recursion':

Ron:

Well, you don't have to use all of the system.  The Bill of Materials runs
by itself with no other requirements.

I've got a user in Florida running about 15 seats - using just the BOM part
of the system. Have been for about 5 years.   (Could give you his name and
number for a reference if you want.).  They've got an ERP system for all
their other manufacturing.  So you could definitely be up and running by
Thursday.

BOM reporting in E-Z-MRP include single level and indented, costed and
uncosted, summary bills, and where-used.  Manufacturer's cross references
and component reference data supported as well as effective and obsolete
dates on all the components and phantom or blow-through assemblies.

If there's interest we should probably move this discussion off-line.
Contact me at bchacc at san.rr.com.

Best,

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Ron Moore" <rmoore at comtechpst.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Tuesday, March 23, 2004 9:42 AM
Subject: RE: [AccessD] 'Heirarchal Recursion':


> Rocky,  I'm aware of your fine looking product (congrats on your recent
> launch).  MRP is not in the near future.  Inventories are currently in
> PeachTree which is DDE only, not ODBC.  I simply need multi-level bills
> reporting capability within two days!
>
> Thanks,
> Ron
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> - Beach Access Software
> Sent: Tuesday, March 23, 2004 12:31 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] 'Heirarchal Recursion':
>
>
> Ron:
>
> E-Z-MRP's bill of materials processor handles multi-level bills.  Would
> this www.e-z-mrp.com be an option?  I can give you system to evaluate.
> Also convert the existing data so you've got something familiar to look
> at.
>
> Regards,
>
>
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
>
>
> ----- Original Message ----- 
> From: "Ron Moore" <rmoore at comtechpst.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, March 23, 2004 9:16 AM
> Subject: [AccessD] 'Heirarchal Recursion':
>
>
> > I've inherited a 15MB engineering _fe A2K DB with single level product
>
> > structures for manufactured assemblies.  I need to create an
> > 'indentured' multi-level bill of material (BOM), presumably using
> > recursion.  I used to have an article from 'Access-VB-SQL' mag some
> > time back called 'Heirarchal Recursion' (I think) but can't locate it
> > now.
> >
> > Any ideas?  Best Sources on the web?
> > TIA,
> > Ron Moore
> > Sr. Database Administrator
> > Comtech PST Corp.
> > Melville, NY
> > www.comtechpst.com
> > --
> > _______________________________________________
> > 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
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>