Wednesday, April 10, 2013

How to delete a company in MS Dynamics GP

You have to delete the company in GP first then from the database from SQL.

Steps: 
1. MS Dynamics GP Menu>>Tools>>Utilities>>System>>Delete Company.
2. Enter the system password if necessary.
3. Open the lookup then select the company that you want to delete.

by this you just deleted the company from GP only

4. Open the SQL management studio.
5. Open the databases.
6. Right click on the database you want to remove and click delete.

Tuesday, April 9, 2013

MS Dynamics GP:- This batch is being posted by another user

You get this message even though nobody is logged in to the database so that it's impossible for the batch to be being posted by somebody else. What to do?
  1.  Back up the DYNAMICS and company databases.
  2. Change the batch status so that it no longer thinks it's being posted.
USE TWO
GO

UPDATE SY00500 set BTCHSTTUS = 0 WHERE BACHNUMB = 'Batch ID'