Dynamics GP 9.0 macro/script issue.

We have a macro that executes once a week to perform check links on
all companies in Dynamics GP 9.0. This script used to work fine but
lately the script does no log out and close the instance of GP after
finishing the script. First i though maybe it's getting stuck
somewhere in the middle of the script and that is why it does not log
out and close the instance of GP, but when i check the logs, it says
that the last statement executed was to log out and close the instance
of GP.

This is the code that is last executed.
=================
  CommandExec form BuiLtin command cmdQuitApplication
=================

Any idea what must be going wrong with the exit command?

The other issue we noticed is, this script is no longer generating the
check links report with the settings provided by us. The script is
designed to save the report as text file to a path specified in the
script rather than displaying it on the screen but it does not seem to
generate those reports for us.

Here is the code that generates the check links report as a text file.
==================
NewActiveWin dictionary 'default'  form 'Report_Destination' window
'Report_Destination'
  MoveTo field 'Print to File'  # 'FALSE'
  ClickHit field 'Print to File'  # 'TRUE'
  MoveTo field 'Path Button'[1]
  ClickHit field 'Path Button'[1]
  FileSaveAs file ':D:Dynamics GP 9.0/GP Scripts/Reports/
CheckLinks.txt' type 5
  MoveTo field 'If File Existing' item 0  # 'Append'
  ClickHit field 'If File Existing' item 1  # 'Replace'
  MoveTo field 'OK Button'
  ClickHit field 'OK Button'
# Print To File:  'File Maintenance Error Report'
==================

We haven't done any changes to this script since we created it so i am
quizzed with it not working as expected.

Thanks,
Hetal.
0
12/20/2007 7:59:01 PM
greatplains 29623 articles. 3 followers. Follow

7 Replies
845 Views

Similar Articles

[PageSpeed] 41

Hi Hetal

Did you recently apply any service pack to your system? I have it in our 
enviroment that we had to recreate the Marco becasue the service pack 
affected something and the program would not close on it's own.

Fliehigh

"Hetal" wrote:

> We have a macro that executes once a week to perform check links on
> all companies in Dynamics GP 9.0. This script used to work fine but
> lately the script does no log out and close the instance of GP after
> finishing the script. First i though maybe it's getting stuck
> somewhere in the middle of the script and that is why it does not log
> out and close the instance of GP, but when i check the logs, it says
> that the last statement executed was to log out and close the instance
> of GP.
> 
> This is the code that is last executed.
> =================
>   CommandExec form BuiLtin command cmdQuitApplication
> =================
> 
> Any idea what must be going wrong with the exit command?
> 
> The other issue we noticed is, this script is no longer generating the
> check links report with the settings provided by us. The script is
> designed to save the report as text file to a path specified in the
> script rather than displaying it on the screen but it does not seem to
> generate those reports for us.
> 
> Here is the code that generates the check links report as a text file.
> ==================
> NewActiveWin dictionary 'default'  form 'Report_Destination' window
> 'Report_Destination'
>   MoveTo field 'Print to File'  # 'FALSE'
>   ClickHit field 'Print to File'  # 'TRUE'
>   MoveTo field 'Path Button'[1]
>   ClickHit field 'Path Button'[1]
>   FileSaveAs file ':D:Dynamics GP 9.0/GP Scripts/Reports/
> CheckLinks.txt' type 5
>   MoveTo field 'If File Existing' item 0  # 'Append'
>   ClickHit field 'If File Existing' item 1  # 'Replace'
>   MoveTo field 'OK Button'
>   ClickHit field 'OK Button'
> # Print To File:  'File Maintenance Error Report'
> ==================
> 
> We haven't done any changes to this script since we created it so i am
> quizzed with it not working as expected.
> 
> Thanks,
> Hetal.
> 
0
Fliehigh (443)
12/20/2007 8:17:02 PM
We did not apply any service packs but we did install Advance Human
Resource and Payroll Suite for v9.0.

I did create a test macro for one of our companies and the script text
was exactly similar to the one we have right now.

Is there any significant change in the macro script for you guys?

Thanks,
Hetal.
0
12/20/2007 9:51:51 PM
We did not apply any service packs but we did install Advanced Human
Resource and Payroll Suite for v9.0.

I did create a test macro a while ago for one of our companies and the
script text for test macro is exactly same to the one we have right
now.

any idea what could have gone off? Thanks.
0
12/20/2007 9:54:57 PM
Hi FlieHigh,

The only thing i noticed between our existing macro and new test macro
is the dex version #.

In our existing macro is it: # DEXVERSION=9.00.0068.0 2 2
while the new test macro states: # DEXVERSION=9.00.0073.0 2 2

