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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.