Search results for query: *

I am attempting to move sharepoint list items from a main list to an archive list. I am using WSS 3.0 Both of these lists were created from the same template so the column structure matches perfectly. I have attempted to do this migration my altering two sql tables. alldocs and alluserdata in...

I am attempting to modify the POP Purchase order blank form template. I need to include the Vendor account field from the vendor maintenance window. However this field is not in the list of fields in the GP developer add-in for word. I have saved the xml data after running the standard report...

after performing all hot fixes and SP's i finnaly got my data base to begin updating however one table the 'cm20202' to be exact. it says the table doesn't match its definition and it will not update the table.

I am attempting to create a new company database in GP9.0 using the GP Utilities icon. I seem to only have 4 options in the drop down. Register Microsoft Dynamics Gp, Remove SOP and Invoicing message, Update modified forms and reports, and syncronize forms and reports dictionaries. After...

The following is a function i am trying to create to reformat a a one line dataset into a multi row table. However it is asking me to redeclare the returned variable multiple times in T-SQL so i am sure my syntax is off slightly. USE [GP1] GO /****** Object: UserDefinedFunction...

We have recently moved BP to a different SQL server. Previously the GP and SharePoint/BP data and config were on the same sql server. The same web server is being used. SharePoint 2.0 works properly on the sql database from what I can tell as the administration page comes up properly and the...

We are currently using GP 9.0 and I try to use advanced security as often as possible. But it seems I cannot always grant all of the access required to modify specific forms in GP so I am required to go into Tools>System>Security. When I launch this option it says “Security and advanced...

Sorry about the double posts but i am in need of serious help. If you look at my previous post you can see how i have gotten into this mess but. When attempting to run the reconcile from transactions>financials>reconcile bankstatement. the difference is about 99,999,999,225,946.57 so i added...

OK so I have a very large discrepancy in two accounts my payroll clearing and the payroll account. The steps I ran were as follows. I created a GP macro to enter about 89 transactions in the financial>Bank transactions area in gp. However I did not notice that 6 of the entries had repeating...

I am trying to check if a value is null befoer i run a function but i also need to verify if a city equals federal way. the query without this entry gives me about 5650 rows and with this line i only get about 5100 rows and then an error Msg 8114, Level 16, State 5, Line 60 Error converting...

I have recently taken over the administration of our microsoft great plains database. There has been allot of custom table creation and some additional undocumanted patches have been applied to our database. I need help finding a table that contains some regional informaton. I know the data that...

I am trying to add some extra information to my temporary table. My insert statemet includes a sum and group by so i am not able to select individual data to put into the table. (or i dont know how.) basically i want to store the the LNITMSEQ number from when the FROMSTAT=10E and when the...

I am trying to do some line by line time calculations in a select statement using nested Ifs and i think my syntax is just a bit off. It is failing at the from statement in the last section of the code. please any help would be greatly appreciated. [code] CREATE PROCEDURE dbo.svcslr -- Add...