I am not sure if that should make a difference as these are comments.

Thanks,
Hetal.
0
12/20/2007 10:05:48 PM
Dear Hetal,

Did you try to change the updated Dex Version # ??????????


Sheikh Asif
0
asifbunty (75)
12/20/2007 10:45:47 PM
yes, i did, and it still won't close the instance of GP.
0
12/20/2007 10:55:35 PM
Dear Hetal,

Can you try to record new macro and run it, just thought.
One more thing would it heppen to only one machine, can you test it on
any other machine. with old script and building new script.

Regards,

Sheikh Asif
0
asifbunty (75)
12/21/2007 8:15:07 AM
Reply:

Similar Artilces:

Can't add a 0 (zero) to the beginning of a number in a cell
I am trying to put a serial number in a cell but it starts with a zero. After I type in 09867453 and move to the next cell the 0 disappears. Scott You can format the cell to be text and it will then allow a 0 to be added to the front of a number however this may cause problems if you are using that number in inequalities. Scottrow wrote: > I am trying to put a serial number in a cell but it starts with a zero. > After I type in 09867453 and move to the next cell the 0 disappears. > > Scott Scott, The first answer is correct however it may be alot easier if you add an a...

service calendar in MS Dynamics 4.0
Does anyone knows how we can achieve the following requirement with MSCRM 4.0 In the service calendar in MS Dynamics 4.0 you are able to create new appointments and service activities. Appointments and Service Activities which are created will be present in the Service Calendar. To see all details of such a record[Subject(default Value)] you must open it. But by moving your mouse on the concerning appointment or service activity, a text-box-view appears with primary information. With appointments the content of the following fields is displayed: 'show time as', 'subject...

How can I create a macro to export a fold (actually 3 different ones) into excel (and later into access)
I want to create a macro that will export 3 different folders (into 3 different files) into a excel spreadsheet (overwriting the old ones) Later I will be migrating to access, due to issues with excel sort "features" scrambling my data. I was hoping that there was a "record macro" function in OL, but there does not appear to be. OL 2002 SP2 Thanks Bruce That is correct - macros do not run in Outlook - you will need to do some programming instead. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After searching google.g...

Integrating Crystal Reports into GP
I am using Dynamics GP 10 and would like to replace some of the Report Writer reports with Crystal Reports. This because Report writer reports is not very savy and on smartlist I can't create totals or summarize data very well. So I was hoping to be able to create some crystal reports and be able to access it in Dynamics GP. Is this possible? If, so how? -- Thanks for your help Hi GPNewbie, Heck, anything is possible with programming! GP does not offer this functionality natively, but there are many fine third party programs that integrate Crystal Reports. Our own V...

CRM 4.0 Backup Plan
I want to implement a backup plan for CRM Dynamics 4.0 so that to be able to fully recover it if a failure occurs to the machine or Hard drive [Note: I have SQL Server 2005 Installed on the same CRM server machine] Q1: Which databases should I backup of the following?: MSCRM_CONFIG <Org>_MSCRM ReportServer ReportServerTempDB Q2: In a disaster case, what are the steps to restore CRM 4.0 from the backed up databases? Thanks in advance You need to back-up Both CRM databases Master msdb (Although they are not required by MSCRM but should be backed up) Reportserver reportservertem...

Macro to switch to another sheet, grab ref to any cell, paste ref in current sheet??
I am looking for a way (either macro or VBA) to perform one simple task: while in *any cell* of your choice in the current worksheet, switch to another specific sheet, choose *any* cell, grab a reference to that cell (not its value), switch back to the first worksheet and slap in the reference of the cell in the other sheet. This would be the automated equivalent of doing the following manually: 1) Select *any cell* (say *F11*) in the current sheet (Call it "*Destination*"). 2) Press "=" (no "ENTER") 3) Click the tab for the other sheet (call it "*Source*&...

FRx 6.0 and XP SP2
Is there a hot fix for FRx 6.0 to work on XP SP2? Can't find on Customer Source. Or is there a procedure that can make it work on it? Thanks, Coroc. Upgrade to 6.5 with SP7 "coroc" wrote: > Is there a hot fix for FRx 6.0 to work on XP SP2? Can't find on Customer > Source. Or is there a procedure that can make it work on it? > > Thanks, Coroc. > klewis wrote: > Upgrade to 6.5 with SP7 not an option, migrating to gp 8.0 and frx 6.7 in 2 months. any workarounds, replacing and manually registering those two ocx files or something similar? Coroc, Yo...

.NET CF2 app doesn't init on CE 5.0 (with 2008 QFEs) ??
Must be some other components to support .NET CFv2 on Platform Builder? Application initilaizes with .NET CFv1.1 successfully. Updated the OS image by (a) installing 2008 QFEs, (b) removing .NET CF v1.1 from the OS image, and (c) including both of these components from the catalog into the CE 5.0 OS image: #1 - ".NET Compact Framework 2.0" and #2 - "OS Dependencies for NET Compact Framework 2.0" Then attempting to run the App, this error: in a pop-up with title bar: ".NET CF Initialization Error". Message content in the pop-up states: &qu...

dynamic resource
Hi, Anybody know how to load e.g. bitmap into resource dynamicaly? The bitmap file will be downloaded by application itself , so it has to be somehow inserted into resource and displayed. thanks What do you mean by "into resoure dynamically"? Do you want to load a ..bmp file and display it? If yes, take a look at GDI+, which is by far the easiest way to achieve this. ---------- Ajay Kalra ajaykalra@yahoo.com I misspelled this, yes I'd like to load new bitmap on the fly. But resource file looks like is static. I use ATL/MFC applicatation. "Ajay Kalra" <aja...

Outlook '03/IE 6.0 Hyperlinks do not work
** Please note that I did post this same question 2 days ago in the General Questions Board and have not received a reply - thought I may try, here, to see if anyone has any input. Thank you. ** Hello - I have Outlook 2003 (SP 1) and Internet Explorer 6.0 (SP 2). I have updates automatically, but, have also gone in to check for any updates and I do not need any. When I click a link in "O.L." (Outlook), the screen goes white, the title bar is still at the top of my page - however, I now see the title of the email PLUS Not Responding. I have to do the 3-finger to get ou...

GP 2010 - Fabrikam
I just installed GP 2010 and the Fabrikam TWO company. When I first went to Tools>Setup>Payroll>Payroll-Additional>Prompt Print Edit Reports I was able to see and check the on/off buttons for the report option. I was expecting to then be able to (somehow) set a flag for which reports print and which report to not print. I turned on the reports and then went into Tools>Setup>Posting>Posting expecting to see some on/off checkboxes for the Prompt Print Edit Reports but there was nothing there. So I went back to the Prompt Print Edit Report window and c...

Dynamic sum in Chart
Hello: So I've got this pivot chart that I've created, and it's great, EXCEPT when I select different categories to show up, I want to show a SUM of the categories, not the values of each category. I would appreciate any help/advice you may have. Thank you! Michelle In the pivot table you can select different thing like count and SUM etc. If you right click in the upper left vacant square and chose field settings, then select what you want to see in your data section. Misha wrote: > Hello: > > So I've got this pivot chart that I've created, and it's great...

oracle RowType Issue
Hi All, Im new to Oracle. I have a Rowtype and i want to Loop through that Rowtype without mentioning the Column name. My code as below : declare empRowType Emp%ROWTYPE; begin SELECT * INTO empRowType FROM Emp WHERE Emp_id = 101 ; for x in ( select column_name from user_tab_columns where table_name = 'Emp') loop i:=i+1; y:= x.column_name; z:= 'empRowType.'|| x.column_name; dbms_output.put_line (z); end loop; end Steps : 1) Fi...

error 5.4.0
The destination server for this recipient could not be found in Domain Name Service (DNS). Please verify the email address and retry. If that fails, contact your administrator. <exchangesrv.northcoastseafoods.com #5.4.0> I am receiving the above message, when sending E-mail. I do not have SMPT Connections configured. Now what do I do to fix this? Not enough information. An error such as that typically indicates that the "REMOTE" domain couldn't be found in DNS. Can you provide the domain name you are trying to send mail to? Does mail to other domains work? T...

Tab seq dynamically...
I have a button which added dynamically to a property sheet. Now for setting the tab sequence with this new button, Am using SetWindowPos() method. Now tab sequence is proper. THE PROBLEM IS Through the arrow keys, I could not navigate to the last button for which I called SetWindowPos. where as through tab keys I could go to the last control. I will appreciate ur help in this. DETAILED DESCRIPTION I have three buttons (OK,Cancel, Help)on the property sheet. I added a button "Default" to the property sheet and positioned between Cancel and Help. I set the tab sequence as ...

