Do you know how and where the Ordered Qty is calculated in the Stock Projected Qty report?

ERPNext
1

Hello,

I want to understand how the ordered quantity is calculated on the Projected Quantity Report

After migrating from v11 to v14, I still encounter a bug in the Projected Quantity Report:

Capture d’écran 2024-10-10 à 17.37.52
Capture d’écran 2024-10-10 à 17.37.521287×670 38.4 KB

Capture d’écran 2024-10-10 à 08.10.40
Capture d’écran 2024-10-10 à 08.10.401063×933 81.3 KB

I cannot figure out which table in the database is used to count this quantity.

I initially thought it was the Purchase Order Item table with the column received_qty, but after updating, the ordered_qty is still present.

I’ve been checking the code, but since I’m not very experienced with Python, I can’t identify the issue.

Can you help me, please?

2

Problem Solved, I updated the table: tabBin

I updated columns:

  • ordered_qty
  • projected_qty

my SQL request was :

UPDATE tabBin 
SET ordered_qty = 0, 
	projected_qty = actual_qty
WHERE ordered_qty > 0