[jira] [Created] (OFBIZ-5245) There is any way to differentiate assembly and disassembly associations in OpenTaps?

["Luca (JIRA)" <ji...@apache.org>]

Luca created OFBIZ-5245:
---------------------------

             Summary: There is any way to differentiate assembly and disassembly associations in OpenTaps?
                 Key: OFBIZ-5245
                 URL: https://issues.apache.org/jira/browse/OFBIZ-5245
             Project: OFBiz
          Issue Type: Bug
            Reporter: Luca
            Priority: Blocker


Caffe Parigi is a caffe restaurant based in Dublin. We made a decision right at the start to use and try to help develop OpenTaps.

We currently use OpenTaps for the following:
Place an order to our supplier
Received the goods in the inventory and therefore increase the stock (quantity and value)
Manage the vendor invoices and payments
Issue sales invoice (without creating a sales order yet)
Manage the customer payments
Financial and Accounting in general
CRM 

The Catalogue contains sales and purchasing products.
The main difference that we have among the sales products is that we sell some of them as we buy (ie: cans of coke) then we also have products that we produce combining two or more ingredients (ie: Paninis and Pastas)
For what concern the purchasing products we set the product type as “Purchasing Package” then we associated them with a product that we are going to use as part of the sales product BOM.

The reason is that when we buy  products from our suppliers they come in a case but we sell as unit therefore we want to increase (when we buy) and decrease (when we sell) out stock quantities by unit no fractions of package, therefore we set up our products as follow:

canofcoke-pkg (the product that we buy/produce which contain all the supplier/product details)
canofcoke-unit (which is associated to canofcoke-pkg - association type “Manufacturing Bill of Material” and it is a component of the sales product) 
canofcoke (it is the sales product)
We buy 1 canofcoke-pkg then thanks to a default disassembly task this will be converted in 24 canofcoke-unit (in the inventory the quantity for canofcoke-pkg is always 0) 

As I said above we are not creating the sales order because as you know in order to convert the sales order in to a sales invoice we need to “Pack” and “Ship” the same and to do so we need to have in stock the product that we are going to sell, therefore we need to make a production run for all the home-made products that we sell.

Currently we are able to perform the full process from creating a sales order to the customer payment for products like cans of coke but for product like Pastas which has an articulated BOM when we try to make a production run we are faced with the following issue:

Our goal is produce and sell Pasta Arrabbiata (this is the sales product name)

Pasta Arrabbiata BOM is:
100 gr. Penne-unit 
150 ml.Tomatosauce-unit
			
First thing in the morning the chefs prepare a big batch of tomato sauce called in the catalogue: Tomatosauce-pkg (prod. Type Purchasing Package) which we would like to disassembly to 8000 Tomatosauce-unit (prod. Type Finished good) because following the coke example we will use it as a component of Pasta Arrabbiata BOM (rather to use a fraction of Tomatosauce-pkg) therefore we set the association between Tomatosauce-pkg and 8000 Tomatosauce-unit as “Manufacturing Bill of Material”.
The problem is that this association will be seen as a component of the BOM when we start the production run for Tomatosauce-pkg 

What we would expect to see is:
Tomatosauce-pkg BOM:
9600 gr. choppedtomato-unit
200   gr. oliveoil-unit
100   gr. salt-unit
As soon we close the production run for 1 Tomatosauce-pkg should be converted in 8000 gr. Tomatosauce-unit

What we actually see is:
Tomatosauce-pkg BOM:
8000 gr. Tomatosauce-unit
9600 gr. choppedtomato-unit
200   gr. oliveoil-unit
100   gr. salt-unit
This means that in order to produce 1 Tomatosauce-pkg we need 8000 gr. of Tomatosauce-unit .... 

The problem is that with this product configuration the system doesn't understand the difference between the disassembly association (between Tomatosauce-pkg and  8000  Tomatosauce-unit) and  the assembly association (between Tomatosauce-pkg and choppedtomato-unit/oliveoil-unit/etc.)

Does OpenTaps behave like that because I've selected the wrong association type?

Could you explain me what should I change?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira