@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
For Purchase Invoices
