Purchase orders Qty on order is negative

@lubos

Excuse me, a big problem suddenly happened with us today
When I opened our account in the cloud a short while ago, I found that all closed purchase orders from the year 2021 until the last purchase order dated today had changed their status to Partially Received.
Although all purchase orders are invoiced, received and paid

Is there a new cloud update that happened today or what is the problem, please?

This is happened with me as well and the inventory numbers somehow changes as well.

1 Like

The problem still exists
@lubos

@Ahmad-A2Z-Orders, may I suggest you edit the subject of this topic to reflect your actual problem. (“A big problem suddenly happened” is not going to attract the attention of forum members who may be able to help.)

1 Like

Thank you, I changed it

The problem is big and happened suddenly without any reason on our part

Now the problem is with some purchase orders that have been invoiced, received and paid
But as it appears now qty on order in (-)

is there any chance to solve the problem?

@lubos this issue of negative qty is because of double deductions. As in new workflow you have to check the Column-Qty Delivered to tell the system not to deduct /add qty on hand (Or just add/deduct the qty which is mentioned in the new column). As our all previous invoices doesnt have that column so both invoices and delivery notes/Goods receipts are deducting/adding qty twice hence qty on hand and qty reserved/qty on order figures are not correct…
I was able to correct this using Batch Updating all invoices for which delivery notes/goods receipts were issued. And checked the Column- Qty Delivered (For Sales invoices) and Column- Qty received (For purchase invoices) using batch update. Now all figures are correct.
It maybe an issue for users who are not familiar with batch update.
(A tip for users not much familiar with batch update is to delete all the columns leave only these two columns and set the value to TRUE and leave the Key column unchanged)
For Sale invoices
image

For Purchase Invoices
image

1 Like

@Tut @lubos

At least I deserve to have a solution for my problem, at least an answer to my question since yesterday
or somebody saw my problem and said that he working to solve it

This is when more items have been received than what was ordered on purchase order.

But I came to conclusion that it’s not something that should be an issue on purchase order level. So the latest version (24.6.15) will ignore negative balances and therefore Qty on order can be either zero or positive figure.

1 Like