Re: (no subject)
denroxi <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
kevin, just an observer but good work, using the system as designed rather than designing a new system....basic KISS MAPICS.. Dennis Guy Vaillant cell 401-447-4690 skype....dennis.guy.vaillant In a message dated 09/17/09 19:01:05 Eastern Daylight Time, [email protected] writes: Gene, I'm suggesting that instead of attempting to modify the BOM database to accommodate the warehouse (which would be a very nice feature for INFOR to add to the product!) I'm suggesting that the BOM be changed to create the related BOM's. Let me illustrated. Let's suppose I have a BOM and associated routing that looks like the following: ENDITEM -PART123 -PART456 -PART789 OPERATION 0010 MEXICO USES PART123 AND PART456 OPERATION 0020 BOISE USES PART789 If I represent the "Item Process" as follows: ENDITEM -0010 ASSEMBLY (MEXICO) --PART123 --PART456 -0020 FINAL ASSEMBLY (BOISE) --PART789 Then I would change it to the following: ENDITEM -PART789 OPERATION 0010 BOISE USES PART789 WIPITEM -PART123 -PART456 OPERATION 0010 MEXICO USES PART123 AND PART456 I can then represent the indented "Item Process" as follows: ENDITEM -0010 ASSEMBLY (BOISE) --PART789 --WIPITEM ---0010 ASSEMBLY (MEXICO) ----PART123 ----PART456 You could then define in the warehouse a relationship type like follows: Demand Warehouse: 1 (Boise) Relationship: 1(*DEF) Item: ENDITEM Demand Warehouse: 1 (Boise) Relationship: 3(*ITEM-OUT) Item: WIPITEM Demand Warehouse: 2 (Mexico) Relationship: 2(*ITEM-IN) Item: WIPITEM When MRP runs for each warehouse, you will generate plan to build ENDITEM in Boise and make it dependent upon supply of WIPITEM from Mexico. Here are the steps. 1. You will generate an MO for WIPITEM in Mexico (Can use Auto-Release) 2. Receive WIPITEM to the warehouse in Mexico from the MO 3. TW Transfer from Warehouse 2 (Mexico) to Warehouse 1(Boise) (Note: you need to have a reconciling location for "in transit", if you have R7.8 this is automatic) 4. Receive WIPITEM into warehouse 1 Boise) 5. Issue WIPITEM to another MO that makes ENDITEM 6. Receive ENDITEM into stock in warehouse 1 and ship In practice, this is very easy to do as all the MRP logic works normal, and the transactions that each warehouse executes are also normal transactions that are easily understood and implemented. Where my clients get this messed up is when they think "hey let's automate it and reduce the number of transactions". This of course is usually done BEFORE they have control of the system. My experience has been that if the transactions are done "as required" and then good six-sigma practices are used to define improvements, that automating the transactions very rarely, if ever, rise to the point that it justifies automating them. (Excluding bar coding of course.) Just note again, R7.8 has the "automatic" features built in. Good Luck! Kevin -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Gene lampe Sent: Thursday, September 17, 2009 3:02 PM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] (no subject) Thanks for the information. When you refer to splits, do you mean doing a manufacturing order split? -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Kevin Fox Sent: Thursday, September 17, 2009 3:03 PM To: 'MAPICS ERP System Discussion' Subject: Re: [MAPICS-L] (no subject) Gene Correct, the MO assumes all material comes from the warehouse for the finished item. 1 solution and 1 work around. Solutions: Intersite Logistics is a XA (MAPICS) application designed to resolve just this issue. Work around: Split your bills such that the Mexico WIP is complete to an item level. Then this can be interplant shipped to Boise. Then a separate bill for the wip in Boise with the Mexican WIP production item as one of the components. This appears to cause some extra steps, but in reality someone is doing these steps offline now anyway. Also, with R7.8 you have the ability to automate the transfer between the warehouses have an "in transit" location to answer the question "where is it now?". Kevin Fox -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Gene lampe Sent: Thursday, September 17, 2009 1:54 PM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] (no subject) I have a question for the group about multiple warehouses. We are a job shop with two locations. One is in Boise, Idaho and the other is in Mexico. We carry inventory in both of these locations and are in the process of separating this inventory into its own warehouse. Right now the inventory is combined. Warehouse #1 is in Idaho and Warehouse #2 is in Mexico. We have some part numbers that need to be built in Mexico and then sent to our Boise location to be finished and vice versa. I would like to use the warehouse number as an indicator to where the inventory is supposed to go, but I have some problems. 1) Is there any way on a BOM to put a warehouse number on where the material is going to be used from? For example, we have one process that starts in Boise and then is sent to Mexico to be finished. The only materials used are at the Boise facility and the WIP then gets sent down to Mexico to be completed. The problem is when we create a Manufacturing order for warehouse #2, the BOM says all the material is going to be used from warehouse #2, when in reality it is going to be used from warehouse #1. I know you can change this BOM at the M0 level, but I was hoping that someone had a fix for this at the routing level. 2) We are entering are orders in COM to ship from the preferred warehouse based on a set of rules. As per my previous question, when we have WIP being sent from Mexico to Idaho, the customer order has been entered to ship from warehouse #1, but will be processed in Warehouse #2 and then sent to warehouse #1 to be completed. I enter the manufacturing order to warehouse #1 and change the components on the BOM to warehouse #2 which works fine except that MRP seems to only recognize the warehouse number on the header and not the BOM level. Is this correct? Is there anything that can be done to fix this? We currently are running PDM in an XA environment, release 7.7. Any feedback on this is greatly appreciated. Thanks, Gene Gene Lampe > Director of Operations > Quality Thermistor Inc > 2108 Century Way > Boise, ID 83709 O|208|377|3373 C|208|891|2319 F|208|376|4754 > [email protected] <mailto:[email protected]> > www.thermistor.com <http://www.thermistor.com/> _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.