MRP

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

MRP

Venkat Mangudi
We have run into a funny problem running MRP. If I have 100 qty in stock
and a sales order for 200, MRP generates a manufacturing order for 200 and
not 100. Any idea why this is so?

--
Regards,
Venkat
Reply | Threaded
Open this post in threaded view
|

Re: MRP

Jacopo Cappellato-4
Hi Venkat,

what is the content of the ProductFacility and SupplierProduct records associated to the productId and facilityId of the MRP?

Jacopo

On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:

> We have run into a funny problem running MRP. If I have 100 qty in stock
> and a sales order for 200, MRP generates a manufacturing order for 200 and
> not 100. Any idea why this is so?
>
> --
> Regards,
> Venkat

Reply | Threaded
Open this post in threaded view
|

Re: MRP

Venkat Mangudi
Hi Jacopo,


The following is part of the report. It is a raw material with existing qty
of 661 and a manufacturing run that requires 100.


*[12315]*  Rotor - AL3
*Facility:* 10020
*Minimum Stock:* 0
*Reorder Quantity:*
*Days To Ship:*
*661*Manufacturing Order receipt 10310 (4/2/13)4/2/13 15:15:05
100.000000761Manufacturing
Order requirement 10314-10315 (4/2/13)4/2/13 16:15:05 -100.000000661


What is funny is that while this is not showing correctly, another one is
showing it just right. Please see below.

*[12811]*  Iron - Pig
*Facility:* 10020
*Minimum Stock:* 0
*Reorder Quantity:*
*Days To Ship:*
*9235.598*Manufacturing Order requirement 10461-10462 (4/2/13), 10453-10454
(4/2/13), 10445-10446 (4/2/13), 10437-10438 (4/2/13), 10429-10430 (4/2/13),
10397-10398 (4/2/13)4/2/13 16:13:14 -1490.0760007745.522Manufacturing Order
requirement 10564-10565 (4/2/13), 10556-10557 (4/2/13), 10548-10549
(4/2/13), 10540-10541 (4/2/13)4/2/13 16:13:55 -2193.4500005552.072Manufacturing
Order requirement 10342-10343 (4/2/13), 10334-10335 (4/2/13), 10326-10327
(4/2/13), 10318-10319 (4/2/13)4/2/13 16:14:05 -606.9000004945.172Manufacturing
Order requirement 10666-10667 (4/2/13), 10658-10659 (4/2/13), 10650-10651
(4/2/13), 10642-10643 (4/2/13)4/2/13 16:25:37 -4326.021000619.151

Regards,
Venkat

On Mon, May 14, 2012 at 1:19 PM, Jacopo Cappellato <
[hidden email]> wrote:

> Hi Venkat,
>
> what is the content of the ProductFacility and SupplierProduct records
> associated to the productId and facilityId of the MRP?
>
> Jacopo
>
> On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:
>
> > We have run into a funny problem running MRP. If I have 100 qty in stock
> > and a sales order for 200, MRP generates a manufacturing order for 200
> and
> > not 100. Any idea why this is so?
> >
> > --
> > Regards,
> > Venkat
>
>


--
Regards,
Venkat
Reply | Threaded
Open this post in threaded view
|

Re: MRP

Venkat Mangudi
In reply to this post by Jacopo Cappellato-4
Let me also look at those two... Quick question though, if I set minimum
qty to 0, is that a problem?

Venkat

On Mon, May 14, 2012 at 1:19 PM, Jacopo Cappellato <
[hidden email]> wrote:

> Hi Venkat,
>
> what is the content of the ProductFacility and SupplierProduct records
> associated to the productId and facilityId of the MRP?
>
> Jacopo
>
> On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:
>
> > We have run into a funny problem running MRP. If I have 100 qty in stock
> > and a sales order for 200, MRP generates a manufacturing order for 200
> and
> > not 100. Any idea why this is so?
> >
> > --
> > Regards,
> > Venkat
>
>


--
Regards,
Venkat
Reply | Threaded
Open this post in threaded view
|

Re: MRP

Venkat Mangudi
Jacopo,

