Re: [Axapta-Knowledge-Village] Re: Interface Axapta HR to Payroll System

2004-09-13 Thread Bob Mathews
Ravi, I am just comming out of the webcast presented by you on MBS Axapta. It was really great! Hope you willl have couple of sessions like this again Also if you could throw some more information on Benifits management and HR in general,it would be great. Do you have a write up or PPT or

[Axapta-Knowledge-Village] Exclusive Table locking in SQL

2004-09-13 Thread subhamit59
Anyone knows how to get rid off exclusive table locking in SQL because our users cannot work due to X TAB locks. The system is heavily loaded with transactions on SQL2000 SP3a. The memory usage on SQL seems to stay at around 100% from the 3Gb. The SQL server has DUAL processors The SQL is

[Axapta-Knowledge-Village] Re: Exclusive Table locking in SQL

2004-09-13 Thread moak_uk
I have had same problems. In Administration - Inquiries - Database - locking database users. This helps identify the SPID of the user that's causing the locking. If you go to Query Analyser - type in sp_who bmssa or sp_who. This gives you the user list and you can figure out which user (spids)

RE: [Axapta-Knowledge-Village] Exclusive Table locking in SQL

2004-09-13 Thread Preston A. Larimer
Here are some notes I have, in addition to these the users should set the credit check on the other tab of the saleseditlines form to none when invoicing, doesnt make sense to check credit limits when creating an invoice. -Preston Axapta 3.0 Locks Up During Sales Order Update If

[Axapta-Knowledge-Village] Axapta Credit Checking

2004-09-13 Thread frodnew57
Is anyone aware of a good write up describing the functionality and interaction of the following Axapta credit functions? 1. Customer File - Mandatory Credit Check (this switch does not appear to affect how the system works) 2. Customer File - Credit Limit (This is fairly self-explanatory) 3.