ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Reversing parts Issue problem
http://www.istechforum.com/YaBB.pl?num=1115053042

Message started by kevind on 05/02/05 at 08:57:22

Title: Reversing parts Issue problem
Post by kevind on 05/02/05 at 08:57:22

We just had a case were we needed to borrow qty 20 of one item that was issued to one work order for another work order.

To do this, we brought up the transaction in WO-G for this item and backed out this transaction of qty 20.

We then went in and looked at what was affected.
1. The Invendory On hand went up by 20 ( correct )
2. The Transaction in WO-G for this item disappeared ( correct )
3. The Work order BOM for the backed out item still shows 20 issured ( BAD )
4. The inventory transactions for the item backed out still shows 20 issured on the origonal issue date ( BAD )
5. WIP for the item still shows qty 20 in WIP ( BAD )

Now, here's the strange part. A couple of days earlier, we did this same thing with a different component on a different work order. Everything was updated correctly.

I'm wondering if a record lock issue may have caused the process of updating the various files to bail out early in this case. I know in the past, there have been cases were the program code would just abandon what it was doing if it ran into any unresolvable record locks.

Title: Re: Reversing parts Issue problem
Post by Lynn Pantic on 05/02/05 at 10:11:45

Any errors during the backout? You should still have the INVTXN record of the original issue but also another entry for the reversal. If the WOMAT record is gone, then rebuilding the work order should fix the allocation & In WIP.

Title: Re: Reversing parts Issue problem
Post by kevind on 05/02/05 at 19:27:13

That is the strange thing ... there were no errors during the backout. The source I have for this is a very detail oriented person. He is the one that brought this to my attention.

I thought we discovered that when you back out an Issue from WO-G that it did not make a INVTXN entry, but rather, just deleted the origonal INVTXN entry. Am I not remembering this correctly??

Title: Re: Reversing parts Issue problem
Post by Lynn Pantic on 05/03/05 at 05:49:14

It deletes the WOMAT entry but makes a new INVTXN entry

Title: Re: Reversing parts Issue problem
Post by cathyh on 05/03/05 at 07:32:07

I know I'm repeating myself, but here it goes...
We issued PN 2000010 qty 1 to a work order. Needed to back out, so we did a negative issue , qty -1. WO-A says we have issued -1. Inventory transactions are correct, showing a +1 and a -1 issue to this work order. I checked the original transactions in the GL and both the +1 and the -1 are there.
I decided to see if I could fix the work order.
- Did a backout of the -1, and a backout of the +1.
-The GL shows the -1 backout but not the +1 backout.
-The work order file shows both (now says 0 issued).
-The inventory file shows none issued and an allocation of 1 for this work order under the allocation tab, but the inventory transaction list shows 1 issued.
-In WO-G the+1 issue is still there.
-The quantity in inventory is 4 instead of 5, so the backout of the +1 didn't reach the total in inventory either.
I tried backing out again. I got the " do you want to back out..." question after I hit enter in the work order prefix field, and if I hit enter until I get to the part number field, I get the question again. If I say yes both times and exit, it still does nothing.
The only thing I can do at this point is... what?

Title: Re: Reversing parts Issue problem
Post by rphitch on 05/03/05 at 07:43:25

I know that everyone is talking about quantity but has anyone else had a problem with costs not moving? I believe there is a problem when you enter a negative and there are no items on hand, the system can pick up an average cost of $ 0.00 which moves the items out of the work order but not the costs. This may be a related problem do you know if there were ant items on hand?

Title: Re: Reversing parts Issue problem
Post by cathyh on 05/03/05 at 08:07:25

In this case there were parts on hand and both the positive and the negative issue showed a cost of 0.82. We probably have used negative issues to correct an issue error where the error took the quantity on hand to 0, and the negative issue is then done at 0 cost and doesn't show up in the GL. This could be the problem with backouts not showing in the GL too, which seems more common in our case. We have had way more trouble with backouts than with negative issues.
As to what Lynn said about seeing the backout in the inventory transaction file, we have never seen that, when we backout the whole transaction has just disappeared like it never happened, except when it works in the GL and we can see it there.
If we could just be perfcet and never have to make corrections....

Title: Re: Reversing parts Issue problem
Post by cathyh on 05/03/05 at 08:08:39

oops, I meant perfect...

Title: Re: Reversing parts Issue problem
Post by kevind on 05/05/05 at 11:39:54

I just re-built the Work Order and the WIP and remaining to be issued data did get updated.

We never did see a INVTXN transaction when the item was backed out. I just checked again incase I missed it, and there is definately not a transaction record in the item that was backed out.