RE: M2M planned requirements.

[McCourt, Bruce]

Gloria,

Do you use the MRP for subassemblies? If so, does M2M require a JO to be opened at each level of the BOM before calculating demand for the next level components or assemblies?

 

Thanks,

Bruce

 

---

From: Rajesh Walia [mailto:r...@diamondbinc.com]
Sent: Thursday, June 14, 2007 2:58 PM
To: McCourt, Bruce
Subject: RE: M2M planned requirements.

 

Hi Bruce.

 

We don't really use the JO queue or MRP for sub-assemblies but from what I recall, you have to run that queue as many times as your BOM is deep.  So if the finished good requires sub-assembly A which requires sub-assembly AA, then you have to run it three times to get it to pick up each subsequent sub-assembly.  In other words it does one layer at a time.

 

Right, and you would have open the JO at each layer for it show demand for the next layer.

 

But again, we don't use it so my knowledge is very sketchy on that.  You could post the message and see what you get for responses  (if you can post - referring back to your previous emails) or more directly, you might try Gloria at Malibu Research as I believe they has many layers in their BOM's that might answer your question better.  I've attached her contact info.

 

And also, I'm still on the VFP model so I don't know if this is something that's changed in SQL.

 

Sorry I couldn't be a more direct help on this but let me know if you have other questions!

 

Raj

 

 

 

---

From: McCourt, Bruce [mailto:b_mc...@dynaroll.com]
Sent: Thursday, June 14, 2007 2:16 PM
To: r...@diamondbinc.com.
Subject: M2M planned requirements.

Raj,

Basic question…

When we add a sales order to M2M for an assembly, stock requirement;

M2M does not plan demand at lower levels in the BOM unless we open a JO for the assembly.

 

For example,

Add SO for Assembly P/N 12000, (500) pieces due 6/29/07.

M2M does not calculate the demand for (500) pieces subassembly P/N 3400 or raw material P/N 6300 required to make P/N 3400.

 

Do we need to modify a configuration setting?

 

Best Regards,

Bruce McCourt

Operations Manager

Dynaroll Corporation

551A Fifth Street

San Fernando, CA 91340

(818) 837-3456  Fax -0060

 

[Gloria Dyok]

Sorry Bruce, we don’t use the MRP module either.  Since just about every one of our products is a “new” design, our Sales Orders only minimally drive our job queue.  We get a series of jobs opened on each sales order by having a “template” master BOM.  This really allows our engineering group to start the NRE and designing of the system.  We drop this template in the contract line item and it creates a series of subjobs which can all be released via the JO Queue for SO Items. 

 

We would like to be more proactive and plan material demand but we would have a lot of cleanup to make it accurate.

 

Not too helpful for you I’m sure.

 

 

Gloria Dyok

Cost Accountant

Malibu Research Assoc., Inc.

3760-A Calle Tecate

Camarillo, CA  93012

 

gd...@maliburesearch.com

ph. 805-383-1829 xt. 107

fax 805-383-1859

---

[McCourt, Bruce]

Thanks Gloria and Raj, your feedback does help.

We are still in the implementation phases of M2M and are learning more every day as we walk through Sales Order entry to shipment and invoicing.

 

Do any of you other M2M users utilize the MRP module to plan requirements vs. replenishments throughout all levels of the BOM?

 

We have custom products with blanket sales orders for repeat business so we don’t need to create a new BOM or Traveler with each Sales Order.

 

I noticed some MPS commands in M2M but we haven’t had training on it yet.

Maybe a Production Plan or Forecast can be loaded into the MPS to achieve our goals?

 

Thanks,

Bruce

 

---

[Ray Collazo]

Gloria:

  It sounds like you run your system the same way we do here, with no MRP and using Sales orders to drive your Job queue...

 

If you're interested, you may be interested in a system I just developed for my company which follows the same Idea: It runs external to Made2Manage, requires a simple machine with ODBC connectivity for the client, and one custom database on the M2M Server. I call it "Lineview"...

 

It provides a means for our assembly line workers to see the Line Items as they are being opened on the Sales Orders (and released Job Orders): When a sales order is opened, Lineview, when opened to a particular 'assembly line' (workstation), will show all the sales order line items which need to be made on that line.

 

The workers then have the ability to click the items and transfer them to their own "Working on" list. They have the ability to sort by part number, which allows them to select like parts and work on them all at the same time. They also have a Comment area where they can go ahead and write in comments concerning the order.

 

The supervisor can see all the lines, and can see who is working on what orders. The supervisor can also take and directly assign orders to specific workstations.

 

Once the employee is done, they can mark the job as being "Done", and once shipped, the order will drop from their screen.

 

Its quite an intensive bit of VFP scripting that I've been working on. If anyones interested, I'll happily share the project with others.

 

-Ray

-----Original Message-----
From: lam2m...@googlegroups.com [mailto:lam2m...@googlegroups.com] On Behalf Of Gloria Dyok
Sent: Friday, June 15, 2007 8:38 AM
To: lam2m...@googlegroups.com
Subject: [lam2musers] Re: M2M planned requirements.

[Allan Lakin]

> If you're interested, you may be interested in a system I just developed for my company which follows the same Idea: It runs external to Made2Manage, requires a simple machine with ODBC connectivity for the client, and one custom database on the M2M Server. I call it "Lineview"...
<

I have built something similar.

 

It's an Excel spreadsheet that extracts data from the job order master and job order routing tables.

There's a cell with a drop-down menu of work centers.  Pull up the Work Center name (in full text, not the

6-character code) and you get a listing of all the jobs waiting to pass thru the work center.  Labor

reporting (qty complete) closes out the work center requirement.

 

The spreadsheet has been installed on every shop floor computer kiosk.  Our floor supervisors LIKE it a

lot more than the M2M standard reports, mostly because they get an answer in 1-2 seconds instead of

(zzzz.......  ).

 

We're on 5.52SQL, but the same principle ought to work for FoxPro because it's just ODBC plus Excel's

built in use of query parameters to ID the work center and date range of interest.

 

Al Lakin

Fralock

 

[Allan Lakin]

> If you're interested, you may be interested in a system I just developed for my company which follows the same Idea: It runs external to Made2Manage, requires a simple machine with ODBC connectivity for the client, and one custom database on the M2M Server. I call it "Lineview"...
<

I have built something similar.