0036509: [MRP] It is not possible to use a product set as production and purchase at the same time

Description

[MRP] It is not possible to use a product set as production and purchase at the same time

In a scenario with multiple organizations, sometimes 1 organization will
produce a product and a separate organization will purchase it from the
first organization. Therefore the product is both produced and purchased.
But if both checkbox are ticked, the Manufacturing plan will not work.

Check the following code of MRP_RUN_INITIALIZE database function that is called from different places:

AND ((p_production = 'Y' AND p.ispurchased = 'N') OR (p_production = 'N' AND p.ispurchased = 'Y'))

Steps To Reproduce

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0098118) ngarcia (developer) 2017-07-18 16:28	Maarten says: In multi-org / multi-outlet/warehouse environment, the decision how/where to procure a product is on warehouse level and also can change in time. This means that we should allow purchase and distribution and manufacture synchronous. Use-Cases: - A central DC can purchase in bulk, repack it to finished product (=manufacture) and distribute it to the outlets (Distribution Orders functionality, to be released 17Q4): Product is manufactured and distributed-out. - Sometimes the outlets have excess inventory and the central DC will re-distribute it. So the DC will distribute-in and distribute-out to different outlets. - An outlet will normally get it through the Distribution Order, but sometimes will need to purchase it if the DC is out of stock: Both PO and DO should be possible at the same time on outlet-level.

Issue History
Date Modified	Username	Field	Change
2017-07-18 16:27	ngarcia	New Issue
2017-07-18 16:27	ngarcia	Assigned To	=> Triage Finance
2017-07-18 16:27	ngarcia	Modules	=> Core
2017-07-18 16:27	ngarcia	Triggers an Emergency Pack	=> No
2017-07-18 16:28	ngarcia	Note Added: 0098118