You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Amardeep Singh Jhajj (JIRA)" <ji...@apache.org> on 2012/10/29 07:27:12 UTC
[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
Re: [jira] [Commented] (OFBIZ-5063) Stock Move is not working
correctly when reservation record has quantity not available value at bulk location.
Posted by Amardeep Singh Jhajj <am...@gmail.com>.
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) <ji...@apache.org>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
>
[jira] [Updated] (OFBIZ-5063) Stock Move is not working correctly
when reservation record has quantity not available value at bulk location.
Posted by "Amardeep Singh Jhajj (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Closed] (OFBIZ-5063) Stock Move is not working correctly
when reservation record has quantity not available value at bulk location.
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ 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.
>
>
--
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
[jira] [Commented] (OFBIZ-5063) Stock Move is not working correctly
when reservation record has quantity not available value at bulk location.
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ 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}
> 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
[jira] [Resolved] (OFBIZ-5063) Stock Move is not working correctly
when reservation record has quantity not available value at bulk location.
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ 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.
>
>
--
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
[jira] [Commented] (OFBIZ-5063) Stock Move is not working correctly
when reservation record has quantity not available value at bulk location.
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Assigned] (OFBIZ-5063) Stock Move is not working correctly
when reservation record has quantity not available value at bulk location.
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ 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.
>
>
--
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