[jira] Created: (OFBIZ-2198) Inventory showing as 0/0

[Nicolas Malin (Jira)]

Inventory showing as 0/0
-------------------------

                 Key: OFBIZ-2198
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
             Project: OFBiz
          Issue Type: Bug
          Components: product
    Affects Versions: SVN trunk
         Environment: Demo System
            Reporter: Josh Murphy
             Fix For: SVN trunk


Inventory showing 0/0 in edit product and in facility -> inventory

--
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-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12675250#action_12675250 ]

David E. Jones commented on OFBIZ-2198:
---------------------------------------

In the spirit of facilitating communication: could you offer more details? What you have described here is the expected behavior in  some cases, like if there is no inventory data for a product.

You might consider commenting on each of these questions:

1. what did you do? (details, including URLs visited, data entered, etc)
2. what did you expect to happen?
3. what actually happened?

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>             Fix For: SVN trunk
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

--
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-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12675586#action_12675586 ]

Josh Murphy commented on OFBIZ-2198:
------------------------------------

When i create a product, add inventory facility and receive inventory the invemntory item says 1/1 but inventory says 0/0. am i doing something wrong?

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>             Fix For: SVN trunk
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

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

[murp3433]

On the demo site i went to product GZ-1006-2 added both facilities, and received 50. At the bottom under inventory items it shows the 50 but under inventory in the facility and under inventory on the product page it shows 0/0

JIRA [e-mail] wrote

    [ https://issues.apache.org/jira/browse/OFBIZ-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12675586#action_12675586 ]

Josh Murphy commented on OFBIZ-2198:
------------------------------------

When i create a product, add inventory facility and receive inventory the invemntory item says 1/1 but inventory says 0/0. am i doing something wrong?

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>             Fix For: SVN trunk
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

--
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-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676066#action_12676066 ]

Josh Murphy commented on OFBIZ-2198:
------------------------------------

On the demo site i went to product GZ-1006-2 added both facilities, and received 50. At the bottom under inventory items it shows the 50 but under inventory in the facility and under inventory on the product page it shows 0/0. Shouldnt it show 50/50?

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>             Fix For: SVN trunk
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

--
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-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676744#action_12676744 ]

Jacques Le Roux commented on OFBIZ-2198:
----------------------------------------

Did you see some "obvious" errors in the log ?

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>             Fix For: SVN trunk
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

--
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-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathy jones updated OFBIZ-2198:
-------------------------------

    Attachment: getproductinventorybyavailable.patch

As per discussion in  mailing list, ATP/QOH shows 0/0. But now its working perfectly fine

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>             Fix For: SVN trunk
>
>         Attachments: getproductinventorybyavailable.patch
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

--
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-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12677391#action_12677391 ]

Josh Murphy commented on OFBIZ-2198:
------------------------------------

Thanks Kathy, It works great!

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>             Fix For: SVN trunk
>
>         Attachments: getproductinventorybyavailable.patch
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

--
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-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-2198.
----------------------------------

    Resolution: Fixed
      Assignee: Jacques Le Roux

Kathy,

It seems that you copied from R4. But you forgot to copy (at least in patch since you seem to get the right result)
        <set from-field="parameters.inventoryItemId" field="lookupFieldMap.inventoryItemId"/>
        <set from-field="parameters.productId" field="lookupFieldMap.productId"/>
        <set from-field="parameters.facilityId" field="lookupFieldMap.facilityId"/>
        <set from-field="parameters.locationSeqId" field="lookupFieldMap.locationSeqId"/>
        <set from-field="parameters.containerId" field="lookupFieldMap.containerId"/>

so the result was wrong when applynig your patch (1631 instead of 1000)

I came with a mix of the 2 code snippets. Please see revision 748589.

Thanks

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>            Assignee: Jacques Le Roux
>             Fix For: SVN trunk
>
>         Attachments: getproductinventorybyavailable.patch
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

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

[murp3433]

Thank you sir!

JIRA [e-mail] wrote

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

Jacques Le Roux closed OFBIZ-2198.
----------------------------------

    Resolution: Fixed
      Assignee: Jacques Le Roux

Kathy,

It seems that you copied from R4. But you forgot to copy (at least in patch since you seem to get the right result)
        <set from-field="parameters.inventoryItemId" field="lookupFieldMap.inventoryItemId"/>
        <set from-field="parameters.productId" field="lookupFieldMap.productId"/>
        <set from-field="parameters.facilityId" field="lookupFieldMap.facilityId"/>
        <set from-field="parameters.locationSeqId" field="lookupFieldMap.locationSeqId"/>
        <set from-field="parameters.containerId" field="lookupFieldMap.containerId"/>

so the result was wrong when applynig your patch (1631 instead of 1000)

I came with a mix of the 2 code snippets. Please see revision 748589.

Thanks

> Inventory showing as 0/0
> -------------------------
>
>                 Key: OFBIZ-2198
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2198
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: SVN trunk
>         Environment: Demo System
>            Reporter: Josh Murphy
>            Assignee: Jacques Le Roux
>             Fix For: SVN trunk
>
>         Attachments: getproductinventorybyavailable.patch
>
>
> Inventory showing 0/0 in edit product and in facility -> inventory

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