Openbravo Issue Tracking System - Retail Modules
I have tried to debug it, but it seems that the call to m_get_stock_param, called like this :
select
*
from
M_GET_STOCK_PARAM('63E317DF73D74D1EB9D9E49A1BDF1972',
'63E317DF73D74D1EB9D9E49A1BDF1972',
TO_NUMBER('1'),
'F1A6825D39B84517A35AC0F91869A823',
null,
null,
'A65A38EF90A1476CAFB751F3978DDF00',
'2AD04FA2BA424ACEA45F1D785F5A770A',
null,
'100',
'7CB4BE99E0B0498D9DD7807158B751C8',
null,
'AFD65DC18CC74597B5A550E56AD4709D',
null,
null,
null,
TO_NUMBER(null),
null,
null,
'N',
'Y',
null,
null)
It runs well apparaenlty :
v_Record_ID=63E317DF73D74D1EB9D9E49A1BDF1972
v_AD_User_ID=100
v_Quantity=1
v_ProductID=F1A6825D39B84517A35AC0F91869A823
v_UomID=AFD65DC18CC74597B5A550E56AD4709D
v_ProductUomID=
v_LocatorID=
v_WarehouseID=
v_PriorityWarehouseID=A65A38EF90A1476CAFB751F3978DDF00
v_ClientID=7CB4BE99E0B0498D9DD7807158B751C8
v_OrgID=2AD04FA2BA424ACEA45F1D785F5A770A
v_AttributesetinstanceID=
v_warehouse_rule_id=
v_avail=Y
v_nett=
v_overissue=
Record_ID=63E317DF73D74D1EB9D9E49A1BDF1972
v_warehouse_rule_id:
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.
- try to issue it in the pos
- the issue will fail as there is no stock
| related to | defect | 0045894 | closed | ranjith_qualiantech_com | It is not possible to "issue order" of stockable products when there is no stock, although it allows to sell without stock | |
| related to | defect | 0048886 | closed | ranjith_qualiantech_com | The fonctionnality of "Issue Sales Order" does not deliver Services not linked to product (Independent services) |
image2.png (125,197) 2021-02-09 12:07https://issues.openbravo.com/file_download.php?file_id=15309&type=bug
image1.png (67,942) 2021-02-09 12:07https://issues.openbravo.com/file_download.php?file_id=15310&type=bug
image3.png (450,395) 2021-02-09 12:08https://issues.openbravo.com/file_download.php?file_id=15311&type=bug