Recent content by SACRob

Ohh and by the way this definitly removes history. However i spoke with the client and that is ok in this instance as performace comes before version history.

I created a new check box column and when doing the update query i'm getting an error. Error: Data cannot be inserted because there is no matching record. my query is simple just field name bit table AR Update true criteria false any suggestions i see online the linking from the userinfo...

will i have an issue with the workflow if one list has the extra column and the other does not?

the work flow logic is as follows. AR list If column [status] = "closed" copy to list ar - historical then delete from current list. ar - historical list if column [status] = "open" copy to list ar then delete from current list. for the mass update if column [expense comments] is null then...

That would be great. I installed PowerShell on that webserver last night after reading your first post. It is a 2003 sp2 server so it was not an automatic update. I am relatively familiar with PowerShell in exchange 2010 however I am not sure what the module to import for sharepoint. I have seen...

We have 60550 items in the list with up to 4 versions each with an attached pdf file so 204753 rows with version history. I can modify about 10 at a time without IE crashing. The field I am updating is a text field that only occasionally has data. I was going to try and leverage the site...

Thank you i was able to create a workflow in sharepoint designer to do this very task however i am running into some trouble with the amount of data in the list. I cannot easily run the workflow on every item in the list. I have been trying the onchange event and making a small change to the...

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...

Just bumping this thread as i am still having this issue and i am not sure where to go.

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.

Thank you Lyle. I never even thought to check the sql server for a GP install. I found it and i'm good to go!

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...

I get the error Msg 134, Level 15, State 1, Procedure fn_holidayconversion, Line 18 The variable name '@DATE' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Procedure fn_holidayconversion, Line 46 Must declare the...

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...