We are all aware of certain tasks in Dynamics GP that require knowledge of SQL Query Language and access to the SQL Query Tools, but unfortunately not all users have this knowledge or access.
Well what you may not be aware of it the fact that Microsoft has created automated solutions to address some of these issues. These solutions can be found in the support section of CustomerSource. You need to make sure you have a current enhancement plan so you can access CustomerSource. (This is a good reason to keep your enhancement plan current.)
Solutions include:
-Bank Rec Reconcile Error
-Deposit Edited by Another User
-Rebuild Account Index
-GL Out of Balance SQL
-Trial Balance out of Balance
-Year End Close Checklist
-Copy Human Resources Setup
-Payables Duplicates
-Clear Payroll Activity
-Purchase Order being Edited by Another User Error
-RM Reconcile Can't Be Completed
-Receivables Duplicates
-SOP Document Edited by Another User
-Duplicates in SOP
-Cannot Post Batch
-Copy Company Setup
-Delete Company in Dynamics GP
-Unable to Log in to Dynamics GP
and more....
Most of these tools do require the SA login, but they do not require SQL Query Tools. These are possibly good options if you have one of these issues.
Of course always make sure you have a current backup of your database prior to using any of these tools and if you need assist you can contact Collins Computing.
Well what you may not be aware of it the fact that Microsoft has created automated solutions to address some of these issues. These solutions can be found in the support section of CustomerSource. You need to make sure you have a current enhancement plan so you can access CustomerSource. (This is a good reason to keep your enhancement plan current.)
Solutions include:
-Bank Rec Reconcile Error
-Deposit Edited by Another User
-Rebuild Account Index
-GL Out of Balance SQL
-Trial Balance out of Balance
-Year End Close Checklist
-Copy Human Resources Setup
-Payables Duplicates
-Clear Payroll Activity
-Purchase Order being Edited by Another User Error
-RM Reconcile Can't Be Completed
-Receivables Duplicates
-SOP Document Edited by Another User
-Duplicates in SOP
-Cannot Post Batch
-Copy Company Setup
-Delete Company in Dynamics GP
-Unable to Log in to Dynamics GP
and more....
Most of these tools do require the SA login, but they do not require SQL Query Tools. These are possibly good options if you have one of these issues.
Of course always make sure you have a current backup of your database prior to using any of these tools and if you need assist you can contact Collins Computing.
