CompanyR.dic and CompanyF.dic needs to be Upgraded to the Company.

Hello Everyone,

Today I got an issue like When i logined in to GP ,i got a error please see the below Image:

IPC01R

I found the Solution for this,please follow the below steps:

1)Before changing the Dynamic.set file take a backup ,and edit the Dynamics.set file.

2)In first row of the text file decrease the count of the number for example if number 23 decease the number 22.

3)Remove the Company name and number like

Company name:XXX

number:123

and delete the Company.dic and CompanyR.dic and CompanyF,dic.

Save the Dynamics.set and go to the Data folder in the Dynamics GP Application Folder.

Remove the CompanyR.dic and CompanyF,dic.

In Dynamic Application folder delete the Company.dic file also.

now put the latest Chunk file in Dynamic Application folder.

Now login into Dynamics GP that error will be Resolve.

Hope this will help you..!

Thanks

Nizamudeen syed

Posted in Uncategorized | Leave a comment

VBA Modifier Forms in Dynamics GP ,Would not show the Data.

If Customized VBA Forms wont reflect the data ,Please follow the Steps.

1)Take the backup of packages from

Microsoft Dynamics GP–>Tools–>Customize–>Customization Maintenance.

Export all packages like Select all and Click on Export,save the package.

2)Go to the Microsoft Dynamics GP Application folder.

Select the FORMS.DIC , REPORTS.DIC from Data Folder and Select the Dynamics.vba file take a backup of there files ,and delete the files from folder.

And then login in to GP as Administrator and go to the same as mentioned above path:

Microsoft Dynamics GP–>Tools–>Customize–>Customization Maintenance.

Select all packages and click on Import Button,it will asks us to select  file to import, select the file from which you have  taken a back up of all packages file or Is any do u have an backup of packages from any Server .

Import the data and refresh the GP and check the forms which is modified through VBA.

Hope this will help you..!

Posted in Uncategorized | Leave a comment

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’. Could not use view or function ‘ExtendedCatalog’ because of binding errors.

For this Error ,we need to check some of basic information,in your SQL Server management  check on DB’s list like:

ReportServerTempDB is available or not, if not?

then go to to MS-SQL 2008 r2 Installation folder and Check there ReportServerTempDB.mdf, ReportServerTempDB_log.ldf’ are available or not?

If Yes.

Then Follow the Below Solution

CREATE DATABASE ReportServerTempDB

ON (FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB.mdf’),
(FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB_log.ldf’)
FOR ATTACH;

And then Rn your SSRS Report,paste the SSRS Report URL in Internet ,here you can see the Report.

Hope This will Help you…!

Posted in Uncategorized | Leave a comment

Error message when you import purchase orders into Microsoft Dynamics GP from Microsoft Retail Management System Headquarters: “7321-Decimal places passed in for UNITCOST does not match setup”

select * from  IV00105 where  itemnmbr=’OFC’

 –update IV00105 set DECPLCUR = 5 where  itemnmbr=’OFC’

Posted in Uncategorized | Leave a comment

How to filter Empty or Null Values IN Smart list Report.

Please Look into the Image:

image

Here We have been filtering the two cases,like

1)In Report 1099 Type is not Equal to “Not a 1099 Vendor”.

2)Second filter is for removing Empty or Null values from Report.

Select Column name and  filter the option as “is equal to” and give empty .

Then we will have output related omitting the Null values or Empty values from Report.

Posted in Uncategorized | Leave a comment

“Prevent saving changes that require the table to be re-created” negative effects”

I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2).

I got the usual error “The changes you have made require the following tables to be dropped and re-created” from SQL Server.

I know there is the option in Tools-> Options -> Designer -> Table and Database Designers -> Uncheck the box Prevent saving changes that require table re-creation,

Posted in Uncategorized | Leave a comment

An incorrect company appears in the Company drop-down list when you try to log on to Microsoft Dynamics GP

Symptoms:When you try to log on to Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains 8.0, an incorrect company appears in the Company drop-down list in the Company Login window. The incorrect company is either a duplicate of your company or a company that does not exist.

Cause:This problem occurs because a duplicate record or an invalid record refers to the companies in the tables in the DYNAMICS database.

Resolution:

To resolve this problem, use one of the following methods.

Method 1

If the incorrect company is a company that does not exist or a duplicate of an invalid company, use this method.

Notes

  • The following ClearCompanys.sql script is a script to remove all entries in the DYNAMICS database that refer to the databases that no longer exist on the computer that is running Microsoft SQL Server.
  • Before you run this script to remove the company database from the tables in the DYNAMICS database, you must remove the company database from the computer that is running SQL Server.
  • Before you use this method, make sure that you have a complete backup copy of the database so that you can restore the database if a problem occurs.

