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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Free forum by Nabble | Edit this page |