Welcome, Guest. Please Login.
11/01/24 at 03:41:54
News:
Home Help Search Login


Pages: 1
Send Topic Print
Zombie Work Order Labor (Read 357 times)
kkmfg
Senior Member
****


Ghost of the code

Posts: 411
Gender: male
Zombie Work Order Labor
01/11/08 at 10:18:14
 
I believe that I have some work order labor transactions that have died and then risen from the grave to stalk me. I may need holy water or a chainsaw.
 
More accurately, I have two really old WO's that I was using for testing. I really want to close or cancel them as they mean nothing and shouldn't stick around anymore. When I try to either close or cancel it tells me that there are unposted or open labor transactions and that I need to run DC-D to find those transactions. DC-D shows nothing. This might have something to do with my investigating interfacing third party code with the labor tracking system in Evo. Of course, I have no idea where these zombie transactions might be though... If ever there was an argument for triggers and better database normalization!!!!
Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Zombie Work Order Labor
Reply #1 - 01/11/08 at 11:57:40
 
Holy water and chainsaws are no use. Just keep throwing bad coders at them to slow them down.   Roll Eyes
 
The unposted labor transactions are in BKDCPLAB. There is also a temporary transaction table BKDCTLAB. I know nothing about "open" labor transactions, unless they are talking about a non-union shop.
 
 Tongue
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
kkmfg
Senior Member
****


Ghost of the code

Posts: 411
Gender: male
Re: Zombie Work Order Labor
Reply #2 - 01/11/08 at 13:00:41
 
Ah yes, BKDCPLAB... I remember now. Yes, I did put a bunch of test records in there months ago and forgot all about them. So it was my fault (as I had assumed it was.)  
 
What irks me isn't that I did it but that evo was unable to tell me why it was failing. IT KNEW, OF COURSE, BECAUSE IT HAD TO HAVE CHECKED FOR THE PROBLEM. But did it tell me why it was failing? NO! Instead it made up some other lame excuse and lead me on a wild goose chase.  Angry
 
Is it really so hard to write software that has verbose and correct error messages?
 
I suppose it at least had a text based error message. Nothing bothers me more than seeing the raw error code returned from a program. The stupid program knew what the error code meant, couldn't it have let me in on the secret? Microsoft is horrible at that. If I see another 80070005 error (that's access denied btw) or any of it's kin I will scream.
 
WHEW.... I feel better now.  Cheesy
Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
Pages: 1
Send Topic Print