I think I found the offensive setting. Product Id 123`15 seems to be a WIP,
while 12811 is setup as a Raw Material. But would that cause a problem?

--Venkat

On Mon, May 14, 2012 at 1:57 PM, Venkat Mangudi <[hidden email]>wrote:

> Let me also look at those two... Quick question though, if I set minimum
> qty to 0, is that a problem?
>
> Venkat
>
> On Mon, May 14, 2012 at 1:19 PM, Jacopo Cappellato <
> [hidden email]> wrote:
>
>> Hi Venkat,
>>
>> what is the content of the ProductFacility and SupplierProduct records
>> associated to the productId and facilityId of the MRP?
>>
>> Jacopo
>>
>> On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:
>>
>> > We have run into a funny problem running MRP. If I have 100 qty in stock
>> > and a sales order for 200, MRP generates a manufacturing order for 200
>> and
>> > not 100. Any idea why this is so?
>> >
>> > --
>> > Regards,
>> > Venkat
>>
>>
>
>
> --
> Regards,
> Venkat
>



--
Regards,
Venkat
Reply | Threaded
Open this post in threaded view
|

Re: MRP

Venkat Mangudi
OTOH, for WIP products, why does it not account for available stock when
creating Pending Internal requirements? Is there a setting for this?

--Venkat

On Mon, May 14, 2012 at 2:01 PM, Venkat Mangudi <[hidden email]>wrote:

> Jacopo,
>
> I think I found the offensive setting. Product Id 123`15 seems to be a
> WIP, while 12811 is setup as a Raw Material. But would that cause a problem?
>
> --Venkat
>
>
> On Mon, May 14, 2012 at 1:57 PM, Venkat Mangudi <[hidden email]>wrote:
>
>> Let me also look at those two... Quick question though, if I set minimum
>> qty to 0, is that a problem?
>>
>> Venkat
>>
>> On Mon, May 14, 2012 at 1:19 PM, Jacopo Cappellato <
>> [hidden email]> wrote:
>>
>>> Hi Venkat,
>>>
>>> what is the content of the ProductFacility and SupplierProduct records
>>> associated to the productId and facilityId of the MRP?
>>>
>>> Jacopo
>>>
>>> On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:
>>>
>>> > We have run into a funny problem running MRP. If I have 100 qty in
>>> stock
>>> > and a sales order for 200, MRP generates a manufacturing order for 200
>>> and
>>> > not 100. Any idea why this is so?
>>> >
>>> > --
>>> > Regards,
>>> > Venkat
>>>
>>>
>>
>>
>> --
>> Regards,
>> Venkat
>>
>
>
>
> --
> Regards,
> Venkat
>



--
Regards,
Venkat
Reply | Threaded
Open this post in threaded view
|

Re: MRP

Jacopo Cappellato-4
WIP materials required by a production run are not picked from warehouse and WIP materials created by production runs are not sent to warehouse; they are intended to stay on the manufacturing plant and are used to track materials created by a production run and used by another one (without passing for the warehouse).
If you don't want this behaviour you should use standard products (finished goods or raw materials)

Jacopo

On May 14, 2012, at 11:52 AM, Venkat Mangudi wrote:

> OTOH, for WIP products, why does it not account for available stock when
> creating Pending Internal requirements? Is there a setting for this?
>
> --Venkat
>
> On Mon, May 14, 2012 at 2:01 PM, Venkat Mangudi <[hidden email]>wrote:
>
>> Jacopo,
>>
>> I think I found the offensive setting. Product Id 123`15 seems to be a
>> WIP, while 12811 is setup as a Raw Material. But would that cause a problem?
>>
>> --Venkat
>>
>>
>> On Mon, May 14, 2012 at 1:57 PM, Venkat Mangudi <[hidden email]>wrote:
>>
>>> Let me also look at those two... Quick question though, if I set minimum
>>> qty to 0, is that a problem?
>>>
>>> Venkat
>>>
>>> On Mon, May 14, 2012 at 1:19 PM, Jacopo Cappellato <
>>> [hidden email]> wrote:
>>>
>>>> Hi Venkat,
>>>>
>>>> what is the content of the ProductFacility and SupplierProduct records
>>>> associated to the productId and facilityId of the MRP?
>>>>
>>>> Jacopo
>>>>
>>>> On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:
>>>>
>>>>> We have run into a funny problem running MRP. If I have 100 qty in
>>>> stock
>>>>> and a sales order for 200, MRP generates a manufacturing order for 200
>>>> and
>>>>> not 100. Any idea why this is so?
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Venkat
>>>>
>>>>
>>>
>>>
>>> --
>>> Regards,
>>> Venkat
>>>
>>
>>
>>
>> --
>> Regards,
>> Venkat
>>
>
>
>
> --
> Regards,
> Venkat

Reply | Threaded
Open this post in threaded view
|

Re: MRP

Venkat Mangudi
In a manufacturing setup, one cannot setup WIP as finished goods. I guess,
we'll just have to modify the behavior a bit to create Pending Internal
Requirements after taking into account existing stock. Do you think it will
break something critical?

--Venkat

On Mon, May 14, 2012 at 7:12 PM, Jacopo Cappellato <
[hidden email]> wrote:

> WIP materials required by a production run are not picked from warehouse
> and WIP materials created by production runs are not sent to warehouse;
> they are intended to stay on the manufacturing plant and are used to track
> materials created by a production run and used by another one (without
> passing for the warehouse).
> If you don't want this behaviour you should use standard products
> (finished goods or raw materials)
>
> Jacopo
>
> On May 14, 2012, at 11:52 AM, Venkat Mangudi wrote:
>
> > OTOH, for WIP products, why does it not account for available stock when
> > creating Pending Internal requirements? Is there a setting for this?
> >
> > --Venkat
> >
> > On Mon, May 14, 2012 at 2:01 PM, Venkat Mangudi <[hidden email]
> >wrote:
> >
> >> Jacopo,
> >>
> >> I think I found the offensive setting. Product Id 123`15 seems to be a
> >> WIP, while 12811 is setup as a Raw Material. But would that cause a
> problem?
> >>
> >> --Venkat
> >>
> >>
> >> On Mon, May 14, 2012 at 1:57 PM, Venkat Mangudi <
> [hidden email]>wrote:
> >>
> >>> Let me also look at those two... Quick question though, if I set
> minimum
> >>> qty to 0, is that a problem?
> >>>
> >>> Venkat
> >>>
> >>> On Mon, May 14, 2012 at 1:19 PM, Jacopo Cappellato <
> >>> [hidden email]> wrote:
> >>>
> >>>> Hi Venkat,
> >>>>
> >>>> what is the content of the ProductFacility and SupplierProduct records
> >>>> associated to the productId and facilityId of the MRP?
> >>>>
> >>>> Jacopo
> >>>>
> >>>> On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:
> >>>>
> >>>>> We have run into a funny problem running MRP. If I have 100 qty in
> >>>> stock
> >>>>> and a sales order for 200, MRP generates a manufacturing order for
> 200
> >>>> and
> >>>>> not 100. Any idea why this is so?
> >>>>>
> >>>>> --
> >>>>> Regards,
> >>>>> Venkat
> >>>>
> >>>>
> >>>
> >>>
> >>> --
> >>> Regards,
> >>> Venkat
> >>>
> >>
> >>
> >>
> >> --
> >> Regards,
> >> Venkat
> >>
> >
> >
> >
> > --
> > Regards,
> > Venkat
>
>


