|View Issue Details|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|defect||[Retail Modules] Order Preparation||major||always||2021-02-09 12:06||2021-02-21 09:39|
|Priority||immediate||Resolution||fixed||Fixed in Version||RR21Q2|
|Status||closed||Fix in branch||Fixed in SCM revision|
|OS Version||Database version||Ant version|
|Product Version||RR20Q3.3||SCM revision|
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
0045870: delivery of sales order in pos issue for not stocked product
|Description||For some sales order, when we want to issue them, with have an issue with the stock not available.|
I have tried to debug it, but it seems that the call to m_get_stock_param, called like this :
It runs well apparaenlty :
But in the table M_Stock_Proposed no sign of the stock, so it returns 0 proposed lines for this stock and then we have the resulting error in the POS.
Discussion with product here :
I checked the instance and saw the following:
- The store has several warehouses. There is no stock for the "58 TOUR EIFFEL" product in any of them.
- In fact, the product doesn't seem to have stock in any warehouse at all.
- I think it makes sense, because it is marked as "not stocked". But then, you are trying to use the Issue Sales Order functionality, for products that in fact are not stocked.
And to be honest, I don't really know if this is a feature we should support and it's just a bug in the delivery process, or if this configuration was not considered when implementing the Issue Sales Order and delivery modes functionality. That's why I suggested that we should ask functional team, because they know the OB stock model better.
I added them now. @Functional team, you can check the case mentioned in the forwarded email. Basically, the situation seems to be that there were some orders delivered (I guess with delivery mode different from pick and carry) of non-stocked products. Afterwards, it seems they are trying to use the "Issue Sales Order" process to deliver them, and they got an error mentioning that no stock could be found for the product.
Not stocked products, like services, can be also included in goods shipments. This is not the common scenario, as goods shipments are usually related to stocked products, but they might be included as proof that a service has been delivered to the customer.
TBH I don't know how it should behave in the case of the POS Issue Sales Order and delivery modes.
I don't have the details, but the solution could be as easy as avoid checking for stock when the product is set as not-stocked.
From my point of view every product and/or service can and should be delivered. This is the only way we can track something has already been delivered and so it should not be delivered again.
In case of a stocked product, there is also a register for the stock consumption.
In case of a non-stocked product or service the shipment just verifies the product or service was delivered to the end customer and therefore there is no need to deliver the good again.
If there were no shipments it would be impossible to determine if the product/service has already been delivered.
If the product does not support this flow, I would consider it a bug and it should be fixed.
|Steps To Reproduce||- create a sales order with not -stocked product|
- try to issue it in the pos
- the issue will fail as there is no stock
|Tags||No tags attached.|
|Attached Files|| image2.png [^] (125,197 bytes) 2021-02-09 12:07
image1.png [^] (67,942 bytes) 2021-02-09 12:07
image3.png [^] (450,395 bytes) 2021-02-09 12:08
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/312 [^]
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/312 [^]
Directly closing issue as related merge request is already approved.
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Author: Ranjith S R <email@example.com>
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/936638f3ecf000a139ae3b07f6cd0ee735110b3e [^]
Fixed ISSUE-45870: Shipment should be generated for NonStocked Product
* For NonStocked Product, Shipment should be created without bin details
|2021-02-09 12:06||sebastien_liron||New Issue|
|2021-02-09 12:06||sebastien_liron||Assigned To||=> Retail|
|2021-02-09 12:06||sebastien_liron||Triggers an Emergency Pack||=> No|
|2021-02-09 12:07||sebastien_liron||File Added: image2.png|
|2021-02-09 12:07||sebastien_liron||File Added: image1.png|
|2021-02-09 12:08||sebastien_liron||File Added: image3.png|
|2021-02-09 12:10||sebastien_liron||Resolution time||=> 1613689200|
|2021-02-19 10:02||marvintm||Type||design defect => defect|
|2021-02-19 10:05||ranjith_qualiantech_com||Assigned To||Retail => ranjith_qualiantech_com|
|2021-02-19 11:14||marvintm||Target Version||RR20Q3.4 =>|
|2021-02-19 14:37||ranjith_qualiantech_com||Status||new => scheduled|
|2021-02-20 03:50||hgbot||Note Added: 0126226|
|2021-02-21 09:39||hgbot||Resolution||open => fixed|
|2021-02-21 09:39||hgbot||Status||scheduled => closed|
|2021-02-21 09:39||hgbot||Note Added: 0126230|
|2021-02-21 09:39||hgbot||Fixed in Version||=> RR21Q2|
|2021-02-21 09:39||hgbot||Note Added: 0126231|
|2021-02-22 11:06||ranjith_qualiantech_com||Relationship added||related to 0045894|
|2022-05-20 14:18||ranjith_qualiantech_com||Relationship added||related to 0048886|
|Copyright © 2000 - 2009 MantisBT Group|