Re: Possible bug in IS.pm

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

On 10/10/07, Chris Travers <..hidden..> wrote:

On 10/10/07, Charley Tiggs < ..hidden..> wrote:

1) Create an invoice that's several days old against inventory so that
inventory is used up

2) Create a new invoice against same inventory but don't pay for it yet

3) Attempt to credit (reverse) inventory against the first invoice

I will attempt to replicate this immediately.  The way the current reversing logic works is that we first try to reverse outstanding short invoices (which prevents COGS from being calculated when products are ordered), then we try to reverse purchased goods which have COGS associated.

I have not been able to reproduce this.  My attempt to do so was:
1)  Create a new part
2)  Create a vendor for that part for 5 items.
3)  Create a sales invoice for the part for 5 items.
4)  Create a sales invoice for the part for 5 items.
5)  Create a sales invoice for that part for -1 item.

Posted as expected, reversing one item on the short sale (and thus has no COGS entry).

Note that the error you are receiving suggests that there are not sufficient sales invoices to reverse.  It has nothing to do with on-hand inventory.  It is possible tht there is some other issue with your set up or some other issue which is causing the problem.  Also if I am reproducing the issue wrng,
 

Best Wishes,
Chris Travers

This means that you must have either:
1)  Unallocated line items for sales invoices
OR
2)  Allocated line items for vendor invoices.

If you have enough reversals that we cannot pull enough records from either of these sources, you will get that error.  We throw this error because reversing even more inventory items would create orphaned records which would probably never get allocated.  If we know when it is required that we allow such reversals, then we can properly handle them :-).

Best Wishes,
Chris Travers