Problem in MRP
Locked
 
|
Hello All,
We are facing a problem in creating requirements for raw material. We have set the Requirement Method Enum Id as 'Requirement for order when ATP Reaches Minimum Stock for Product Facility' and set the Minimum Stock and Reorder Quantity and Days to Ship through Product---->Facilities tab. Now after running MRP through Manufacturing Inventory Event is planned. but we didn't find any entry for Requirements in Order---> Requirements tab. Please suggest any solution to this problem. -- Thanks and regards, Ajay Sodhi Software Engineer, Pal InfoCom Technologies, Mohali - India |
|
|
Hi Ajay,
On Sep 8, 2009, at 6:17 AM, Pal InfoCom Technologies wrote: > > Hello All, > > We are facing a problem in creating requirements for raw material. We > have set the Requirement Method Enum Id as 'Requirement for order > when ATP > Reaches Minimum Stock for Product Facility' the above is not required when you use MRP > and set the Minimum Stock and > Reorder Quantity and Days to Ship through Product---->Facilities > tab. Now > after running MRP through Manufacturing Inventory Event is planned. > but we > didn't find any entry for Requirements in Order---> Requirements tab. > What is the content of the MRP log screen? Do you have inventory on hand for that product? What OFBiz version are you using? Cheers, Jacopo > > Please suggest any solution to this problem. > > -- > Thanks and regards, > Ajay Sodhi > > Software Engineer, > Pal InfoCom Technologies, > Mohali - India > -- > View this message in context: http://www.nabble.com/Problem-in-MRP-tp25339749p25339749.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Problem in MRP
|
|
Hi Jacopo
In MRP Log, application automatically assigns the Job Id , Job name. but after we refresh that page it fails that mrp by dsiplaying its Status Id as "failed" but if i want to see the Inventory events it displays the follwing data : Type Desc Date Qty. Total [RubberBasket] Raw material ] Facility: 10030 4550 Minimum Stock: 5507 Reorder Quantity: 1000 Days To Ship: Manufacturing Order requirement 10147-10148 2009-08-18 16:23:26. -30 4520 where rubber basket is the raw material for finished good - basket ball, minimum stock , reorder qty. are the values set through Product--> Facility tab. Unable to understand how is it taking the Manufactuing Order requirement values. Also please help that how will requirements be created under Order Module --> Requirements for raw material when it will reach its minimum stock. We are using current version of Ofbiz - 9.04 Looking for your advise Thanks and regards, > Preeti Verma > > Configurator cum Business Analyst : OFBiz Projects , > Pal InfoCom Technologies, > Mohali - India >
|
|
|
If it fails, then the data that you see in the screen doesn't belong
to this run, but to the last successful one. I'd suggest to look at the OFBiz log and see what is the error thrown there when the MRP fails... if you can send the relevant portion of it I may have a look at it Jacopo On Sep 8, 2009, at 9:33 AM, Pal InfoCom Technologies wrote: > > Hi Jacopo > > In MRP Log, application automatically assigns the Job Id , Job name. > but > after we refresh that page it fails that mrp by dsiplaying its > Status Id as > "failed" > > but if i want to see the Inventory events it displays the follwing > data : > > Type > Desc Date > Qty. Total > > [RubberBasket] Raw material ] Facility: 10030 > 4550 > Minimum Stock: 5507 > Reorder Quantity: 1000 > Days To Ship: > > > Manufacturing Order requirement > 10147-10148 2009-08-18 16:23:26. -30 4520 > > > where rubber basket is the raw material for finished good - basket > ball, > minimum stock , reorder qty. are the values set through Product--> > Facility > tab. Unable to understand how is it taking the Manufactuing Order > requirement values. > > Also please help that how will requirements be created under Order > Module > --> Requirements for raw material when it will reach its minimum > stock. > > We are using current version of Ofbiz - 9.04 > > Looking for your advise > > Thanks and regards, >> Preeti Verma >> >> Configurator cum Business Analyst : OFBiz Projects , >> Pal InfoCom Technologies, >> Mohali - India >> > > > > Jacopo Cappellato-4 wrote: >> >> Hi Ajay, >> >> On Sep 8, 2009, at 6:17 AM, Pal InfoCom Technologies wrote: >> >>> >>> Hello All, >>> >>> We are facing a problem in creating requirements for raw material. >>> We >>> have set the Requirement Method Enum Id as 'Requirement for order >>> when ATP >>> Reaches Minimum Stock for Product Facility' >> >> the above is not required when you use MRP >> >>> and set the Minimum Stock and >>> Reorder Quantity and Days to Ship through Product---->Facilities >>> tab. Now >>> after running MRP through Manufacturing Inventory Event is planned. >>> but we >>> didn't find any entry for Requirements in Order---> Requirements >>> tab. >>> >> >> What is the content of the MRP log screen? Do you have inventory on >> hand for that product? What OFBiz version are you using? >> >> Cheers, >> >> Jacopo >> >>> >>> Please suggest any solution to this problem. >>> >>> -- >>> Thanks and regards, >>> Ajay Sodhi >>> >>> Software Engineer, >>> Pal InfoCom Technologies, >>> Mohali - India >>> -- >>> View this message in context: >>> http://www.nabble.com/Problem-in-MRP-tp25339749p25339749.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >> >> >> > > -- > View this message in context: http://www.nabble.com/Problem-in-MRP-tp25339749p25341165.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Problem in MRP
|
|
Hi Jacopo I have created a sales order and scheduled a sales shipment for that order after approval of order requirement created under Order Manager -->Requirements and Shipment Plan created under Manufacturing --> Shipment Plan which is absolutely fine, but on click , Shipment Id throws exception. After that I did Bom simulation and exploded the BOM for product id basket ball (finished good whose sale order for qty= 6000.). Now the raw material required to produce was not sufficient in inventory then I then check the requirements through Order Manager, if requirements would have automatically created to purchase the raw material required to produce the basket ball. but I didn't find any requirement. Then I run MRP for facility(having common facility for raw material and finished good). It was pending. but when i again refresh the page it failed and throw following exception at ofbiz log [java] 2009-09-10 12:53:50,153 (http-0.0.0.0-8443-2) [ ControlServlet.java:130:INFO ] [[[FindInventoryEventPlan] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] [java] 2009-09-10 12:53:50,231 (http-0.0.0.0-8443-2) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.0010s, 17 requests, 13 views in file:/home/Preeti/ofbiz-release9.04/framework/common/webcommon/WEB-INF/common-controller.xml [java] 2009-09-10 12:53:50,237 (http-0.0.0.0-8443-2) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.027s, 148 requests, 69 views in jndi:/0.0.0.0/manufacturing/WEB-INF/controller.xml [java] 2009-09-10 12:53:50,547 (http-0.0.0.0-8443-2) [ RequestHandler.java:692:INFO ] Rendering View [FindMrpPlannedEvents], sessionId=4E8FD11409674FBBD834A034964B7443.jvm1 [java] 2009-09-10 12:53:50,593 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 3 screens in 0.04s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/MrpScreens.xml [java] 2009-09-10 12:53:50,789 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.035s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/CommonScreens.xml [java] 2009-09-10 12:53:50,822 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.025s from: file:/home/Preeti/ofbiz-release9.04/applications/commonext/widget/CommonScreens.xml [java] 2009-09-10 12:53:50,930 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 22 screens in 0.027s from: file:/home/Preeti/ofbiz-release9.04/framework/common/widget/CommonScreens.xml [java] 2009-09-10 12:53:51,132 (http-0.0.0.0-8443-2) [ ServiceDispatcher.java:584:INFO ] Sync service [manufacturing/getVisualThemeResources] finished in [195] milliseconds [java] 2009-09-10 12:53:51,565 (http-0.0.0.0-8443-2) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:53:51,568 (http-0.0.0.0-8443-2) [ ModelForm.java:1368:INFO ] preparePager: Found rows = 4 [java] 2009-09-10 12:53:51,641 (http-0.0.0.0-8443-2) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:53:51,643 (http-0.0.0.0-8443-2) [ ModelForm.java:1368:INFO ] preparePager: Found rows = -1 [java] 2009-09-10 12:53:51,996 (http-0.0.0.0-8443-2) [ ControlServlet.java:299:INFO ] [[[FindInventoryEventPlan] Request Done- total:1.842,since last([FindInventoryEve...):1.842]] [java] 2009-09-10 12:55:01,463 (http-0.0.0.0-8443-1) [ ControlServlet.java:130:INFO ] [[[FindInventoryEventPlan] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] [java] 2009-09-10 12:55:01,516 (http-0.0.0.0-8443-1) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.0010s, 17 requests, 13 views in file:/home/Preeti/ofbiz-release9.04/framework/common/webcommon/WEB-INF/common-controller.xml [java] 2009-09-10 12:55:01,523 (http-0.0.0.0-8443-1) [ ConfigXMLReader.java:118:INFO ] controller loaded: 0.022s, 148 requests, 69 views in jndi:/0.0.0.0/manufacturing/WEB-INF/controller.xml [java] 2009-09-10 12:55:01,529 (http-0.0.0.0-8443-1) [ RequestHandler.java:692:INFO ] Rendering View [FindMrpPlannedEvents], sessionId=4E8FD11409674FBBD834A034964B7443.jvm1 [java] 2009-09-10 12:55:01,564 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 3 screens in 0.029s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/MrpScreens.xml [java] 2009-09-10 12:55:01,755 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.025s from: file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/widget/manufacturing/CommonScreens.xml [java] 2009-09-10 12:55:01,806 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 1 screens in 0.041s from: file:/home/Preeti/ofbiz-release9.04/applications/commonext/widget/CommonScreens.xml [java] 2009-09-10 12:55:01,915 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 22 screens in 0.067s from: file:/home/Preeti/ofbiz-release9.04/framework/common/widget/CommonScreens.xml [java] 2009-09-10 12:55:01,977 (http-0.0.0.0-8443-1) [ ServiceDispatcher.java:584:INFO ] Sync service [manufacturing/getVisualThemeResources] finished in [55] milliseconds [java] 2009-09-10 12:55:02,329 (http-0.0.0.0-8443-1) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:55:02,332 (http-0.0.0.0-8443-1) [ ModelForm.java:1368:INFO ] preparePager: Found rows = 4 [java] 2009-09-10 12:55:02,400 (http-0.0.0.0-8443-1) [ ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 [java] 2009-09-10 12:55:02,402 (http-0.0.0.0-8443-1) [ ModelForm.java:1368:INFO ] preparePager: Found rows = -1 [java] 2009-09-10 12:55:02,904 (http-0.0.0.0-8443-1) [ ControlServlet.java:299:INFO ] [[[FindInventoryEventPlan] Request Done- total:1.44,since last([FindInventoryEve...):1.44]] Thanks Preeti Verma
|
|
|
Hi,
unfortunately the log you sent is not what we need. Please search in you log a line similar to: ServiceDispatcher.java:607:INFO ] [[ASync service started...- total: 0.0,since last(Begin):0.0]] - 'manufacturing / executeMrp' and then send the errors that you see happening from there on. Jacopo On Sep 10, 2009, at 10:32 AM, Pal InfoCom Technologies wrote: > > > Hi Jacopo > > I have created a sales order and scheduled a sales shipment for that > order > after approval of order requirement created under Order Manager > -->Requirements and Shipment Plan created under Manufacturing --> > Shipment > Plan which is absolutely fine, but on click , Shipment Id throws > exception. > > After that I did Bom simulation and exploded the BOM for product id > basket > ball (finished good whose sale order for qty= 6000.). Now the raw > material > required to produce was not sufficient in inventory then I then > check the > requirements through Order Manager, if requirements would have > automatically > created to purchase the raw material required to produce the basket > ball. > but I didn't find any requirement. Then I run MRP for > facility(having common > facility for raw material and finished good). It was pending. but > when i > again refresh the page it failed and throw following exception at > ofbiz log > > > [java] 2009-09-10 12:53:50,153 (http-0.0.0.0-8443-2) [ > ControlServlet.java:130:INFO ] [[[FindInventoryEventPlan] Request > Begun, > encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] > [java] 2009-09-10 12:53:50,231 (http-0.0.0.0-8443-2) [ > ConfigXMLReader.java:118:INFO ] controller loaded: 0.0010s, 17 > requests, 13 > views in > file:/home/Preeti/ofbiz-release9.04/framework/common/webcommon/WEB- > INF/common-controller.xml > [java] 2009-09-10 12:53:50,237 (http-0.0.0.0-8443-2) [ > ConfigXMLReader.java:118:INFO ] controller loaded: 0.027s, 148 > requests, 69 > views in jndi:/0.0.0.0/manufacturing/WEB-INF/controller.xml > [java] 2009-09-10 12:53:50,547 (http-0.0.0.0-8443-2) [ > RequestHandler.java:692:INFO ] Rendering View [FindMrpPlannedEvents], > sessionId=4E8FD11409674FBBD834A034964B7443.jvm1 > [java] 2009-09-10 12:53:50,593 (http-0.0.0.0-8443-2) [ > ScreenFactory.java:129:INFO ] Got 3 screens in 0.04s from: > file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/ > widget/manufacturing/MrpScreens.xml > [java] 2009-09-10 12:53:50,789 (http-0.0.0.0-8443-2) [ > ScreenFactory.java:129:INFO ] Got 1 screens in 0.035s from: > file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/ > widget/manufacturing/CommonScreens.xml > [java] 2009-09-10 12:53:50,822 (http-0.0.0.0-8443-2) [ > ScreenFactory.java:129:INFO ] Got 1 screens in 0.025s from: > file:/home/Preeti/ofbiz-release9.04/applications/commonext/widget/ > CommonScreens.xml > [java] 2009-09-10 12:53:50,930 (http-0.0.0.0-8443-2) [ > ScreenFactory.java:129:INFO ] Got 22 screens in 0.027s from: > file:/home/Preeti/ofbiz-release9.04/framework/common/widget/ > CommonScreens.xml > [java] 2009-09-10 12:53:51,132 (http-0.0.0.0-8443-2) [ > ServiceDispatcher.java:584:INFO ] Sync service > [manufacturing/getVisualThemeResources] finished in [195] milliseconds > [java] 2009-09-10 12:53:51,565 (http-0.0.0.0-8443-2) [ > ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 > [java] 2009-09-10 12:53:51,568 (http-0.0.0.0-8443-2) [ > ModelForm.java:1368:INFO ] preparePager: Found rows = 4 > [java] 2009-09-10 12:53:51,641 (http-0.0.0.0-8443-2) [ > ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 > [java] 2009-09-10 12:53:51,643 (http-0.0.0.0-8443-2) [ > ModelForm.java:1368:INFO ] preparePager: Found rows = -1 > [java] 2009-09-10 12:53:51,996 (http-0.0.0.0-8443-2) [ > ControlServlet.java:299:INFO ] [[[FindInventoryEventPlan] Request > Done- > total:1.842,since last([FindInventoryEve...):1.842]] > [java] 2009-09-10 12:55:01,463 (http-0.0.0.0-8443-1) [ > ControlServlet.java:130:INFO ] [[[FindInventoryEventPlan] Request > Begun, > encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] > [java] 2009-09-10 12:55:01,516 (http-0.0.0.0-8443-1) [ > ConfigXMLReader.java:118:INFO ] controller loaded: 0.0010s, 17 > requests, 13 > views in > file:/home/Preeti/ofbiz-release9.04/framework/common/webcommon/WEB- > INF/common-controller.xml > [java] 2009-09-10 12:55:01,523 (http-0.0.0.0-8443-1) [ > ConfigXMLReader.java:118:INFO ] controller loaded: 0.022s, 148 > requests, 69 > views in jndi:/0.0.0.0/manufacturing/WEB-INF/controller.xml > [java] 2009-09-10 12:55:01,529 (http-0.0.0.0-8443-1) [ > RequestHandler.java:692:INFO ] Rendering View [FindMrpPlannedEvents], > sessionId=4E8FD11409674FBBD834A034964B7443.jvm1 > [java] 2009-09-10 12:55:01,564 (http-0.0.0.0-8443-1) [ > ScreenFactory.java:129:INFO ] Got 3 screens in 0.029s from: > file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/ > widget/manufacturing/MrpScreens.xml > [java] 2009-09-10 12:55:01,755 (http-0.0.0.0-8443-1) [ > ScreenFactory.java:129:INFO ] Got 1 screens in 0.025s from: > file:/home/Preeti/ofbiz-release9.04/applications/manufacturing/ > widget/manufacturing/CommonScreens.xml > [java] 2009-09-10 12:55:01,806 (http-0.0.0.0-8443-1) [ > ScreenFactory.java:129:INFO ] Got 1 screens in 0.041s from: > file:/home/Preeti/ofbiz-release9.04/applications/commonext/widget/ > CommonScreens.xml > [java] 2009-09-10 12:55:01,915 (http-0.0.0.0-8443-1) [ > ScreenFactory.java:129:INFO ] Got 22 screens in 0.067s from: > file:/home/Preeti/ofbiz-release9.04/framework/common/widget/ > CommonScreens.xml > [java] 2009-09-10 12:55:01,977 (http-0.0.0.0-8443-1) [ > ServiceDispatcher.java:584:INFO ] Sync service > [manufacturing/getVisualThemeResources] finished in [55] milliseconds > [java] 2009-09-10 12:55:02,329 (http-0.0.0.0-8443-1) [ > ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 > [java] 2009-09-10 12:55:02,332 (http-0.0.0.0-8443-1) [ > ModelForm.java:1368:INFO ] preparePager: Found rows = 4 > [java] 2009-09-10 12:55:02,400 (http-0.0.0.0-8443-1) [ > ModelForm.java:1350:INFO ] preparePager: low - high = 0 - 20 > [java] 2009-09-10 12:55:02,402 (http-0.0.0.0-8443-1) [ > ModelForm.java:1368:INFO ] preparePager: Found rows = -1 > [java] 2009-09-10 12:55:02,904 (http-0.0.0.0-8443-1) [ > ControlServlet.java:299:INFO ] [[[FindInventoryEventPlan] Request > Done- > total:1.44,since last([FindInventoryEve...):1.44]] > > > Thanks > > Preeti Verma > > > > Jacopo Cappellato-4 wrote: >> >> If it fails, then the data that you see in the screen doesn't belong >> to this run, but to the last successful one. >> I'd suggest to look at the OFBiz log and see what is the error thrown >> there when the MRP fails... if you can send the relevant portion of >> it >> I may have a look at it >> >> Jacopo >> >> >> On Sep 8, 2009, at 9:33 AM, Pal InfoCom Technologies wrote: >> >>> >>> Hi Jacopo >>> >>> In MRP Log, application automatically assigns the Job Id , Job name. >>> but >>> after we refresh that page it fails that mrp by dsiplaying its >>> Status Id as >>> "failed" >>> >>> but if i want to see the Inventory events it displays the follwing >>> data : >>> >>> Type >>> Desc Date >>> Qty. Total >>> >>> [RubberBasket] Raw material ] Facility: 10030 >>> 4550 >>> Minimum Stock: 5507 >>> Reorder Quantity: 1000 >>> Days To Ship: >>> >>> >>> Manufacturing Order requirement >>> 10147-10148 2009-08-18 16:23:26. -30 4520 >>> >>> >>> where rubber basket is the raw material for finished good - basket >>> ball, >>> minimum stock , reorder qty. are the values set through Product--> >>> Facility >>> tab. Unable to understand how is it taking the Manufactuing Order >>> requirement values. >>> >>> Also please help that how will requirements be created under Order >>> Module >>> --> Requirements for raw material when it will reach its minimum >>> stock. >>> >>> We are using current version of Ofbiz - 9.04 >>> >>> Looking for your advise >>> >>> Thanks and regards, >>>> Preeti Verma >>>> >>>> Configurator cum Business Analyst : OFBiz Projects , >>>> Pal InfoCom Technologies, >>>> Mohali - India >>>> >>> >>> >>> >>> Jacopo Cappellato-4 wrote: >>>> >>>> Hi Ajay, >>>> >>>> On Sep 8, 2009, at 6:17 AM, Pal InfoCom Technologies wrote: >>>> >>>>> >>>>> Hello All, >>>>> >>>>> We are facing a problem in creating requirements for raw material. >>>>> We >>>>> have set the Requirement Method Enum Id as 'Requirement for order >>>>> when ATP >>>>> Reaches Minimum Stock for Product Facility' >>>> >>>> the above is not required when you use MRP >>>> >>>>> and set the Minimum Stock and >>>>> Reorder Quantity and Days to Ship through Product---->Facilities >>>>> tab. Now >>>>> after running MRP through Manufacturing Inventory Event is >>>>> planned. >>>>> but we >>>>> didn't find any entry for Requirements in Order---> Requirements >>>>> tab. >>>>> >>>> >>>> What is the content of the MRP log screen? Do you have inventory on >>>> hand for that product? What OFBiz version are you using? >>>> >>>> Cheers, >>>> >>>> Jacopo >>>> >>>>> >>>>> Please suggest any solution to this problem. >>>>> >>>>> -- >>>>> Thanks and regards, >>>>> Ajay Sodhi >>>>> >>>>> Software Engineer, >>>>> Pal InfoCom Technologies, >>>>> Mohali - India >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/Problem-in-MRP-tp25339749p25339749.html >>>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>>> >>>> >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Problem-in-MRP-tp25339749p25341165.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >> >> >> > > -- > View this message in context: http://www.nabble.com/Problem-in-MRP-tp25339749p25379365.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Problem in MRP
|
|
Hi Jacopo
It doesn't throw any exception at ofbiz log as action is performing successfully(No error messages at screen), when we run the mrp it displays under 'Scheduled or running Jobs' panel, Status as pending but when we refresh the page, displays ' Last Job' panel and Status Id as Failed. Screenshot is attached herewith for your reference Thanks Preeti mrp+run.jpg
|
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |