OFBiz › OFBiz - Dev

[jira] [Created] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

8 messages Options

Nicolas Malin (Jira)

[jira] [Created] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

Amardeep Singh Jhajj created OFBIZ-5063:
-------------------------------------------

Summary: Stock Move is not working correctly when reservation record has quantity not available value at bulk location.
Key: OFBIZ-5063
URL: https://issues.apache.org/jira/browse/OFBIZ-5063
Project: OFBiz
Issue Type: Bug
Components: order, product
Reporter: Amardeep Singh Jhajj
Fix For: Release Branch 10.04, Release Branch 11.04, SVN trunk, Release Branch 12.04

The problem will occur when we do stock move on reservation that have quantityNotAvailable value. A reservation with quantity was left in the original inventory item, but the Inventory Item had no Quantity on Hand.

This issue is also reported in OFBIZ-3178.

Here is the steps that I used to reproduce the bug.

After reservation at bulk location when 20 item backordered, inventory record was-

Bulk location inventory item

inventoryItemId : 10004
quantityOnHandTotal: 50
availableToProm : -20

OrderItemShipGrpInvRes -Reservation record at bulk location.

inventoryItemId : 10004
quantity: 70
quantityNotAvailable : 20

After stock move -

Bulk location inventory item

inventoryItemId : 10004
quantityOnHandTotal: 0
availableToProm : 0

Pick/Primary location inventory item
inventoryItemId : 10005
quantityOnHandTotal: 50
availableToProm : -20

Here everything seems to be working fine with Inventory Item.

OrderItemShipGrpInvRes- Reservation record at bulk location

inventoryItemId : 10004
quantity: 50
quantityNotAvailable : 0

OrderItemShipGrpInvRes-Reservation record at pick location

inventoryItemId : 10005
quantity: 70
quantityNotAvailable : 20

Here OrderItemShipGrpInvRes- Reservation record at bulk location should be removed after stock move.

Due to this bug, total reserved quantity of order was changed. For example here-

After stock move, total reserved quantity - 70 + 50 = 120. After deducting quantityNotAvailable, the order reserved quantity calculated was 100 while ordered was 70.

I am attaching the modified patch of OFBIZ-3178 for Release-10.04,11.04, 12.04 and trunk. Please review it and do the needful.

--
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

Nicolas Malin (Jira)

[jira] [Updated] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

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

Amardeep Singh Jhajj updated OFBIZ-5063:
----------------------------------------

Attachment: OFBIZ-5063.patch

> Stock Move is not working correctly when reservation record has quantity not available value at bulk location.
> --------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5063
> URL: https://issues.apache.org/jira/browse/OFBIZ-5063
> Project: OFBiz
> Issue Type: Bug
> Components: order, product
> Reporter: Amardeep Singh Jhajj
> Fix For: Release Branch 10.04, Release Branch 11.04, SVN trunk, Release Branch 12.04
>
> Attachments: OFBIZ-5063.patch
>
>
> The problem will occur when we do stock move on reservation that have quantityNotAvailable value. A reservation with quantity was left in the original inventory item, but the Inventory Item had no Quantity on Hand.
> This issue is also reported in OFBIZ-3178.
> Here is the steps that I used to reproduce the bug.
> After reservation at bulk location when 20 item backordered, inventory record was-
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 50
> availableToProm : -20
> OrderItemShipGrpInvRes -Reservation record at bulk location.
> inventoryItemId : 10004
> quantity: 70
> quantityNotAvailable : 20
> After stock move -
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 0
> availableToProm : 0
> Pick/Primary location inventory item
> inventoryItemId : 10005
> quantityOnHandTotal: 50
> availableToProm : -20
> Here everything seems to be working fine with Inventory Item.
> OrderItemShipGrpInvRes- Reservation record at bulk location
> inventoryItemId : 10004
> quantity: 50
> quantityNotAvailable : 0
> OrderItemShipGrpInvRes-Reservation record at pick location
> inventoryItemId : 10005
> quantity: 70
> quantityNotAvailable : 20
> Here OrderItemShipGrpInvRes- Reservation record at bulk location should be removed after stock move.
> Due to this bug, total reserved quantity of order was changed. For example here-
> After stock move, total reserved quantity - 70 + 50 = 120. After deducting quantityNotAvailable, the order reserved quantity calculated was 100 while ordered was 70.
> I am attaching the modified patch of OFBIZ-3178 for Release-10.04,11.04, 12.04 and trunk. Please review it and do the needful.
>
>

--
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

Nicolas Malin (Jira)

[jira] [Commented] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

In reply to this post by Nicolas Malin (Jira)

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

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

Hi Amardeep,

Are we sure that this does not introduce any side effects, regressions?

Amardeep Singh Jhajj

Re: [jira] [Commented] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

Hi Jacques,

I have tested it well with different scenarios and it is working fine.

On Tue, Oct 30, 2012 at 4:54 PM, Jacques Le Roux (JIRA) <[hidden email]>wrote:

