Search results for query: *

Does anyone have a SQL query to select the price for a particular item and customer from the Great Plains extended pricing module?

I am using Great Plains 7.5 SP2, and have modified one of the Service Advantage reports and added VBA code. I exported my customizations to a package file, and am able to successfully import this package on my machine. But when I try to import the package onto a user's machine it says: Name...

I want to move a SQL 2000 Server completely (all data jobs, DTS packages, logins) from one W2K SP4 machine to another, then rename the new server as the old server. I have read related posts on this site and found the following article that describes how to do this...

TechKnowledge articles 850774 and 857426 describe how to create a script.log file that contains a list of all the procedures and functions called. I was able to do this in Great Plains 7.5 but it doesn't seem to work in 8.0 (I don't have a Debug menu option). Does anyone know how to do this in...

We recently upgraded from Great Plains 7.5 to 8.0. I installed Integration Manager 8.0 onto a workstation, then (per TK 856226) copied our existing 7.5 IM.mdb file to the workstation. We are able to login to IM 8.0 and we see our integrations, but they all say version 7.5 beside them. They...

We are using Great Plains 8.0. I recently customized the SOP Blank History Invoice Form report, but deleted the "Page No." field from it. How do I add this field back to my report? I see a "Page Number" field listed under the globals section, but when I add this to my report it prints a 0 on...

I have a parameter {?Field} that is set to allow multiple values. I have a formula {@strField} that joins the parameter values (array) into a comma-delimited string with # characters surrounding each value (eg. #value1#,#value2#) @strField: "#" & join({?Field},"#,#") & "#" My record selection...

How do you list parent/child items on an ASP.NET page, grouped by the parent? For example, my data looks like this: Category Item -------- ------- Cat 1 Item 1 Cat 1 Item 2 Cat 1 Item 3 Cat 2 Item 4 Cat 2 Item 5 I need to display it on my ASP.NET page...

I am running CR 8.5, and have created a manual cross tab report that groups by category, and lists items under the columns that I have designated (I created a formula for each column). It works great, only the items are not formatted/spaced the way I need them to be. They are currently...

I have a memo field (datatype is "text" in SQL Server database) that I am displaying on a Crystal Report (version 8.5). The field is set to "HTML interpretation". No matter what size I set the font to in Crystal Reports, it is displayed as size 12. Is this the default font size that is used...

I am trying to write a trigger that will fire whenever a Sales Entry batch is posted. The trigger will execute a stored procedure, which will perform some tasks in the SOP30200 table to the invoices/returns that were posted. However, I am having trouble determining what conditions to make the...

We are running Great Plains 7.5 on a SQL Server 2000 database. When one of our users runs the RM aging process(Routines > Sales > Aging) from her workstation (Windows XP), it runs VERY slowly. However, if she runs it from another workstation (Windows 2000) it runs fast. Both machines have 256...

We are running Great Plains version 7.5, and are interested in making some modifications to the SRVCADV.DIC file using Dexterity. I have done customizations using VBA, Modifier, and Report Writer, but have not yet done any customizations on the Dexterity level. I loaded Dexterity onto my...

I want to concatenate a text field with a varchar field. For example... SELECT MyTextField + ' append some other text' FROM MyTable SQL Books Online says that the "+" (string concatenation) operator can be used with "any of the data types in the character and binary data type category...

I am documenting some disaster recovery procedures, and was wondering if it is possible to backup my virtual directory settings (for an IIS 5.0 website) so that they can be restored onto another machine? I have many virtual directories setup and want to avoid having to create them on the new...

We have a "version" field in our database that contains values similar to the following: V6.00.01.05 V6.00.03.00 V6.00.03.01 I have setup my record selection formula using the LIKE operator so that users can run the report for V6.00.03.* and it will return V6.00.03.00, V6.00.03.01...

In my classic ASP page, I instantiate the COM object like this... Dim obj Set obj = Server.CreateObject("DMCoreX.OBXPropertyBag") obj.SetProperty ("username", request.form("username")) I want to convert this to an ASP.NET page with a postback form where the user...

I have a formula @GroupDate: If {LaborForecast.FixedFee} then Date({LaborForecast.BillingDate}) else Date({LaborForecast.StartDate}) And I have a formula @FormatDate: select {?Sort By} case "Month/StartDate" : MonthName(Month({@GroupDate})) & " " &...

I have a VB application which uses the WebBrowser control. When you click on a link to open up a TIF file, it tries to open the file in Microsoft Word, which tries to convert the file to text. I am able to open the file when going directly to Internet Explorer and clicking the link. The error...

I recently upgraded to Adobe Acrobat Reader 6.0. When I click on a PDF link in Internet Explorer, the PDF file opens up. But when I select File -> Save a Copy and then navigate to the diretory where I want to save the file, I get this error: "The document could not be saved. This...