Project

General

Profile

Tasks #5090

Wrong PO Qty on Stock valuation

Added by Rijas P about 3 years ago. Updated 8 months ago.

Status:
Closed
Priority:
Urgent
Assignee:
Rijas P
Start date:
12/15/2021
Due date:
% Done:

100%

Estimated time:
Spent time:
0.50 h

Description

Item No EU20459 total outstanding PO is 40 CTNs. But in Stock valuation it's showing only 11 Ctns, but in the drill down showing correct details.

Files

Stock valuation drill down correct Qty.JPG (70.4 KB) Stock valuation drill down correct Qty.JPG Rijas P, 12/15/2021 01:47 PM
EU20459 Order Qty wrong.JPG (113 KB) EU20459 Order Qty wrong.JPG Rijas P, 12/15/2021 01:47 PM

History

#1

Updated by Mohamed Suhail about 3 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Rijas P wrote:

Item No EU20459 total outstanding PO is 40 CTNs. But in Stock valuation it's showing only 11 Ctns, but in the drill down showing correct details.

orderno | dateordered | qtyordered | qtydelivered
-----------------+---------------------+------------+--------------
EU55-20181003_1 | 2018-10-03 00:00:00 | 72 | 1440
(1 row)

Order qty 1 CTN or 72 Each on the above order and total received qty 20 CTN or 1440 Each, so qtyordered for the lines is calculated as 1-20 = -19 CTN
This is the reason it is showing qty 11 CTN on stock valuation (i.e 30 -19)

#2

Updated by Mohamed Suhail about 3 years ago

  • Assignee changed from Mohamed Suhail to Rijas P

Rijas P wrote:

Item No EU20459 total outstanding PO is 40 CTNs. But in Stock valuation it's showing only 11 Ctns, but in the drill down showing correct details.

#3

Updated by Noufal K about 3 years ago

  • Status changed from Resolved to Closed
#4

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