To use this method, run the ClearCompanies.sql script to remove incorrect records that refer to companies from the DYNAMICS database. To do this, follow these steps:

  1. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

    Method 1: For SQL Server Desktop Engine

    If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

    Method 2: For SQL Server 2000

    If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point toMicrosoft SQL Server, and then click Query Analyzer.

    Method 3: For SQL Server 2005

    If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

    Method 4: For SQL Server 2008

    If you are using SQL Server 2008, start SQL Management Studio. to do this, click Start, point to All Programs, point toMicrosoft SQL Server 2008, and then click SQL Server Management Studio.

  2. Run the following ClearCompanies.sql script:
    set nocount on
    
    /* Remove all references in the company master table (table SY01500) for databases that do not exist on the Microsoft SQL Server server. */
    delete DYNAMICS..SY01500 where INTERID not in
                (select name from master..sysdatabases)
    
    /* Remove the tables from the DYNAMICS database if the CMPANYID value of the table does not match any company IDs in table SY01500. */
    USE DYNAMICS
    declare @CMPANYID char(150)
    declare CMPANYID_Cleanup CURSOR for 
    select 'delete ' + o.name + ' where CMPANYID not in (0,-32767)'
    + ' and CMPANYID not in (select CMPANYID from DYNAMICS..SY01500)' 
    	 from sysobjects o, syscolumns c
    		where	o.id = c.id
    		    and o.type = 'U'
    		    and c.name = 'CMPANYID'
    		    and o.name <> 'SY01500' order by o.name
    
    OPEN CMPANYID_Cleanup
    FETCH NEXT from CMPANYID_Cleanup into @CMPANYID
    
    while (@@FETCH_STATUS <>-1)
    begin
    
    	exec (@CMPANYID)
    	FETCH NEXT from CMPANYID_Cleanup into @CMPANYID
    
    end
    
    DEALLOCATE CMPANYID_Cleanup
    go
    
    /* Remove the tables from the DYNAMICS database if the companyID value of the table does not match any company IDs in table SY01500. */
    USE DYNAMICS
    declare @companyID char(150)
    declare companyID_Cleanup CURSOR for 
    select 'delete ' + o.name + ' where companyID not in (0,-32767)'
    + ' and companyID not in (select CMPANYID from DYNAMICS..SY01500)' 
    	 from sysobjects o, syscolumns c
    		where	o.id = c.id
    		    and o.type = 'U'
    		    and c.name = 'companyID'
    		    and o.name <> 'SY01500'
    set nocount on
    OPEN companyID_Cleanup
    FETCH NEXT from companyID_Cleanup into @companyID
    while (@@FETCH_STATUS <>-1)
    begin
    
    	exec (@companyID)
    	FETCH NEXT from companyID_Cleanup into @companyID
    
    end
    
    DEALLOCATE companyID_Cleanup
    go
    
    /* Remove the tables from the DYNAMICS database if the db_name value of the table does not match any company names (INTERID) in table SY01500. */
    USE DYNAMICS
    declare @db_name char(150)
    declare db_name_Cleanup CURSOR for 
    select 'delete ' + o.name + ' where db_name <> ''DYNAMICS'' and db_name <> ''''
     and db_name not in (select INTERID from DYNAMICS..SY01500)' 
    	 from sysobjects o, syscolumns c
    		where	o.id = c.id
    		    and o.type = 'U'
    		    and c.name = 'db_name'
    
    set nocount on
    OPEN db_name_Cleanup
    FETCH NEXT from db_name_Cleanup into @db_name
    
    while (@@FETCH_STATUS <>-1)
    begin
    
    	exec (@db_name)
    	FETCH NEXT from db_name_Cleanup into @db_name
    
    end
    
    DEALLOCATE db_name_Cleanup
    GO
    set nocount on
    
    /* Remove the tables from the DYNAMICS database if the dbname value of the table does not match any company names (INTERID) in table SY01500. */
    USE DYNAMICS
    declare @dbname char(150)
    declare dbname_Cleanup CURSOR for 
    select 'delete ' + o.name + ' where DBNAME <> ''DYNAMICS'' and DBNAME <> ''''
     and DBNAME not in (select INTERID from DYNAMICS..SY01500)' 
    	 from sysobjects o, syscolumns c
    		where	o.id = c.id
    		    and o.type = 'U'
    		    and c.name = 'DBNAME'
    
    set nocount on
    OPEN dbname_Cleanup
    FETCH NEXT from dbname_Cleanup into @dbname
    
    while (@@FETCH_STATUS <>-1)
    begin
    
    	exec (@dbname)
    	FETCH NEXT from dbname_Cleanup into @dbname
    
    end
    
    DEALLOCATE dbname_Cleanup
    GO
    set nocount on
    
    /* Remove all stranded references from the other Business Alerts table that do not exist in table SY40500. */
    delete SY40502 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
    delete SY40503 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
    delete SY40504 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
    delete SY40505 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
    delete SY40506 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
    GO
    
  3. Log on to Microsoft Dynamics GP or Microsoft Great Plains 8.0 again.

Method 2

If the incorrect company is a duplicate of a valid company, use this method to reconcile the User-Company Access table. To do this, follow these steps:

  1. Log on to Microsoft Dynamics GP or to Microsoft Great Plains 8.0 as the sa user.
  2. In the Company Login window, click the company that you want to use in the Company drop-down list, and then click OK.
  3. Use the appropriate method:
    • In Microsoft Dynamics GP 10.0, click Microsoft Dynamics GP, click Tools, click Utilities, click System, and then click Reconcile.
    • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions – Great Plains 8.0, click Tools, click Utilities, clickSystem, and then click Reconcile.
  4. In the Reconcile window, click User-Company Access in the Tables pane, and then click Insert. After you do this, theUser-Company Access table appears in the List to Reconcile pane.
  5. Click Reconcile.
  6. In the Report Destination window, click to select one or more of the following check boxes in the Destination area:
    • Screen
    • Printer
    • File
  7. Click OK.
  8. Exit Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains 8.0.
  9. Log on to Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains 8.0 again.
Posted in Uncategorized | Leave a comment