>
> [
> https://issues.apache.org/jira/browse/OFBIZ-5063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13486815#comment-13486815]
>
> Jacques Le Roux commented on OFBIZ-5063:
> ----------------------------------------
>
> Hi Amardeep,
>
> Are we sure that this does not introduce any side effects, regressions?
>
> > Stock Move is not working correctly when reservation record has quantity
> not available value at bulk location.
> >
> --------------------------------------------------------------------------------------------------------------
> >
> > Key: OFBIZ-5063
> > URL: https://issues.apache.org/jira/browse/OFBIZ-5063
> > Project: OFBiz
> > Issue Type: Bug
> > Components: order, product
> > Reporter: Amardeep Singh Jhajj
> > Fix For: Release Branch 10.04, Release Branch 11.04, SVN
> trunk, Release Branch 12.04
> >
> > Attachments: OFBIZ-5063.patch
> >
> >
> > The problem will occur when we do stock move on reservation that have
> quantityNotAvailable value. A reservation with quantity was left in the
> original inventory item, but the Inventory Item had no Quantity on Hand.
> > This issue is also reported in OFBIZ-3178.
> > Here is the steps that I used to reproduce the bug.
> > After reservation at bulk location when 20 item backordered, inventory
> record was-
> > Bulk location inventory item
> > inventoryItemId : 10004
> > quantityOnHandTotal: 50
> > availableToProm : -20
> > OrderItemShipGrpInvRes -Reservation record at bulk location.
> > inventoryItemId : 10004
> > quantity: 70
> > quantityNotAvailable : 20
> > After stock move -
> > Bulk location inventory item
> > inventoryItemId : 10004
> > quantityOnHandTotal: 0
> > availableToProm : 0
> > Pick/Primary location inventory item
> > inventoryItemId : 10005
> > quantityOnHandTotal: 50
> > availableToProm : -20
> > Here everything seems to be working fine with Inventory Item.
> > OrderItemShipGrpInvRes- Reservation record at bulk location
> > inventoryItemId : 10004
> > quantity: 50
> > quantityNotAvailable : 0
> > OrderItemShipGrpInvRes-Reservation record at pick location
> > inventoryItemId : 10005
> > quantity: 70
> > quantityNotAvailable : 20
> > Here OrderItemShipGrpInvRes- Reservation record at bulk location should
> be removed after stock move.
> > Due to this bug, total reserved quantity of order was changed. For
> example here-
> > After stock move, total reserved quantity - 70 + 50 = 120. After
> deducting quantityNotAvailable, the order reserved quantity calculated was
> 100 while ordered was 70.
> > I am attaching the modified patch of OFBIZ-3178 for Release-10.04,11.04,
> 12.04 and trunk. Please review it and do the needful.
> >
> >
>
> --
> 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
>

Nicolas Malin (Jira)

[jira] [Commented] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

In reply to this post by Nicolas Malin (Jira)

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

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

Quoting Amardeep on dev ML
{quote}
Hi Jacques,

I have tested it well with different scenarios and it is working fine.
{quote}

Nicolas Malin (Jira)

[jira] [Assigned] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

In reply to this post by Nicolas Malin (Jira)

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

Anil K Patel reassigned OFBIZ-5063:
-----------------------------------

Assignee: Anil K Patel

> Stock Move is not working correctly when reservation record has quantity not available value at bulk location.
> --------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5063
> URL: https://issues.apache.org/jira/browse/OFBIZ-5063
> Project: OFBiz
> Issue Type: Bug
> Components: order, product
> Reporter: Amardeep Singh Jhajj
> Assignee: Anil K Patel
> Fix For: Release Branch 10.04, Release Branch 11.04, SVN trunk, Release Branch 12.04
>
> Attachments: OFBIZ-5063.patch
>
>
> The problem will occur when we do stock move on reservation that have quantityNotAvailable value. A reservation with quantity was left in the original inventory item, but the Inventory Item had no Quantity on Hand.
> This issue is also reported in OFBIZ-3178.
> Here is the steps that I used to reproduce the bug.
> After reservation at bulk location when 20 item backordered, inventory record was-
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 50
> availableToProm : -20
> OrderItemShipGrpInvRes -Reservation record at bulk location.
> inventoryItemId : 10004
> quantity: 70
> quantityNotAvailable : 20
> After stock move -
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 0
> availableToProm : 0
> Pick/Primary location inventory item
> inventoryItemId : 10005
> quantityOnHandTotal: 50
> availableToProm : -20
> Here everything seems to be working fine with Inventory Item.
> OrderItemShipGrpInvRes- Reservation record at bulk location
> inventoryItemId : 10004
> quantity: 50
> quantityNotAvailable : 0
> OrderItemShipGrpInvRes-Reservation record at pick location
> inventoryItemId : 10005
> quantity: 70
> quantityNotAvailable : 20
> Here OrderItemShipGrpInvRes- Reservation record at bulk location should be removed after stock move.
> Due to this bug, total reserved quantity of order was changed. For example here-
> After stock move, total reserved quantity - 70 + 50 = 120. After deducting quantityNotAvailable, the order reserved quantity calculated was 100 while ordered was 70.
> I am attaching the modified patch of OFBIZ-3178 for Release-10.04,11.04, 12.04 and trunk. Please review it and do the needful.
>
>

Nicolas Malin (Jira)

[jira] [Resolved] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

In reply to this post by Nicolas Malin (Jira)

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

Anil K Patel resolved OFBIZ-5063.
---------------------------------

Resolution: Fixed

> Stock Move is not working correctly when reservation record has quantity not available value at bulk location.
> --------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5063
> URL: https://issues.apache.org/jira/browse/OFBIZ-5063
> Project: OFBiz
> Issue Type: Bug
> Components: order, product
> Reporter: Amardeep Singh Jhajj
> Assignee: Anil K Patel
> Fix For: Release Branch 10.04, Release Branch 11.04, SVN trunk, Release Branch 12.04
>
> Attachments: OFBIZ-5063.patch
>
>
> The problem will occur when we do stock move on reservation that have quantityNotAvailable value. A reservation with quantity was left in the original inventory item, but the Inventory Item had no Quantity on Hand.
> This issue is also reported in OFBIZ-3178.
> Here is the steps that I used to reproduce the bug.
> After reservation at bulk location when 20 item backordered, inventory record was-
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 50
> availableToProm : -20
> OrderItemShipGrpInvRes -Reservation record at bulk location.
> inventoryItemId : 10004
> quantity: 70
> quantityNotAvailable : 20
> After stock move -
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 0
> availableToProm : 0
> Pick/Primary location inventory item
> inventoryItemId : 10005
> quantityOnHandTotal: 50
> availableToProm : -20
> Here everything seems to be working fine with Inventory Item.
> OrderItemShipGrpInvRes- Reservation record at bulk location
> inventoryItemId : 10004
> quantity: 50
> quantityNotAvailable : 0
> OrderItemShipGrpInvRes-Reservation record at pick location
> inventoryItemId : 10005
> quantity: 70
> quantityNotAvailable : 20
> Here OrderItemShipGrpInvRes- Reservation record at bulk location should be removed after stock move.
> Due to this bug, total reserved quantity of order was changed. For example here-
> After stock move, total reserved quantity - 70 + 50 = 120. After deducting quantityNotAvailable, the order reserved quantity calculated was 100 while ordered was 70.
> I am attaching the modified patch of OFBIZ-3178 for Release-10.04,11.04, 12.04 and trunk. Please review it and do the needful.
>
>

Nicolas Malin (Jira)

[jira] [Closed] (OFBIZ-5063) Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

In reply to this post by Nicolas Malin (Jira)

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

Anil K Patel closed OFBIZ-5063.
-------------------------------

> Stock Move is not working correctly when reservation record has quantity not available value at bulk location.
> --------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5063
> URL: https://issues.apache.org/jira/browse/OFBIZ-5063
> Project: OFBiz
> Issue Type: Bug
> Components: order, product
> Reporter: Amardeep Singh Jhajj
> Assignee: Anil K Patel
> Fix For: Release Branch 10.04, Release Branch 11.04, SVN trunk, Release Branch 12.04
>
> Attachments: OFBIZ-5063.patch
>
>
> The problem will occur when we do stock move on reservation that have quantityNotAvailable value. A reservation with quantity was left in the original inventory item, but the Inventory Item had no Quantity on Hand.
> This issue is also reported in OFBIZ-3178.
> Here is the steps that I used to reproduce the bug.
> After reservation at bulk location when 20 item backordered, inventory record was-
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 50
> availableToProm : -20
> OrderItemShipGrpInvRes -Reservation record at bulk location.
> inventoryItemId : 10004
> quantity: 70
> quantityNotAvailable : 20
> After stock move -
> Bulk location inventory item
> inventoryItemId : 10004
> quantityOnHandTotal: 0
> availableToProm : 0
> Pick/Primary location inventory item
> inventoryItemId : 10005
> quantityOnHandTotal: 50
> availableToProm : -20
> Here everything seems to be working fine with Inventory Item.
> OrderItemShipGrpInvRes- Reservation record at bulk location
> inventoryItemId : 10004
> quantity: 50
> quantityNotAvailable : 0
> OrderItemShipGrpInvRes-Reservation record at pick location
> inventoryItemId : 10005
> quantity: 70
> quantityNotAvailable : 20
> Here OrderItemShipGrpInvRes- Reservation record at bulk location should be removed after stock move.
> Due to this bug, total reserved quantity of order was changed. For example here-
> After stock move, total reserved quantity - 70 + 50 = 120. After deducting quantityNotAvailable, the order reserved quantity calculated was 100 while ordered was 70.
> I am attaching the modified patch of OFBIZ-3178 for Release-10.04,11.04, 12.04 and trunk. Please review it and do the needful.
>
>