Month: August 2010
Great Plains Maintenance and Recovery Procedures
The Great Plains system is designed to ensure maximum accuracy and integrity of your accounting data. Occasionally, however, your data tables may become damaged. Hardware failures, power surges, and other problems can damage or destroy data.
While damage occurs infrequently, the factors that cause it are difficult to predict or control, and it’s necessary to take measures to protect your data. Regularly back up your accounting data and perform table maintenance to minimize risk of data loss from table damage.Only SA or DYNSA can open the Backup Company window to make backups. The backup procedure must be run on the server.
Read the Complete article here GP Maintenance
AA Transaction Error – Primary Key Voilation
There are quite a few errors comes in AA which are not highlighted in the knowledge base articles.
Transaction dimensions can’t able to be saved. System had thrown you the following message
- ‘Primary key violation error on table AAG00600. Cannot insert duplicate records on table’ along with that message there was another saying
- ‘The stored proc aagCreateTree returned the following results. DBMS: 2627, Great Plains: 0’.
Resolution
This problem is due to the aaTreeID which is the primary key violation of AAG00600. In order to rectify it follow the process below.
Run all the below steps in SQL Server Query Analyser
Step 1:- select * from dynamics..sy01500 (used to know the company id)
Step2:- select * from dynamics..aag00102 where aatableid = 600 (‘600’ is the source aa table ID for which the corresponding aaRowID mentioned is the last rowid inserted in AAG00600 for the corresponding is company ID)
Step3:- select * from two..aag00600 (look for the aaTree ID were the last record inserted is holding the same ID as that of the aaRowID in aag00102 table)
Step4:- update dynamics..aag00102 set aarowid = 14 where dex_row_id = 4
Find Missing / Deleted Journal Entry in Microsoft GP
When your company auditor ask for all the missing or deleted Journal entry, it’s not a big task now you can get it in minutes by running the script below in your SQL query analyser.
If Object_Id(‘tempdb..#tempJV’) is Not Null
Drop table #tempJV
create table #tempJV
(JVno int,MJV int identity(1,1))
insert into #tempJV (JVno)
(select distinct JRNENTRY from GL20000 )
select wg.MJV as id_is_missing
from #tempJV wg left join #tempJV ti on wg.MJV = ti.JVno
where ti.JVno is null order by wg.MJV
Keep visiting this site for more Dynamics Tips… J
Dynamics Management Reporter
Management Reporter is a specialized financial reporting solution that allows users to create powerful reports in minutes. This application allows executives, managers, and front-line employees to gain access to the information they need when they need it and where they need it. There are 3 basic building blocks in Management Reporter.
The first building block is called a row definition. A row definition defines the descriptive lines (for example, sales or sales returns) on a report. It also lists the account codes or dimensions that contain the values for each line item and includes row formatting and calculations.1
The second building block is called a column definition. 1 A column definition defines the time period to use when extracting data from the financial data source. It also includes column formatting and calculations.
The third building block is called a reporting tree definition. A reporting tree definition is similar to an organizational chart. It contains individual reporting units that represent each box in the chart. These units can be either individual departments from the financial data or higher-level units that summarize data from other reporting units.
Together these three building blocks give users the flexibility to define a virtually unlimited number of reports to meet their business needs. The report definition process is designed in such a way that the average end user can get access to the critical business information they need quickly and easily.
Another feature built into Management Reporter that simplifies the report creation process is the Report Wizard. The Report Wizard gives you the choice between creating one of five different financial reports including a balance sheet, three types of income statements and a trial balance.
Resetting GP 2010 System Password
Forgot your GP System Password? GP Administrator relax, you can now reset System password with the below trick, but be careful using this trick
Run the below script in SQL Server Management studio
USE DYNAMICS
GO
Update SY02400 Set Password = 0X00202020202020202020202020202020
Keep watching this blog for more tricks on GP…….. J
Enhanced Email Option in Microsoft GP2010
Download complete article Download Here
Improved Home Page Metrics for Dynamics GP2010
The metrics, charts, and KPI’s that are available on the Microsoft Dynamics GP Home Pages now leverage SQL Server Reporting Services (SSRS) reports. This enables greater flexibility for our customers in regards to the metrics that are displayed and how they can be accessed which are easily build on SSRS.
- Metrics built using Office Web Components are still available to the users
- Customers can choose SQL Server Reporting Services as their metric source
- Over 100 fully customizable metrics that can appear on the Microsoft Dynamics GP Home Page
- Companies can easily create their own metrics they want displayed on the Home Page
- Metrics are part of the SQL Server Reporting Services Deployment Wizard
- Metrics may be deployed to SQL Reporting Services in either Native or SharePoint mode
- Reporting Services metrics will appear in the SQL Reporting Services Report List; making them available to add as links on the Home Page
- All metrics are available to use in Business Portal as well.
- Users can display multiple metrics on the Home Page at one time, or display just one at a time with the option to scroll through the metrics
How to Setup the Reports?SSRS reports setup is just a screen away provided you have installed SQL Server Reporting Services (SSRS) if not please follow the instruction provided with SQL server installation document. Assuming you have installed SQL Server Reporting Services (SSRS) follow the steps below.
- Install SRSReports which are under GP2010 installation CD/DVD as additional products.
- Configure SSRS reports for GP open Programs >> Microsoft Dynamics >>Business Intelligence >>Microsoft SQL Server Reporting Service Wizard.
- Follow the instruction on the wizard and provide the reportserver path and select the company you want to install SSRS Reports for GP.
-
Once done login to GP and navigate to Tools>>Setup>>System>>Reporting Tools setup.
-
There is an important thing that needs to be looked into while configuring the reporting tools for GP, while entering the Report Server URL make sure you enter the URL properly
- If SQL Server 2005 Reporting Service is installed then the path should be http://localhost/ReportServer/reportingservice.asmx
- if SQL Server 2008 Reporting Service is installed then the path should be http://localhost/ReportServer/reportingservice2005.asmx
- Under the Charts and KPI’s Section mark only the Option Enable SQL Server Reporting Service Home Page Metrics
Note: Do not mark Charts and KPI’s have been deployed to a sharepoint Server, if you mark this option then you will not be able to view the charts and KPI’s under the Home page Metrics. - Click OK and close the Reporting Tools Setup Window
- That’s All folks.
Adding Custom Charts or KPI’s to Home PageMicrosoft Dynamics GP2010 has made easy to add custom reports which is another powerful and important feature that has made GP2010 customer/user build their own analysis. Follow the below steps to add Custom Reports or KPI’s to GP Home Page.
- Deploy the custom report under the Reporting Services for this open SSRS Report Manager and Click on the Company folder
- Identify your custom report to make sure it is added under proper module.
- Click on the module you identified and click Charts And KPI’s Folder.
- Deploy your reports under this Folder and give the Proper name that can be viewed under Home Page Metrics Selection in GP2010.
Hope this helps to add your Custom Charts and KPI’s to GP2010 Home Page, for any queries and new Charts to be build contact venuasg@gmail.com
If Check Voided by mistake in Microsoft Dynamics GP
You issue a check to a supplier and then someone erroneously voids that check. How do you recover from this without having to contact the vendor, issue a new check, and stop payment on the old one?
Follow the 7 Steps below
- First Navigate to Cards>>Financial>>Checkbook
- Select the checkbook from which the check was issued. If the Duplicate Check Numbers checkbox isn’t checked, check it.
- Click Save. Leave the Checkbook Maintenance window open. We’ll be coming back to it.
- Navigate to Transactions>>Purchasing>>Manual Checks and create a manual check to replace the check (in the system) that was voided. Change the Document Number to the check that was inadvertently voided. Post the transaction.
- You now have a replacement check in the system for the one that was voided that can be cleared in Bank Rec when the supplier deposits the original check.
- Document the heck out of this because you’ll now have two checks in the system with the same check number, one voided and one not. And sure as can be, this check will be selected during audit.
- Go back to the Checkbook Maintenance window and uncheck Duplicate Check Numbers.
Deleting an Item in Microsoft Dynamics GP
Before you can delete an item from the item master; there are a number of conditions that must exist. First make sure that:
- There should be no quantities of the item are on hand at any site.
- There should be no allocated quantities of the item at any site.
- The item is no longer assigned to any site.
- There are no un-posted transactions for the item exist (work transactions in IV and other modules that update IV like POP, SOP).
- The item is not a component in any bills of materials in Dynamics GP. Refer to the ‘Bill of Materials’ documentation for more information.
- No inventory history exists for the item.
If any one of the above condition fails you will not be able to delete the item.
Microsoft Dynamics AX Architecture
Understanding the internal architecture of Microsoft Dynamics AX can help you make decisions when planning and developing a Microsoft Dynamics AX system. Here are some pointers on DAX architecture primarily for DAX architects & solution developers.
System Architecture
This diagram provides a high-level overview of a Microsoft Dynamics AX system with all components installed, and describes how communications flow among components.
Application Object Server (AOS) Architecture
This diagram describes the functionality within the AOS Windows service, and describes how communications flow within it.
Application File Server Architecture
This diagram below describes the application file server.
Client Kernel Architecture
This diagram below describes the functionality within the client kernel, and describes how communications flow within it.
Business Connector Architecture
The differences between the client kernel as it runs on a standard client and a Business Connector client are:
– The Session Manager in the client kernel manages only a single instance–in the Business Connector kernel, it manages multiple instances.
– The client kernel includes forms security, while the Business Connector kernel does not.
This diagram describes the architecture of the Business Connector version of the client kernel, and describes how communications flow within it.
Application integration framework Architecture
This diagram below describes the functionality within the application integration framework, and describes how communications flow within it.
Enterprise Portal Architecture
This diagram below provides a logical overview of a Microsoft Dynamics AX system with an Enterprise Portal server, and describes how communications flow within it.
Reporting Server Architecture
This diagram below provides a logical overview of a Microsoft Dynamics AX system with a reporting server, and describes how communications flow within it.
Dynamics Tips 