On 10/12/07, Charley Tiggs <..hidden..> wrote:
Chris Travers wrote:
On 10/12/07, Charley Tiggs <..hidden..> wrote:
Yes, the process happened prior to the 1.2.8 hotfix. The attempt to
reverse the transaction happened after.
THis is probably related to the issue the hotfix was designed to fix.
If you entered the invoice for 10 items and sold them, the qty +
allocated should equal 0. You can fix that with SQL.
Just to be clear, I can go into the database and issue a statement such as:
update invoice set allocated = qty * -1 where id = xxxx;
Hmm.... Going back through how this bug manifests.. IIRC it also
prevents the sales invoices from allocating too, though that doesn't
seem to be your case here (if they had not allocated, then reversing
them wouldn't be a problem).
Just to be safe, look at the allocation numbers of the associated
sales invoices. If they are equal to the negative of the qty, then go
ahead and perform that operation listed above. If not, then let me
know and I will work with you to develop a solution.