Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SACRob

    Moving Sharpooint list item from one list to another using T-SQL

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

    Moving Sharpooint list item from one list to another using T-SQL

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

    Moving Sharpooint list item from one list to another using T-SQL

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

    Moving Sharpooint list item from one list to another using T-SQL

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

    Moving Sharpooint list item from one list to another using T-SQL

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

    Moving Sharpooint list item from one list to another using T-SQL

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

    Moving Sharpooint list item from one list to another using T-SQL

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

    Moving Sharpooint list item from one list to another using T-SQL

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

    Adding an unlisted field to the word developer plug-in GP2010

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

    Adding an unlisted field to the word developer plug-in GP2010

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

    GP 2010 upgrade

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

    GP Utils missing Create new company

    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!
  13. SACRob

    GP Utils missing Create new company

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

    Table Function is asking me to declare a variable multiple times.

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

    Table Function is asking me to declare a variable multiple times.

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

    Moved sharepoint and buisness portal to a new SQL server.

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

    Security and Advanced security question.

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

    Bank reconcile issues

    yeah i have adjusted all of the values down to the correct entries. 6 of my transactions had a 10 extra digets added to them and were posted incorrectly. I used an sql script to modify the valuse in the table to adjust their valuse becuse great plains would not allow us to enter a manual entry...
  19. SACRob

    Bank reconcile issues

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

    19 Trillion dollar transactions causing problems

    When attempting to run the reconcile from transactions>financials>reconcile bankstatement. the difference is about 99,999,999,225,946.57 so i added a a entry to the adjustments to fix the issue. and hit reconcile it says the amount must be zero. the value says zero at the bottom. We really need...

Part and Inventory Search

Back
Top