From: Valentin on
Hi,

We have found solution for the Locking problem. Please look at:

http://www.rt-it-group.com/index.php?option=com_resource&controller=article&article=30&category_id=5&Itemid=60


Valentin

"Daniel Rimmelzwaan" wrote:

> Good luck, they have some pretty good people. I'm sure they will be able to
> help you get to the issues.
>
> "Darren Taylor" <DarrenTaylor(a)discussions.microsoft.com> wrote in message
> news:B5EA0D27-DCEF-4E74-A535-2439E3A7E362(a)microsoft.com...
> > Thanks.
> >
> > The other issue I have is we are on our second Partner, and I don't have
> > any
> > faith in our current one. They have lost all there experienced
> > consultants.
> >
> > Think I will just get Microsoft to get there experts over to our place and
> > perform an Audit.
> >
> > Thanks again for replying.
> >
> >
> > "Daniel Rimmelzwaan" wrote:
> >
> >> While it is very normal to have table locking, it seems a bit excessive
> >> that
> >> the system seems to only allow one person at a time to do any meaningful
> >> activity. There can be many factors at work here, ranging from network
> >> issues, to SQL Server setup (I am assuming you are on SQL Server), to
> >> application usage and code issues. Situations like these need to be
> >> analyzed
> >> in detail to be able to determine what the issues really are and what can
> >> be
> >> done about them. You could list each individual issue here in the
> >> newsgroup,
> >> but I'd consider involving your partner or an outside consultant.
> >>
> >> Daniel Rimmelzwaan
> >> MVP Dynamics NAV
> >> www.risplus.com
> >>
> >> "Darren Taylor" <DarrenTaylor(a)discussions.microsoft.com> wrote in message
> >> news:668FF59F-D2D1-4EC3-81A7-8CFBD9E5C2CF(a)microsoft.com...
> >> > Our biggest problem is NAV completely locks some table during
> >> > posting/processing. This is the reason why only one user can post a
> >> > Purchase
> >> > order at a time, only one accounting user can post a G/L Journal at a
> >> > time,
> >> > one Item Journal posting at a time, etc. Especially, during Purchase
> >> > Order
> >> > posting, NAV has to lock Production orders, routes, and components
> >> > tables.
> >> > This requires the Production Order data entry clerk to wait for PO
> >> > processing
> >> > to finish before it can enter and save production order information
> >> >
> >> > Is this Correct?
> >> >
> >> > Sounds like our Partner has set-up our system incorrectly to me.
> >> >
> >>
>
>