Tasks #11452
Item Received not showing in Stock
Description
Dear Thanesh,
Please see the Item PP3423 received 785 Pcs on 07-08-23 and it's showing in RG invoice & Vendor/Item wise report. But I think there is some issue in Shipment entry, in Stock movement report and inside the Shipment Doc showing received Zero.
Files
History
Updated by Mohamed Suhail over 1 year ago
- Status changed from New to Resolved
- Assignee changed from Peer Thanesh to Rijas P
- % Done changed from 0 to 100
Rijas P wrote:
Dear Thanesh,
Please see the Item PP3423 received 785 Pcs on 07-08-23 and it's showing in RG invoice & Vendor/Item wise report. But I think there is some issue in Shipment entry, in Stock movement report and inside the Shipment Doc showing received Zero.
Made some corrections in DB. Please check Rijas P
eurobackup=# delete from m_reservation where m_inoutline_id =2514441;
DELETE 1
eurobackup=# delete from m_matchpo where m_inoutline_id =2514441;
DELETE 1
eurobackup=# select * from m_transaction where m_inoutline_id =2514442;
eurobackup=# delete from m_transaction where m_inoutline_id =2514441;
DELETE 1
eurobackup=# delete from m_inoutline where m_inoutline_id =2514441;
DELETE 1
eurobackup=# update m_inoutline set c_uom_id=100,movementqty=785,pickedqty=785,confirmedqty=785,qtyentered=785,targetqty=785 where c_orderline_id =3421960 and m_inout_id=1054999;
UPDATE 1
eurobackup=# update m_transaction set movementqty=785 where m_inoutline_id =2514442;
UPDATE 1
eurobackup=# update m_costdetail set amt=519.7014,qty=785 where c_orderline_id =3421960;
UPDATE 1
eurobackup=# update m_costdetail set amt=519.7014,qty=785 where c_invoiceline_id=2527471;
UPDATE 1
eurobackup=# update m_matchinv set qty=785 where C_invoiceline_id=2527471;
UPDATE 1
eurobackup=# update m_cost set currentcostprice=0.6620,currentqty=785 where m_product_id =1028854;
UPDATE 3
Updated by Rijas P over 1 year ago
- Assignee changed from Rijas P to Mohamed Suhail
Dear Suhail,
Found Stock updated. But still the PO qty showing 1440 Pcs.
PO Qty Should be 1440Pcs - 785Pcs = 655Pcs
Updated by Mohamed Suhail over 1 year ago
- Assignee changed from Mohamed Suhail to Rijas P
Rijas P wrote:
Dear Suhail,
Found Stock updated. But still the PO qty showing 1440 Pcs.
PO Qty Should be 1440Pcs - 785Pcs = 655Pcs
Check now
euro=# update c_orderline set qtydelivered=785 where c_orderline_id =3421960 ;
UPDATE 1
euro=# update c_orderline set qtyreserved=qtyordered-qtydelivered where c_orderline_id =3421960 ;
UPDATE 1
Updated by SHAIJAL EDAVANA 8 months ago
- Tracker changed from Bug to Tasks
- Project changed from Euro Novelties to Temp Projects
- Category deleted (
Others)