In Touch with Dynamics GP

This blog is intended to be a useful resource for Microsoft Dynamics GP users and professionals in the UK and the wider Microsoft Dynamics GP community as a whole.

Tuesday, 26 April 2011

Dynamics GP Bank Management - Checkbook [checkbook id] is already in user by user [username].

Hi folks I have been quiet for a while as we have been exceptionally busy here a Touchstone and something had to give somewhere and that was the blog I am afraid.


Anyway I have just spent a rather frustrating half an hour trying to resolve a support case, where I could find no mention of the fix under partnersource or elsewhere on line despite this being a standard error message. Therefore I thought I would post this out there to save everyone else the frustration.

The error message is “Checkbook [checkbook id] is already in user by user [username]” or if you’re in the UK “Chequebook [chequebook id] is already in user by user [username]”.

This message was occurring when the user had crashed out of a reconcile and then tried to re access the reconcile window Transactions>Financial>Bank Management>Reconcile.

We had tried Clearing the Bank Management ACTIVITY under routines>financial>Bank Management but we still got the message.

We also tried clearing the DEX_LOCK and DEX_SESSIONS from the tempdb by running delete statements against both, but we still got the message.

We had checked the Contents of the CB100006 as suggested in an article by VAIDY however there was nothing here either.

http://community.dynamics.com/product/gp/gptechnical/b/gplearn/archive/2010/04/12/cbm-checkbook-91-checkbook-id-93-is-already-in-user-by-user-91-username-93.aspx

In the end though we needed to remove a record from the CBEU1020 CE ACTIVITY table.

select * CBEU1020 returned the locked record.

Then we ran a delete statement (as there was only one record in there)

Delete CBEU1020

And the issue was resolved.

4 comments:

  1. Hi,

    The above mentioned table is specifically for EURO Enabled currencies based Checkbooks.

    We have to be looking at both CB10006 and CBEU1020 tables for any activity locks, just in case.

    Vaidy

    ReplyDelete
  2. Check book setup is recommended to have a single cash account for every single check book. Check Ordering

    ReplyDelete
  3. apartments
    Free Parking Software for Town Houses, Condominiums, and Businesses Solves Parking Problems
    Searching for a parking space is such as frustrating routine activity for lots of people in cities all over the world. This search is burning over a million barrels of oil of the world each day. There are also 4-parking spaces every vehicle in the US and almost all streets are most of the time, empty, which leads to urban environments that are ironically doing far more to accommodate the vehicles than people. As the global population continuously urbanize, without a convenience-driven and well-planned retreat from cars, these sort of parking problems will worsen.
    http://webparkingsoftware.com software is the first step in the right decision. It involves using low-cost sensors, mobile phone-enabled, and real time data collection automated payment systems enabling people to reserve parking in advance or predict accurately where they can find a spot. When deployed as a system, free parking software thereby reduces car emissions in the urban centers by means of reducing the necessity for the people to circle the city blocks needlessly searching for parking. Furthermore, it permits the cities to manage their parking supply carefully.
    This free parking software is now being developed in many different states and cities around the United States and some other countries. For instance, in LA, smart meters and low-power sensors are tracking the occupancy of parking spaces across the Hollywood district, one of the most congested areas. The users will be able to access this occupancy data in order to determine the availability of the spots and then pay for them with their mobile phones. Other than the environmental benefits and lending convenience, free parking software is improving the utilization of the current parking, which lead to greater revenue for parking owners.
    These programs will be able to make great differences on a neighborhood level, but more widespread development and deployment is necessary for free parking software to change the cities and to contribute to the transportation sector pollution reductions greenhouse gas. One problem is that there are no citywide solutions all over the fragmented private and public parking providers. The occupancy data has a tendency to have many owners and is not accessible or standardized in a way that may enable software developers to turn into user-friendly applications. Thereby, individual smart parking efforts are so far successful locally, but uncoordinated, and operates in their own entrepreneurial or bureaucratic vacuums without a need to take gap between current free parking software and more widespread transportation system planning is an enormous missed opportunity for the cities to reduce the transportation related emissions.
    Moreover, free parking software has been hindered by a lack of insight into the complete benefits of this software, specifically when compared to the cost of building extra parking spaces. Lack of collaboration between communities with the parking software programs, as well as lack of coordination between hardware providers, municipalities, and developers is also contributing to the slower adoption of smart parking. Nevertheless, it is possible to overcome all these issues. Cities will be able further accelerate these advantages by means of updating the land use and building codes policies to reflect the reduced need for parking.

    ReplyDelete
  4. Most of the time when you order checks the banks merely order the checks for you thru other check printing companies. currently you may be ready to order bank checks yourself directly online.Check Ordering

    ReplyDelete