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:
> >> Chris Travers wrote:
> >>> 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.
> >> Looking at the sales invoices, all of them have an allocation of 0.
> >
> > If you see the GL report, do they have COGS allocated?
>
> COGS seems to be allocated, yes.
>
Ok, then adjust the allocated via SQL.

Best Wishes,
Chris Travers