Requirements are not created for sales order
Locked
 
|
Hello, for my company I am trying to setup a productive instance of OFBiz 17.12. So far I have created the company, catalog and categories, a warehouse and a supplier for products. When I now create a sales order for a product and execute the "Run MRP" OFBiz does not create requirements for the raw materials of the product to create purchase orders for the supplier. What could be the Problem? The "FINISHED_GOOD" which is sold is a manufacturing bill of material. The inventory option for the "RAW_MATERIAL"s is set to "When QOH Reaches Minimum Stock for Product-Facility". Both the finished good and the raw materials are linked to the warehouse with the "Minimum Stock" set to zero, since we are producing on order. The "FINISHED_GOOD" is also linked to a category which has a parent category. These parent category is linked to a catalaog which is associated to a product store also referencing the warehouse. Best regards, Raynhold
------------------------------------------------------------------------------------------------- FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT |
Re: Requirements are not created for sales order
|
|
Hi,
Please check any error occurs in Run MRP workflow if not getting any error please verify the ProductFacility record is created correctly and also verify that MrpEvent data is created in the system by MRP workflow. Thanks & Regards -- Yashwant Dhakad On Wed, Oct 23, 2019 at 12:07 PM <[hidden email]> wrote: > Hello, for my company I am trying to setup a productive instance of > OFBiz 17.12. So far I have created the company, catalog and categories, a > warehouse and a supplier for products. When I now create a sales order for > a product and execute the "Run MRP" OFBiz does not create requirements for > the raw materials of the product to create purchase orders for the > supplier. What could be the Problem? The "FINISHED_GOOD" which is sold is > a manufacturing bill of material. The inventory option for the > "RAW_MATERIAL"s is set to "When QOH Reaches Minimum Stock for > Product-Facility". Both the finished good and the raw materials are linked > to the warehouse with the "Minimum Stock" set to zero, since we are > producing on order. The "FINISHED_GOOD" is also linked to a category which > has a parent category. These parent category is linked to a catalaog which > is associated to a product store also referencing the warehouse. Best > regards, Raynhold > > > ------------------------------------------------------------------------------------------------- > FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT > |
|
|
Hi Yashwant, thank your for your reply. I checked that there are records for the ProductFacility entity. Also, the Run MRP works without a problem, throws no exceptions. But MrpEvents are not created, there are no records for them. Are they deleted from the database when the event finishes? I got it at least to create a requierement for the finished good which is sold, but that solves not my case that i need the requirements for the raw materials. Are there other points I need to look for? Best regards, Raynhold
Am 23-Oct-2019 11:00:21 +0200 schrieb [hidden email]: Hi, Please check any error occurs in Run MRP workflow if not getting any error please verify the ProductFacility record is created correctly and also verify that MrpEvent data is created in the system by MRP workflow. Thanks & Regards -- Yashwant Dhakad On Wed, Oct 23, 2019 at 12:07 PM wrote: > Hello, for my company I am trying to setup a productive instance of > OFBiz 17.12. So far I have created the company, catalog and categories, a > warehouse and a supplier for products. When I now create a sales order for > a product and execute the "Run MRP" OFBiz does not create requirements for > the raw materials of the product to create purchase orders for the > supplier. What could be the Problem? The "FINISHED_GOOD" which is sold is > a manufacturing bill of material. The inventory option for the > "RAW_MATERIAL"s is set to "When QOH Reaches Minimum Stock for > Product-Facility". Both the finished good and the raw materials are linked > to the warehouse with the "Minimum Stock" set to zero, since we are > producing on order. The "FINISHED_GOOD" is also linked to a category which > has a parent category. These parent category is linked to a catalaog which > is associated to a product store also referencing the warehouse. Best > regards, Raynhold > > > ------------------------------------------------------------------------------------------------- > FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT > ------------------------------------------------------------------------------------------------- FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT |
Re: Requirements are not created for sales order
Administrator
|
Hi Raynhold,
As I'm not sure you are aware about it, you may find this book useful: https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books#OFBizRelatedBooks-GettingStartedwithApacheOFBizManufacturing At p. 64 I read: <<A product requirement will be created for any recommendation to purchase raw materials from a supplier>> There are more info about product requirement in the book. Maybe not all what you need. Before buying the book (recommended) you can start there: https://cwiki.apache.org/confluence/download/attachments/46632635/Manufacturing5StepGuide.pdf?version=1&modificationDate=1505722113000&api=v2 There is also this page in wiki https://cwiki.apache.org/confluence/display/OFBIZ/Manufacturing Note: at the moment Confluence as an issue https://twitter.com/infrabot/status/1187268216101298176?s=20 HTH Jacques Le 23/10/2019 à 12:11, [hidden email] a écrit : > Hi Yashwant, thank your for your reply. I checked that there are records for the ProductFacility entity. Also, the Run MRP works without a problem, throws no exceptions. But MrpEvents are not created, there are no records for them. Are they deleted from the database when the event finishes? I got it at least to create a requierement for the finished good which is sold, but that solves not my case that i need the requirements for the raw materials. Are there other points I need to look for? Best regards, Raynhold > Am 23-Oct-2019 11:00:21 +0200 schrieb [hidden email]: > Hi, > Please check any error occurs in Run MRP workflow if not getting any error > please verify the ProductFacility record is created correctly and also > verify that MrpEvent data is created in the system by MRP workflow. > > Thanks & Regards > -- > Yashwant Dhakad > > On Wed, Oct 23, 2019 at 12:07 PM wrote: > >> Hello, for my company I am trying to setup a productive instance of >> OFBiz 17.12. So far I have created the company, catalog and categories, a >> warehouse and a supplier for products. When I now create a sales order for >> a product and execute the "Run MRP" OFBiz does not create requirements for >> the raw materials of the product to create purchase orders for the >> supplier. What could be the Problem? The "FINISHED_GOOD" which is sold is >> a manufacturing bill of material. The inventory option for the >> "RAW_MATERIAL"s is set to "When QOH Reaches Minimum Stock for >> Product-Facility". Both the finished good and the raw materials are linked >> to the warehouse with the "Minimum Stock" set to zero, since we are >> producing on order. The "FINISHED_GOOD" is also linked to a category which >> has a parent category. These parent category is linked to a catalaog which >> is associated to a product store also referencing the warehouse. Best >> regards, Raynhold >> >> >> ------------------------------------------------------------------------------------------------- >> FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT >> > ------------------------------------------------------------------------------------------------- > FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT > |
|
|
Hi Jacques, thank you for your answer. I own the book already and started to build up on that bit our productgot quite complex with over 200 raw materials and subassemblies. I got it solved by editing the qeuery for "OrderHeaderItemAndShipGroup" in the function "initMrpEvents", cause somehow when i created an order for the product it left the facility id blank. But the product was associated with the facility. Best regards, Raynhold
Am 24-Oct-2019 10:10:48 +0200 schrieb [hidden email]: Hi Raynhold, As I'm not sure you are aware about it, you may find this book useful: https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books#OFBizRelatedBooks-GettingStartedwithApacheOFBizManufacturing At p. 64 I read: There are more info about product requirement in the book. Maybe not all what you need. Before buying the book (recommended) you can start there: https://cwiki.apache.org/confluence/download/attachments/46632635/Manufacturing5StepGuide.pdf?version=1&modificationDate=1505722113000&api=v2 There is also this page in wiki https://cwiki.apache.org/confluence/display/OFBIZ/Manufacturing Note: at the moment Confluence as an issue https://twitter.com/infrabot/status/1187268216101298176?s=20 HTH Jacques Le 23/10/2019 12:11, [hidden email] a crit : > Hi Yashwant, thank your for your reply. I checked that there are records for the ProductFacility entity. Also, the Run MRP works without a problem, throws no exceptions. But MrpEvents are not created, there are no records for them. Are they deleted from the database when the event finishes? I got it at least to create a requierement for the finished good which is sold, but that solves not my case that i need the requirements for the raw materials. Are there other points I need to look for? Best regards, Raynhold > Am 23-Oct-2019 11:00:21 +0200 schrieb [hidden email]: > Hi, > Please check any error occurs in Run MRP workflow if not getting any error > please verify the ProductFacility record is created correctly and also > verify that MrpEvent data is created in the system by MRP workflow. > > Thanks & Regards > -- > Yashwant Dhakad > > On Wed, Oct 23, 2019 at 12:07 PM wrote: > >> Hello, for my company I am trying to setup a productive instance of >> OFBiz 17.12. So far I have created the company, catalog and categories, a >> warehouse and a supplier for products. When I now create a sales order for >> a product and execute the "Run MRP" OFBiz does not create requirements for >> the raw materials of the product to create purchase orders for the >> supplier. What could be the Problem? The "FINISHED_GOOD" which is sold is >> a manufacturing bill of material. The inventory option for the >> "RAW_MATERIAL"s is set to "When QOH Reaches Minimum Stock for >> Product-Facility". Both the finished good and the raw materials are linked >> to the warehouse with the "Minimum Stock" set to zero, since we are >> producing on order. The "FINISHED_GOOD" is also linked to a category which >> has a parent category. These parent category is linked to a catalaog which >> is associated to a product store also referencing the warehouse. Best >> regards, Raynhold >> >> >> ------------------------------------------------------------------------------------------------- >> FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT >> > ------------------------------------------------------------------------------------------------- > FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT > ------------------------------------------------------------------------------------------------- FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |