Great Plains    Dexterity    Dynamics     eEnterprise     Microsoft CRM    Microsoft RMS    Crystal Reports    SQL   .Net    C#      International    Forum

 

Past Forum Archive

Alba Home

 

If you do not see your problem listed here, you are more than welcome to email us for free answer: help@albaspectrum.com

Or call our technical support for free reasonably short consultation: 1-630.854.0597, also go to our home page www.albaspectrum.com

 

Date

Poster

Message

Text

10/5/2003

Inga

Moving Great Plains from one SQL Server to another

Hi, I did backup of DYNAMICS and my company databases on the old server, then I created the databases on the new server with similar names and now I am trying to restore them from the backups of my old server and getting error message: Device activation error. The physical file name .... maybe incorrect? Any suggestions?

10/5/2003

Andrew

Re: Moving GP from one server to another

Inga, Message you are getting indicates that physical files location of data and log files on the new server is different. In the old server you may have somewhat like C:\MSSQL7\Data\GPSDYNAMICSDat.mdb and on the new server you may have C:\Program Files\...\Data\GPSDYNAMICSDat.mdb. When restoring you need to switch Options tab on restore database screen, mark restore over existing database and edit restore as string.

10/5/2003

Inga

Thanks but...

Now I have databases restored, but I can not login into Great Plains.???

10/5/2003

Andrew

Great Plains creates its own logins and database roles

This is why you can not login. The easiest way around is to first create the same databases by installing Great Plains on the server from installation CDs and then reload DYNAMICS and company databases from backups.

10/5/2003

Inga

I created databases and loaded from backup,..

now users can not login, however when I use sa - it works???

10/5/2003

Andrew

Users are logins in master database

and since you did fresh installation of SQL - new master database doesnt have user logins in it. There is special techknowledge on Great Plains support website, which you could try. Another approach is to create new users (however user logins should be different) in great plains and reassign security to new users. This is good approach is you have just a few users

10/5/2003

Inga

Thanks!!!

Now. It is working! Thanks a lot, Andrew!

 

Date

Poster

Message

Text

10/6/2003

Jorge

MS SQL Enterprise manager doesn't work after GP workstation installation

Hi, I have no clue - I just followed Great Plains installation procedure. And when Great Plains workstation was installed - my MS SQL Server Enterprise manager doesn t work. Any clues?

10/6/2003

Andrew

This is probably known issue about FRx installation

Jorge, Have you installed FRx as part of your Great Plains installation procedure? If so - this is known issue. You have to reintall MS SQL client tool, which will fix one of the dlls corruption, caused by FRx client install.

 

Date

Poster

Message

Text

10/7/2003

Mike

MS CRM Shuts down the browser

When you try to open MS CRM in Explorer it shuts down the browser in trying to open. It happens on some PCs and doesn t on others. ???

10/7/2003

Andrew

It is because of pop-ups stopper

Mike, What Microsoft CRM does - it re-opens the browser and in the new instance of the browser you do not see toolbar and address bar. When you open the browser in such a manner - pop-up stopper shuts it down, misidentifying as a pop-up. You should disable pop-up stopper Andrew

 

Date

Poster

Message

Text

10/8/2003

George

"This batch is edited by another user" message - how to enable for posting?

I guess computer was shut down when posting was in progress. Need to enable the AP batch for posting.

10/8/2003

Bernard

How to enable stuck batch for posting

In company database, in SY00500 (posting definition master table), change: BCHSTTUS (batch status) to 0 and MKDTOPST (marked to post) to 0 also in DYNAMICS databse remove the line for this batch from SY00800

 

Date

Poster

Message

Text

10/8/2003

Mark

I am developer, need a clue on how to link asp page with MS CRM

Well, we have legacy asp application, which sits in old IIS and we do not want to touch it. Now we are moving our intranet business system into MS CRM. We need to open asp pages with the data transferred from CRM and security credentials and from asp we need to call back to CRM and create activity there. What is the best way?

10/8/2003

Andrew

How to integrate asp with CRM

Mark, To get maximum of the integration you need: 1. From CRM Account/Contact or other window with the button placed there call the ASPX application which will pull all the additional information from CRM to be transferred to asp page. This application should use MS CRM SDK and the best language to use is C#, because MS has all the sample in SDK in C# 2. The application in #1 calls legacy asp page with parameters transferred in url 3. ASP page calls HTTP handler (which you need to create in VS.NET c# or vb). This HTTP handler will call Web Service (which will use MS CRM SDK functionality - you should create this service in VS.NET). This web service will create activity in MS CRM, And again - this is just the directions, no details in here. Andrew

 

Date

Poster

Message

Text

10/8/2003

Helen

Bonus Depreciation in Great Plains?

In the first I must depreciate additional 30 or 50%. Can not do it in my old application, we plan to switch to GP. How do you do it in Great Plains?

10/8/2003

Andrew

Bonus Depreciation in Great Plains

