Re: Questions about allocation

[Charley Tiggs <..hidden..>]

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;

Without making a mess?  Nothing else needs doing on the entry for the 
vendor line item?

Charley