Vantage 6.0 Patch 535 - Bank Rec Group Locked

Yahoo Archive
1
Mario -

You probably had this resolved but I just got back in the office and saw
your message. On 5.2 this happened to me and there was a program Epicor had
me run to unlock the user. This worked for me.



Have a Nice Day,

Dina Hieber
Vamco International, Inc.
Phone (412) 963-7100
Fax; (412) 963-7160

www.vamcointernational.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mario Aguirre
Sent: Monday, May 15, 2006 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.0 Patch 535 - Bank Rec Group Locked

Whenever a bank statement is added in bank reconciliation, an A/P
payment group is created (you can view the group, but the OK option to
select it is grey-out). The group appears to be locked by the
user/creator for a few days now (I stopped and started the database and
still it is locked). In the bank reconciliation screen, the Statement
option is grey-out as well. I run database conversion 6360 for that bank
account only (calculates bank balances) with the hope to release the
group. Still locked. Any ideas?

I am thinking on restore the database to my test database, and access
the table with ODBC and unlock the group that way and see what happens.

Thank you for all your suggestions.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.



[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
Whenever a bank statement is added in bank reconciliation, an A/P
payment group is created (you can view the group, but the OK option to
select it is grey-out). The group appears to be locked by the
user/creator for a few days now (I stopped and started the database and
still it is locked). In the bank reconciliation screen, the Statement
option is grey-out as well. I run database conversion 6360 for that bank
account only (calculates bank balances) with the hope to release the
group. Still locked. Any ideas?

I am thinking on restore the database to my test database, and access
the table with ODBC and unlock the group that way and see what happens.

Thank you for all your suggestions.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.



[Non-text portions of this message have been removed]
3
I've had problems with A/P check groups locked like that but I was always
able to clear it out by ending the locked user ID thru promon. If you have
stopped and restarted the db and it didn't clear it I would call tech
support.
-Sarah
4
Mario, did you first select a bank in bank reconciliation (Bank - Select
Bank)?



Matt



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mario Aguirre
Sent: Monday, May 15, 2006 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.0 Patch 535 - Bank Rec Group Locked



Whenever a bank statement is added in bank reconciliation, an A/P
payment group is created (you can view the group, but the OK option to
select it is grey-out). The group appears to be locked by the
user/creator for a few days now (I stopped and started the database and
still it is locked). In the bank reconciliation screen, the Statement
option is grey-out as well. I run database conversion 6360 for that bank
account only (calculates bank balances) with the hope to release the
group. Still locked. Any ideas?

I am thinking on restore the database to my test database, and access
the table with ODBC and unlock the group that way and see what happens.

Thank you for all your suggestions.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]
5
Yes, Matt. The bank account is selected and since the group is locked, I
cannot do anything else. I will contact support.

Thank you, Matt and Sarah.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of MATT FINN
Sent: Monday, May 15, 2006 1:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 6.0 Patch 535 - Bank Rec Group Locked


Mario, did you first select a bank in bank reconciliation (Bank - Select
Bank)?



Matt



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mario Aguirre
Sent: Monday, May 15, 2006 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.0 Patch 535 - Bank Rec Group Locked



Whenever a bank statement is added in bank reconciliation, an A/P
payment group is created (you can view the group, but the OK option to
select it is grey-out). The group appears to be locked by the
user/creator for a few days now (I stopped and started the database and
still it is locked). In the bank reconciliation screen, the Statement
option is grey-out as well. I run database conversion 6360 for that bank
account only (calculates bank balances) with the hope to release the
group. Still locked. Any ideas?

I am thinking on restore the database to my test database, and access
the table with ODBC and unlock the group that way and see what happens.

Thank you for all your suggestions.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


________________________________




[Non-text portions of this message have been removed]