Welcome, Guest. Please Login.
05/13/25 at 04:04:11
News:
Home Help Search Login


Pages: 1
Send Topic Print
AP-C Locked Out (Read 1143 times)
bvesall
Browser
*




Posts: 31
Gender: male
AP-C Locked Out
01/09/07 at 07:44:01
 
Hello,
 
We are having a repeatable problem in AP-C.  We have blanket purchase orders for several of our vendors.  There are instances when we will be posting items in AP-C at the same time we are receiving against that blanket purchase order number.  
 
Unfortunately, we do not find out that we are locked out until we go to post the invoice in AP-C.  When this happens, we have to exit and get back into the invoice.  Whatever items got locked out no longer appear as receivers to tie to the invoice.  We then have to receive and unreceive just to have the receiver show up again to process the invoice.  This creates more garbage on our system every time we have to do this.
 
It would make sense for whoever brings up the purchase order last would get locked out, but this does not appear to be the case.  
 
Are others having the same problems, and is there a patch for this problem?
 
 
Thanks in advance,
Brian
 
Back to top
 
 

Either I'm on to something or I'm on something
  IP Logged
bvesall
Browser
*




Posts: 31
Gender: male
Re: AP-C Locked Out
Reply #1 - 02/05/07 at 12:00:24
 
Anyone....Anyone....Bueller ???
Back to top
 
 

Either I'm on to something or I'm on something
  IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: AP-C Locked Out
Reply #2 - 02/05/07 at 12:20:34
 
I have had this happen a time oe two. I have asked the person who got the lock and they were saying NO to the prompt. This will exit the progarm half finished. I always have them keep saying Yes to it or go find who is locking you. That way they can finish the transaction.
 
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: AP-C Locked Out
Reply #3 - 02/05/07 at 16:39:32
 
We have a rule here-  AP-C in the morning, PO-C in the afternoon.  Or if necessary, we alert the AP-C person to get out of AP-C!  Of course, we only have one of each so it's easy.   Grin
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
bvesall
Browser
*




Posts: 31
Gender: male
Re: AP-C Locked Out
Reply #4 - 02/07/07 at 10:06:12
 
Quote from JNAPIER   on 02/05/07 at 12:20:34:
I have had this happen a time oe two. I have asked the person who got the lock and they were saying NO to the prompt. This will exit the progarm half finished. I always have them keep saying Yes to it or go find who is locking you. That way they can finish the transaction.


John

 
 
Thanks for all the input everyone.  As far as I know, nobody is getting the prompt that the item is locked.  If two of us are in IN-A or one is in IN-A and one in PO-C there is a prompt, but I guess I'll have to gather more data.  First in should not be the one locked out if you ask me.
 
Brian
Back to top
 
 

Either I'm on to something or I'm on something
  IP Logged
Tim Goldstein
Full Member
***


'Cause sooner or
later everyone needs
a chief geek

Posts: 212
Gender: male
Re: AP-C Locked Out
Reply #5 - 02/09/07 at 08:27:23
 
Thanks for the post.  I think this leads me to "an Idiot" problem that has been causing problems with my GL being off!  The "Idiot" is probably getting the prompt and since he leans on the enter key while receiving a PO,  the default is probably No so I only get half of the GL posting!!!!
 
Allen,  What's going on with locks?  I though you said you had them fixed?
 
Most my users complain when they have multiple windows open and lock themselves out!
Back to top
 
 

Tim
Email WWW timgolds timgolds   IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: AP-C Locked Out
Reply #6 - 02/09/07 at 09:50:01
 
Tim,
 
  over 600 programs in the system, average of 10 locks per program = 6000 possible record locking issues.. I may have missed one or two...
 
I need more info to fix this one.  What is getting locked?, are there error messages or lock messages coming up? Is the user doing ctrl alt del to get out.. if there is no message?
 
Give me the complete picture of what is happening.
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: AP-C Locked Out
Reply #7 - 02/09/07 at 10:39:34
 
With us there is a record lock between PO-C and AP-C.  The PO's don't have to be the same-  when someone is entering a PO INvoice in AP-C and posting the same time as someone is entering a PO Receipt.  
We have not done any testing to see exactly what each one is doing at the same time; in the one I am remembering, there was  a bad GL entry from AP-C - out of balance and numbers in wrong accounts.  The PO receipt posted okay.  
 
PS It has happened in the past; I just can't remember the details though I could probably find them with some digging.
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
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: AP-C Locked Out
Reply #8 - 02/09/07 at 12:32:15
 
Cathy, or anybody,
 
what is the lock?  as in error locking BKICMSTR retry Yes No...
 
the important thing I need is the file name in that case BKICMSTR.. that tells me where to start looking.
 
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: AP-C Locked Out
Reply #9 - 02/09/07 at 13:09:34
 
I am calling this a record lock because the post to the GL from AP-C is bad, and It happens when someone is also entering and saving a PO Receipt.
There are no error messages, and the programs do not hang.
There is just bad data in the GL.
This has only happened a few times, so it is very rare and I have never been able to pinpoint anything except that the two programs are running at the same time.  Our  work-around is that we post PO Receipts and PO Invoices at different times of the day-- problem solved.  
If I can find time I will try to recreate.... in test of course.
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: AP-C Locked Out
Reply #10 - 02/09/07 at 13:21:25
 
Allen,
I have reproduced a record lock between PO-C and AP-C.
 
It goes like this:
One user is receiving a line item on a po in PO-C and the other is entering an INVOICE on that line item in AP-C.
 
I left the PO-C user with the line item up, ready to post the receipt and then tried to finish out the AP-C entry.  
 
The error message in AP-C says that a record in file BKAPPO is locked by another user.
 
Now, I try and post the Receipt, and the error message there says that a record in BKAPPOL is locked by another user.
 
One application locked the BKAPPO then the BKAPPOL and the other application seems to have locked them in the reverse order (BKAPPOL and then BKAPPO).  
 
I remember this being called a 'deadly embrace'.   Grin
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
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: AP-C Locked Out
Reply #11 - 02/09/07 at 13:32:42
 
Yup, that or a deadlock... I will look in to it now.
 
This is the type of Info that we need to help us clean up the system.  
 
Thanks Kevin
 
Cathy, if you find other issues let me  know.
 
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
Pages: 1
Send Topic Print