Great Plains 9.0 Initial Screen
I just upgraded (Test Environment, of course) from MSGP 7.5 to 9.0. All went well, except after I select the company to log into, the screen shows this page and I continue to get errors about missing the Microsoft Chart or something (can't see the rest of the words because they cut off). How do I get around this? Is MS Office required for this? If so, where did it say that in the documentation? Thanks everyone -- pgrooms P: Certain elements of MS Office are needed to properly display the new 9.0 home page, particularly the metrics. Dwight "pgrooms" <pgrooms@discus...

Tab Control Issue
Hi-- Can anyone help with why this code causes the subform inside of a tab control page to disappear? Forms!frmPurchaseOrder!pgCurrent.Visible = True Forms!frmPurchaseOrder.Section(acFooter).Visible = True Forms!frmPurchaseOrder!pgCurrent.SetFocus Forms!frmPurchaseOrder!pgAddEdit.Visible = False At first, I had 2 subforms inside of a main form. When a button was clicked, one form was hidden and the other visible. That was causing the subform to turn completely white and become useless. I decided to try tabs thinking this might solve the probl...

SharePoint Alternate Access Mapping to my Dynamics GP BP site
Hello, If I have posted this question in the wrong forum please let me know! I’m looking for some guidance on changing the Alternate Access Mapping for my Dynamics Business Portal site. So I can implement Single Sign On via ISA Server which is supported on one web listener. Present configuration: Default Zone: http://geneva:222 I would like to add: Internet Zone: http://dynamicsbp.proclub.com I presently have another SharePoint Collection (The Main Portal) http://geneva configured which listens on Port: 80. I tried to add the Alternate Access Mapping http://dynamicsbp.proclub.com...

Viewing CRM 3.0 Notes in SharePoint
I have added a page viewer webpart to a sharepoint (sps) page to display data on a CRM account. All data and tabs display as they should except Notes. When I click on the Notes tab, none of the existing notes are displayed; just to option to add a new note. If I add a new note, it is displayed only until the page is refreshed and it then disappears. Text, picklist, and other fields display existing data correctly. Has anyone know how to display CRM 3.0 notes in a SharePoint webpart? Thanks Vic Coleman Can you share your web part with the community? maybe we can all help to re...

Macro example
Can I get an example of a recorded macro that is useful which can't be achieved by a copy/paste? Thanks There are so many it is pointless question. You cannot get an example of a recorded macro that you cannot do in Excel (that would be an oxymoron), but anything that deletes for example would not be Copy/Paste, anything that sorts, filters. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "KBV" <KBV@discussions.microsoft.com> wrote in message news:809AE718-33FE-45A0-A7DF-77FA4C7DC373@microsoft.com... > Can I get an exampl...

eConnect Runtime 9.0.2?
Where can I get the runtime MSI for eConnect 9.0.2? ------=_NextPart_0001_60CDC8D7 Content-Type: text/plain Content-Transfer-Encoding: 7bit The eConnect 9.0.2.0 Runtime is available on CustomerSource & PartnerSource. The link for the 9.0.2.0 Runtime for CustomerSource is https://mbs.microsoft.com/customersource/downloads/servicepacks/econnect9.0r untimedownloadsforisvs.htm?printpage=false. Corey Developer Support ------=_NextPart_0001_60CDC8D7 Content-Type: text/x-rtf Content-Transfer-Encoding: 7bit {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans...

How to tell if 3.0 emaill router is installed
How can you tell if the email router is installed? Running Exchange 2003 and Server 2003. Can't email from CRM and can't find registry entry on echange server. thanks! Check add/remove programs. It should be listed as a seperate application. "AmyF" wrote: > How can you tell if the email router is installed? Running Exchange > 2003 and Server 2003. > Can't email from CRM and can't find registry entry on echange server. > > thanks! > ...

Sort Macro 03-24-10
Can I have a Macro that will automatically filter a spread sheet, pick a specific value from a different sheet in the work book and copy the results to a different sheet in the workbook? For example: Sheet 1 has the list of material numbers that are being ran. Sheet 2 has the list of orders for that day with specific material numbers. Sheets 3 - 9 is where the data will be coppied to for each individual line. A separate sheet has been made for each line. I will need to use the data from sheet two 7 different times to gather all the data for each line/material. ...

Update from previous versions to GP 10.0
Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and then GP 9.0 to GP 10.0? Please help me as soon as possible, I need to make decisions. Put service pack 5 on version 8, then update from there to 10.0 Make sure you also immediately use sp1 for Version 10 Mike "arielqs" <arielqs@discussions.microsoft.com> wrote in message news:12AD9FCB-84AD-45CF-898C-A943DB8216F4@microsoft.com... > Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and > then GP 9.0 to GP 10.0? > > Please help me as soon as possible, I need to make dec...

Macro programming
Hi, I'm a medical transcriptionist and am trying to program two macros that let me insert the patient's first name and last name with keyboard shortcuts, calling the names from fields automatically inserted when I generate the document. I guess my problem is that the code I wrote has two selection objects, which apparently is not allowed, so I was wondering if there is a way to break them up so they can operate separately.. here is the code, thanks for any suggestions you might have: Sub Macro1() ' ' FirstName Macro ' Macro recorded 11/26/2009 by KT '...