Project

General

Profile

Tasks #11452

Item Received not showing in Stock

Added by Rijas P over 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
Start date:
08/19/2023
Due date:
% Done:

100%

Estimated time:
Spent time:

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

Stock movement not rcvd.JPG (162 KB) Stock movement not rcvd.JPG Rijas P, 08/19/2023 07:51 PM
Drill down Stock movement.JPG (183 KB) Drill down Stock movement.JPG Rijas P, 08/19/2023 07:51 PM
Received Qty.JPG (166 KB) Received Qty.JPG Rijas P, 08/19/2023 07:51 PM

History

#1

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

#2

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

#3

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

#4

Updated by Rijas P over 1 year ago

  • Status changed from Resolved to Closed

Found updated

#5

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF