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?
@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.)
@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
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.