Helen, In Great Plains this functionality is included. In cards ->fixed assets-> book you have field Special Depreciation Allowance, which can be enabled and if so it defaults to 30% additional depreciation for the first year. You can change it to 50%. Andrew

 

Date

Poster

Message

Text

11/15/2003

Joe

User locked in Great Plains

Well, we don t have support from Microsoft/Great Plains, but we need to resolve this Pervasive SQL issue. I think computer crashed when user was logged in. Now I have message in login that user is already logged in??? Please help

11/15/2003

Andrew

Unlock the user in Great Plains

Go to System->(enter password)->User Activity and delete user from the scrolling window. For Pervasive SQL admins: you can ask all the users log off and delete activity.btr file in system folder of your Dynamics system folder on the server. For SQL admins: ask all the user log off and run delete activity statement against DYNAMICS database. If you still have problems with the locked users or any others, please post here and we will try to answer. Alba technical support team: Andrew, Bernard, Imad, Larissa

 

Date

Poster

Message

Text

12/10/2003

john

RMS: Cherry keyboard problem

Magnetic card reader/Cherry keyboard doesn t work with RMS. It tries to place all the Credit card info: number, name, expiration, etc. into credit card number field

12/14/2003

Andrew

Cherry Keyboard in RMS

John, You should program your Cherry keyboard. Please visit Cherry support site at http://support.cherry.de/english/new_faqkb.asp?faqbid=236 Andrew

12/14/2003

Andrew

Cherry Keyboard in RMS

http://support.cherry.de/english/new_faqkb_list.asp is more accurate, then look for QuickSell on the page Andrew

 

Date

Poster

Message

Text

1/16/2004

Peter

Kiwell MAX Problem on Pervasive SQL

We are having error message 86 from Pervasive SQL when trying to do Inventory transactions in Max. We are on Pervasive SQL.2000 sp1 on the WS

1/16/2004

andrew

Kiwell Max Pervasive SQL.2000 issue

Peter, Some customers reported that they had similar problem when thery stayed with Pervasive SQL.2000 while the server was upgraded to Pervasive SQL.2000i (this is SP3 or SP4). We had similar issue and had to upgrade clients to SP3. Hope this will give you the direction. In general - our opinion - this is cinflict between SP1 or SP2 of Pervasive SQL.200 and new redesign of Pervasive SQL.200(i) released as SP3
Date Poster Message Text
2/22/2004 Jim RM Batch posting problem I think computer lost power while posting Receivables batch. Now I see the deposit record in Aging report, but document (deposit with the number from report) doesn t exist. How do I fix it?
2/22/2004 Andrew Re: RM Batch posting problem You have to remove deposit record in RM00401 table and then change applied amount in RM20101. Let us know if you need further help. Andrew
1
Date Poster Message Text
3/16/2004 Ian Webster Var in South Africa Hi there We are a Ms var in S.A specializing in dex development. We are currently looking into deploying our dex chunks with MSI files. Have you guys experimented with this ? We are also looking into intergrating CRM with great plains if you could send us any info on these two subjects it would be great thanks Ian Webster
3/18/2004 Andrew Var in South Africa Ian. We do follow traditional cnk file approach, however I do understand your points. We have to consider this when Dexterity customization used COM objects to call web services – in this case it would be nice to have MSI installation. Regarding integration, you have the whole sections Microsoft CRM Integration to BO-Great Plains on Partner Source -> Techknowledge. However majority of cases relate to 1.0, some for version 1.2.
1
Date Poster Message Text
3/18/2004 Paul Brown Transparent image/picture in Dexterity? How do you make it transparent - so if say user changes preferences and default colors - it stays transparent?
3/18/2004 Andrew Re: transparent images in Dexterity Paul, you need these combination for background color of the picture: Red (R) - 192 Green (G) - 192 Blue (B) - 192 If you change user s settings - it will stay transparent
1
Date Poster Message Text
4/11/2004 John RMS: Items do not upload from companies to headquarter database We do daily 401 and transactions are successfuly uploaded to HQ from the stores. However new items (which are already in the above transactions) do not come into Item table and we can not see them in HQ. I also tried also 260, 250 and 101 - the same results - all the new items do not come into HQ
4/11/2004 Andrew Re: Items not uploaded from Stores to RMS Headquarter This is correct. Items should be created in headquarters and then downloaded to stores. The reason that Microsoft recommends adding items at HQ is that your Headquarters will then have the master list of items and will in turn update the stores with the new items that they need. So, items should be created on the headquarters level
1

 

Date Poster Message Text
6/18/2004 Albert How do you call COM object from SQL stored proc Please, help me understand the best way of calling COM object from SQL Server
6/18/2004 Bernard Re: How do you call COM object from SQL stored proc Albert, Use sp_OACreate, sp_OASetProperty, sp_OAMethod and others sp_OAxxx procedures. They are pretty good documented in Books On line Bernard
1

 

Great Plains    Dexterity Customizations    Dynamics     eEnterprise     Microsoft CRM    Microsoft RMS    Crystal Reports    SQL   .Net    C#      International    Forum