[jira] Created: (OFBIZ-714) Adding a product to an existing order -> Marketing Package Error

[Nicolas Malin (Jira)]

Adding a product to an existing order -> Marketing Package Error
----------------------------------------------------------------

                 Key: OFBIZ-714
                 URL: https://issues.apache.org/jira/browse/OFBIZ-714
             Project: OFBiz (The Open for Business Project)
          Issue Type: Bug
          Components: accounting, manufacturing, order
    Affects Versions: SVN trunk
         Environment: near svn with Financials
            Reporter: Daniel Kunkel


Adding another product to an order with a marketing component product that has been created causes significant mixups in accounting, manufacturing and inventory.

Jumping ahead, it seems that when another product is added to a created order which includes a marketing package, the marketing package is partially manufactured again. The manufacturing doesn't complete correcting causing inventory and accouting discrepencies.
(too few units manufactured, causing a backorder status in a marketing componet with ample inventory, and unbalanced work-in-progress accounting)

Steps to recreate:

1.)  Order a marketing component item
2.) Create the order
# Accounting will be correct at this point.
3.) Add an addition product (in my case, a simple product)
# Accounting and inventory are now unbalanced.




--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Scott Gray reassigned OFBIZ-714:
--------------------------------

    Assignee: Scott Gray

> Adding a product to an existing order -> Marketing Package Error
> ----------------------------------------------------------------
>
>                 Key: OFBIZ-714
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-714
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting, manufacturing, order
>    Affects Versions: SVN trunk
>         Environment: near svn with Financials
>            Reporter: Daniel Kunkel
>            Assignee: Scott Gray
>
> Adding another product to an order with a marketing component product that has been created causes significant mixups in accounting, manufacturing and inventory.
> Jumping ahead, it seems that when another product is added to a created order which includes a marketing package, the marketing package is partially manufactured again. The manufacturing doesn't complete correcting causing inventory and accouting discrepencies.
> (too few units manufactured, causing a backorder status in a marketing componet with ample inventory, and unbalanced work-in-progress accounting)
> Steps to recreate:
> 1.)  Order a marketing component item
> 2.) Create the order
> # Accounting will be correct at this point.
> 3.) Add an addition product (in my case, a simple product)
> # Accounting and inventory are now unbalanced.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12538278 ]

Scott Gray commented on OFBIZ-714:
----------------------------------

Hi Daniel

When you get a chance could you clarify exactly what the inventory and accounting discrepancies are (not financials though OFBiz only), I haven't looked into it yet, but it will help to be able to see the problem when I try to recreate it.

Thanks

> Adding a product to an existing order -> Marketing Package Error
> ----------------------------------------------------------------
>
>                 Key: OFBIZ-714
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-714
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting, manufacturing, order
>    Affects Versions: SVN trunk
>         Environment: near svn with Financials
>            Reporter: Daniel Kunkel
>            Assignee: Scott Gray
>
> Adding another product to an order with a marketing component product that has been created causes significant mixups in accounting, manufacturing and inventory.
> Jumping ahead, it seems that when another product is added to a created order which includes a marketing package, the marketing package is partially manufactured again. The manufacturing doesn't complete correcting causing inventory and accouting discrepencies.
> (too few units manufactured, causing a backorder status in a marketing componet with ample inventory, and unbalanced work-in-progress accounting)
> Steps to recreate:
> 1.)  Order a marketing component item
> 2.) Create the order
> # Accounting will be correct at this point.
> 3.) Add an addition product (in my case, a simple product)
> # Accounting and inventory are now unbalanced.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Scott Gray closed OFBIZ-714.
----------------------------

    Resolution: Fixed

This should be fixed in rev. 590004, I tested a few different scenarios and they seemed to work out ok.  

Here's the commit log:
A few changes to the way auto marketing packages are handled:
1.  No longer producing for the current order only, all orders are taken into account, so we're now trying to produce whatever will get the ATP back to zero.
2.  Only producing what the available components will allow, ie. if we need to produce 10 units but only have enough components to for 5 then that's all we'll produce.
3.  Because of (1) no longer associating the production run to the order item via WorkOrderItemFulfillment.
4.  Moved the call to createProductionRunForMktgPackage so that it is called when an order is edited as well (Fixes OFBIZ-714, the marketing package was decomposed when cancelling inventory reservations but not reproduced afterwards).

> Adding a product to an existing order -> Marketing Package Error
> ----------------------------------------------------------------
>
>                 Key: OFBIZ-714
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-714
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting, manufacturing, order
>    Affects Versions: SVN trunk
>         Environment: near svn with Financials
>            Reporter: Daniel Kunkel
>            Assignee: Scott Gray
>
> Adding another product to an order with a marketing component product that has been created causes significant mixups in accounting, manufacturing and inventory.
> Jumping ahead, it seems that when another product is added to a created order which includes a marketing package, the marketing package is partially manufactured again. The manufacturing doesn't complete correcting causing inventory and accouting discrepencies.
> (too few units manufactured, causing a backorder status in a marketing componet with ample inventory, and unbalanced work-in-progress accounting)
> Steps to recreate:
> 1.)  Order a marketing component item
> 2.) Create the order
> # Accounting will be correct at this point.
> 3.) Add an addition product (in my case, a simple product)
> # Accounting and inventory are now unbalanced.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539871 ]

Daniel Kunkel commented on OFBIZ-714:
-------------------------------------

Hi

I could if you're ok with results from an old version... but it's
probably going to be a few weeks.  I think I described the steps pretty
clearly though, and I expect it won't be any problem to recreate.

> Adding a product to an existing order -> Marketing Package Error
> ----------------------------------------------------------------
>
>                 Key: OFBIZ-714
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-714
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting, manufacturing, order
>    Affects Versions: SVN trunk
>         Environment: near svn with Financials
>            Reporter: Daniel Kunkel
>            Assignee: Scott Gray
>
> Adding another product to an order with a marketing component product that has been created causes significant mixups in accounting, manufacturing and inventory.
> Jumping ahead, it seems that when another product is added to a created order which includes a marketing package, the marketing package is partially manufactured again. The manufacturing doesn't complete correcting causing inventory and accouting discrepencies.
> (too few units manufactured, causing a backorder status in a marketing componet with ample inventory, and unbalanced work-in-progress accounting)
> Steps to recreate:
> 1.)  Order a marketing component item
> 2.) Create the order
> # Accounting will be correct at this point.
> 3.) Add an addition product (in my case, a simple product)
> # Accounting and inventory are now unbalanced.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.