Search results for query: *

I am not sure this is the correct forum, but i am trying to find a suitable job title for the duties that i am responsible for..at our company job Title is everything. My responsibilites include: 1) Computer Applications - handle all financial software(Great Plains, FRx Reporter, FRx...

I have two reports that will use the same parameters at run time. Is there a way to run both reports at the same time when i just select one to run. I do not want a sub query however. I alo want to avoid using any schedulers. Crystal Reports XI R2.

Does any one know the field that replaces the Check Amount field in GP 2010 from GP 10?

I am creating an excel 2010 odc connection under a Windows account that has admin rights to the underlying sql tables that make up the excel spreadsheet. What i want to know is if it is possible to have a windows user open this odc connection and view the data if i do not grant them permissions...

I have a Subreport on demand attached to a crystal 11 Invoice i have created. It reads "Click here to see open items." The problem is that when i print the main report the on demand caption text prints also. How do i suppress the field from printing to rpinter, but still have it shown when...

I am trying to create a trigger that will update fields of the inserted data based on another table. I am getting the trigger to fire but it is not updating the last record that is being inserted. Any ideas? ALTER TRIGGER [dbo].[SOP10200_kml] ON [dbo].[SOP10200] after insert AS BEGIN -- SET...

I have a sql table that contain a column with text that has commas in it. They are used to seperate the data within the column. i wan to be able to create a column for each commas seperated text value. I am using SQl 2005. Below is an example of the text field: 17 N., w/s of NMB Flea Mkt., e/s...

I am trying to modify the Summary Historical Aged Trial balance Report to just show 6 columns. 1 being the Customer Number and the 5 remaining the Aging Buckets. Basically what i want to try and do is make the report a data dump to a text file so i can import it into sql. I have tried removing...

Does anyone have SQL code or an Idea of how to recreate the RM Sales Historical Aged Trial balance report that would be able to be in Smart List, using Smart List builder or use excel with parameters?

We are looking into moving our Project Accounting from Sage Timberline to Dynamics GP Project Accounting. Our company is a Developer Company and not Construction. The lead in the change states that the project accounting in Great Plains is geared towards construction and not so much developers...

I am getting the error in the subject from one of my applications when trying to run the Crystal ActiveX Viewer Version 11. I know it is a permissions error because when i set the user as admin on the Web server they can run the viewer with no problem. But when i remove them as admin and set...

I have a sql2008 SSIS package that updates an Access table. When i run the package manualy it will update the table, but when i run the package though SSMS and the SQL agent job it says the file is either locked or does not exist. I have saved the ssis package in the database with no luck. I...

Should I run a defragmenting tool like diskkeeper on my SQL data files? I am running a sql 2005 database and Windows 2003 SP2 OS.

Does anyone know how to recreate the FUTA Summary Period End Report either in SQL or Crystal. I am on Microsoft Dynamics GP 9.0 SP3. I have looke at the TK's but they do not explain fully how the report is created.

I cannot uninstall XP SP3. I get this error in the spuninst.log file. "Rename failed. Source path c:\windows\$NtUninstallKB969497-IE8$ does not exist" I had installed IE8 before SP3 and ran a utility to clean folders and it removed the IE8 uninstall folder. I have since been able to uninstall...

We caught a virus and had to reinstall SQL 2000 server on a windows 2003 system. My second instance sql name is MBHQSQL\SQL03, but when I try to recreate the instance it does not allow me because of the back slash. Any ideas how to get that same name?

All of a sudden i have a sql 200 server getting this error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Once i restart the services on that server it runs fine. Any ideas. we believe we have a virus as we cannot also open regedit and task manager.

I am on GP Dynamics Version 9.0 SP3. Does anyone know what pay types from the upr00400 should be subject to Workers Compensation tax.

I am running the following Access 2003 query. When I run it i get an #Error code in the runtotal Field. I am trying to create a running total on the amount field by employeeid and by period. SELECT dbo_pr_GROSWAGS.Entity, dbo_pr_GROSWAGS.EmployeeId AS empalias, dbo_pr_GROSWAGS.YEAR1...

Is there a way to know if a user cannot log into Great Plains due to a failed password? The Activity tracking does not do this.