Re: Questions about allocation

["Chris Travers" <..hidden..>]

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.

Best Wishes,
Chris Travers

>
> Without making a mess?  Nothing else needs doing on the entry for the
> vendor line item?
>
> Charley
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>