[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Questions about allocation



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.

Charley

Vendor record:
qty: -10
allocation: 0

Sales records (x10):
qty: 1
allocation: 0