Welcome, Guest. Please Login.
05/10/25 at 15:00:44
News:
Home Help Search Login


Pages: 1
Send Topic Print
Reversing parts Issue problem (Read 986 times)
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Reversing parts Issue problem
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.
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Reversing parts Issue problem
Reply #1 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Reversing parts Issue problem
Reply #2 - 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??
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Reversing parts Issue problem
Reply #3 - 05/03/05 at 05:49:14
 
It deletes the WOMAT entry but makes a new INVTXN entry
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Reversing parts Issue problem
Reply #4 - 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?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
rphitch
Browser
*




Posts: 43
Re: Reversing parts Issue problem
Reply #5 - 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?
Back to top
 
 
  IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Reversing parts Issue problem
Reply #6 - 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....
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Reversing parts Issue problem
Reply #7 - 05/03/05 at 08:08:39
 
oops, I meant perfect...
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Reversing parts Issue problem
Reply #8 - 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.
 
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1
Send Topic Print