--
Regards,
Venkat
Reply | Threaded
Open this post in threaded view
|

Re: MRP

Jacopo Cappellato-4

On May 14, 2012, at 4:29 PM, Venkat Mangudi wrote:

> In a manufacturing setup, one cannot setup WIP as finished goods.

Did you consider to use for them the SUBASSEMBLY type rather than the WIP type?

Jacopo


> I guess,
> we'll just have to modify the behavior a bit to create Pending Internal
> Requirements after taking into account existing stock. Do you think it will
> break something critical?
>
> --Venkat
>
> On Mon, May 14, 2012 at 7:12 PM, Jacopo Cappellato <
> [hidden email]> wrote:
>
>> WIP materials required by a production run are not picked from warehouse
>> and WIP materials created by production runs are not sent to warehouse;
>> they are intended to stay on the manufacturing plant and are used to track
>> materials created by a production run and used by another one (without
>> passing for the warehouse).
>> If you don't want this behaviour you should use standard products
>> (finished goods or raw materials)
>>
>> Jacopo
>>
>> On May 14, 2012, at 11:52 AM, Venkat Mangudi wrote:
>>
>>> OTOH, for WIP products, why does it not account for available stock when
>>> creating Pending Internal requirements? Is there a setting for this?
>>>
>>> --Venkat
>>>
>>> On Mon, May 14, 2012 at 2:01 PM, Venkat Mangudi <[hidden email]
>>> wrote:
>>>
>>>> Jacopo,
>>>>
>>>> I think I found the offensive setting. Product Id 123`15 seems to be a
>>>> WIP, while 12811 is setup as a Raw Material. But would that cause a
>> problem?
>>>>
>>>> --Venkat
>>>>
>>>>
>>>> On Mon, May 14, 2012 at 1:57 PM, Venkat Mangudi <
>> [hidden email]>wrote:
>>>>
>>>>> Let me also look at those two... Quick question though, if I set
>> minimum
>>>>> qty to 0, is that a problem?
>>>>>
>>>>> Venkat
>>>>>
>>>>> On Mon, May 14, 2012 at 1:19 PM, Jacopo Cappellato <
>>>>> [hidden email]> wrote:
>>>>>
>>>>>> Hi Venkat,
>>>>>>
>>>>>> what is the content of the ProductFacility and SupplierProduct records
>>>>>> associated to the productId and facilityId of the MRP?
>>>>>>
>>>>>> Jacopo
>>>>>>
>>>>>> On May 14, 2012, at 9:26 AM, Venkat Mangudi wrote:
>>>>>>
>>>>>>> We have run into a funny problem running MRP. If I have 100 qty in
>>>>>> stock
>>>>>>> and a sales order for 200, MRP generates a manufacturing order for
>> 200
>>>>>> and
>>>>>>> not 100. Any idea why this is so?
>>>>>>>
>>>>>>> --
>>>>>>> Regards,
>>>>>>> Venkat
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Venkat
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Venkat
>>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Venkat
>>
>>
>
>
> --
> Regards,
> Venkat

Reply | Threaded
Open this post in threaded view
|

Re: MRP

Venkat Mangudi
On Mon, May 14, 2012 at 8:27 PM, Jacopo Cappellato <
[hidden email]> wrote:

>
> > In a manufacturing setup, one cannot setup WIP as finished goods.
>
> Did you consider to use for them the SUBASSEMBLY type rather than the WIP
> type?
>

When I did that, it did not create production runs for the sub-assemblies.
Which is when we decided to use WIP. The product BOM is 7 levels deep.

The only thing we need to change now is to consider the existing quantity
before creating the manufacturing runs.

--
Regards,
Venkat