Project

General

Profile

Tasks #13319

Showing Wrong Stock in Stock transfer Picklist

Added by Rijas P 11 months ago. Updated 8 months 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

#1

Updated by Shemil Ali 11 months ago

  • Assignee changed from Ijas Ahammed to Abdul Fathah
#2

Updated by Abdul Fathah 10 months 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.

#3

Updated by Mohamed Suhail 10 months 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)

#4

Updated by Abdul Fathah 10 months ago

  • Assignee changed from Abdul Fathah to System Admins Team

Admins,
Please copy the above mentioned jrxml to euro mini server

Instructed by suhailka

#5

Updated by Ajin P 10 months ago

  • Assignee changed from System Admins Team to Abdul Fathah

stockTransferPickList.jrxml deployed in miniserver.

#6

Updated by Abdul Fathah 10 months ago

  • Assignee changed from Abdul Fathah to Ijas Ahammed

Checked by after deployed the jrxml, stock showing correct

#7

Updated by Ijas Ahammed 10 months ago

  • Assignee changed from Ijas Ahammed to Rijas P

Please check now.

#8

Updated by Rijas P 10 months ago

  • Status changed from Resolved to Closed

Found fixed

#9

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