Welcome, Guest. Please Login.
05/29/25 at 21:36:06
News:
Home Help Search Login


Pages: 1
Send Topic Print
AP-C - NO to lock wait causes GL out of balance (Read 998 times)
kevind
Active Member
*****


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

Posts: 634
Gender: male
AP-C - NO to lock wait causes GL out of balance
12/19/06 at 09:12:56
 
While processing a Vendor invoice in AP-C, if you receive a message that
another user has a record locked, and you answer NO to the 'do you wish to wait?'
question, then the GL transaction for the merchandise amount that debits the
GL RNI account does not get generated in the Batch file.
 
This results in the Batch being out of balance.  
 
Everything else appears  ???  to be posted OK. cry
Back to top
 
« Last Edit: 12/19/06 at 15:11:41 by kevind »  

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
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: AP-C -> NO to lock wait causes
Reply #1 - 12/19/06 at 13:14:20
 
Then one edits the Batch to add the missing transaction in GL-P.  
 
I'd rather only have to add a GL transaction than modify the purchasing and inventory files (those records update properly!)
 Roll Eyes
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
kevind
Active Member
*****


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

Posts: 634
Gender: male
Re: AP-C -NO to lock wait causes GL out of balance
Reply #2 - 12/19/06 at 15:10:11
 
I understand ... we had already added the missing transaction.
 
My point is a lock should not inhibit the RNI entry in the batch file.
The other GL transactions did post to the batch.  There is
no other file involved with adding transactions to the GL Batch.
 
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
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: AP-C - NO to lock wait causes GL out of balanc
Reply #3 - 12/19/06 at 15:31:42
 
At least you got a message.  I was receiving a PO while someone was entering a PO invoice, and there was no alert, but the invoice transaction posted completely wrong (amounts in other accounts wrong, nothing in the RNI account).  There are definite record locking issues when entering and posting PO invoices.
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AP-C - NO to lock wait causes GL out of balanc
Reply #4 - 02/20/07 at 17:41:21
 
I agree there are issues here, and more than one post on the subject.  I think that perhaps AP-C and PO-C on the same PO should not be allowed at the same time and whoever gets into the PO first has dibs on that particular PO until they are finished.  If you got the message that another user was in the same PO at the very beginning you at least wouldn't be in the middle of saving the entries when it realized there was a locking problem.  
 
Feedback, please!!!
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: AP-C - NO to lock wait causes GL out of balanc
Reply #5 - 02/21/07 at 12:04:17
 
Lynn,
Check this thread ...
http://www.istechforum.com/cgi-bin/YaBB.pl?num=1168357441/10#10
 
I think Allen is on top of this one.
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: AP-C - NO to lock wait causes GL out of balanc
Reply #6 - 02/21/07 at 13:15:18
 
Yes and no.  We know what part of the problem is.  If we never let PO-C and AP-C into the same PO at the same time, it is an easier fix than trying to unlock the deadly embrace.
Back to top
 
 

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


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: AP-C - NO to lock wait causes GL out of balanc
Reply #7 - 02/22/07 at 05:28:05
 
Quote from Lynn_Pantic on 02/21/07 at 13:15:18:
If we never let PO-C and AP-C into the same PO at the same time, it is an easier fix than trying to unlock the deadly embrace.

This is fine by us.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: AP-C - NO to lock wait causes GL out of balanc
Reply #8 - 02/22/07 at 08:56:35
 
Quote from Lynn_Pantic on 02/21/07 at 13:15:18:
Yes and no.  We know what part of the problem is.  If we never let PO-C and AP-C into the same PO at the same time, it is an easier fix than trying to unlock the deadly embrace.

 
Fine by me!  Perhaps Dilbert can come back to life with a message that the file is already in use, please wait. Grin
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
dorner
Browser
*


I love YaBB 1G -
SP1!

Posts: 48
Re: AP-C - NO to lock wait causes GL out of balanc
Reply #9 - 03/08/07 at 15:00:01
 
I have had something happen twice but can not reproduce it on demand.  When I was entering PO invoices in AP-C and I got the message that BKAPPO was locked I waited a little while and clicked Yes.  Got the same message so I said NO and closed out of AP-C.  
 
When I came back to AP-C everything seemed to go fine until I got to the second page.  The first item of the receipt is now missing.  For instance if I recieved 3 line items on a certain PO when I can eventually get into AP-C the first line is missing.  Only 2 line items show up on the second page.
 
Mikeb
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print