Tasks #13319: Showing Wrong Stock in Stock transfer Picklist - Temp Projects - Posibolt

Tasks #13319

Showing Wrong Stock in Stock transfer Picklist

Added by Rijas P over 1 year ago. Updated about 1 year ago.

Status:

Closed

Priority:

High

Assignee:

Rijas P

Start date:

02/27/2024

Due date:

% Done:

100%

Estimated time:

Spent time:

0.25 h

Description

Dear Ijas,

Showing Wrong Stock in Stock transfer picklist.

Actual Stock

Files

20240227-121948-042.png (67.2 KB) 20240227-121948-042.png		Rijas P, 02/27/2024 01:49 PM
20240227-122233-866.png (120 KB) 20240227-122233-866.png		Rijas P, 02/27/2024 01:52 PM

History

Updated by Shemil Ali over 1 year ago

Assignee changed from Ijas Ahammed to Abdul Fathah

Updated by Abdul Fathah over 1 year ago

Assignee changed from Abdul Fathah to Mohamed Suhail

Suhailka,
Tried to find the root cause of the issue using stock valuation and stock movement report. even after checking the product stock was not showing in negative in both report.

Updated by Mohamed Suhail over 1 year ago

Status changed from New to Resolved
Assignee changed from Mohamed Suhail to Abdul Fathah
% Done changed from 0 to 100

Abdul Fathah wrote:

Suhailka,
Tried to find the root cause of the issue using stock valuation and stock movement report. even after checking the product stock was not showing in negative in both report.

Docstatus check was not there in calculating qty reserved in the below SQL part

round(coalesce(sum(mstorage.qtyonhand),0) - (select coalesce(sum(qtyreserved),0) from c_orderline tol join c_order too on tol.c_order_id = too.c_order_id where too.ispicklistprinted='Y' and tol.m_product_id = mproduct.m_product_id and too.ordertype='POS Order' and tol.ad_org_id = mmovement.ad_org_id and tol.m_warehouse_id=mmovement.m_warehouse_id and too.docstatus in ('CO','CL') ),0) as currentstock

May need to copy the same jrxml to mini server (stockTransferPickList.jrxml)