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:
> >>>> 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?

>
> Vendor record:
> qty: -10
> allocation: 0
>
> Sales records (x10):
> qty: 1
> allocation: 0
>
> 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
>