- still on v9 for the next month or so - trying to do some cleanup before we move to 2010
I inherited a reports.dic where the users (and the former partner - former as in they will not grace our door ever again) were customizing reports at a whim and for no reason that anyone can remember...
one of my users got married and changed her last name. I know how to update the SQL side of things so that the user security would follow... what about in GP??? anyone have any "gotcha" things that I would want to watch out for or stay away from?
in Acrobat Pro - I know that you can put in some escape sequences using the reverse solidus, and I use the \r (Carriage return) pretty often. One option does not make sense. if I use a \t (Horizontal Tab) I do not see where I would define the 'tab stops'... I have been over and over a few of...
I am looking for a chart that would tell me what update needs to come first.
We have Dynamics 9, CRM 3, SQL 2005, FRx 6.7 and Req Mgmt in addition to Office 2003. I am trying to find something on MS site that would tell me which Dynamics version (GP2010 or v10) and CRM version will run with...
we take orders for our items well in advance ... most of the time ... and have limits of which item / class we will make each day/month.
we have a pretty good WMS system & it has some nice work order features, but we use GP for Order Entry and so although we could look at current inventory from...
I backup and restore our prod GP data to test on an occasional basis. We run the little SQL script that does the update for the company id and all seems to work ok.
EXCEPT - We are also using eGP (econnect) & Req Management. I have found that eGP is doing some things with an AA table in the...
sounds like a stupid question, but just want to be sure that my reality is not getting bent.
We went to mirroring our storage to our other facility - this copies the bit changes from one site to the other. My company has some 'other' non SQL things running on my SQL box but is blaming the DBs...
Long time GP user - first time modifier - gp 9
We are moving some fields around on the Sales Transaction Entry screen - all is well... except one thing. We wanted to move the site from the expanded part of the screen to the scrolling part of the screen. This works and looks great. Now the...
Anyone got a good way to look at your whole MS CRM user group and see when they last did a sync of their data? I found a report where you could see each individual, but that was dependant on knowing a few other items and was pretty cumbersome to use.
anyone know of a 'quickstart' for Modifier?
I have a few simple things that I wanted to do to the SOP transaction entry screen, but I guess it is not as simple as I would expect.
example - let's say that I want to put the Customer Contact on the screen. I have moved and hidden another field...
I have several servers running ssrs reports. On all of them (except one) I hit http://server/reports and BAM the report folder list is there. The one exception is the server that is physically 20 yards from my head (and on the same sub-net as my box). I hit http://server/reports and it could...
anyone use a program that would integrate with GP for POs (and such) but would be used for your company maintenance needs?
so
lets say we have three 5hp motors. We would like to see the history of it's use and where it is now.
lets say that we have 50 3" bolts and need to reorder when the...
ssrs 2005
I have a sales report where the user can choose if they are wanting to display dollars or quantity. In the matrix portion of the report I have the variable formatted by an expression similar to this so that when the user wants to see Price they get the $...
I have just a few Crystal 9 (sorry) reports left. One of them the user has the report grouping on the date then in the group options saying print 'for each week' (so they get one line for each week). This was great till the regulators decided that their week starts on Monday instead of Sunday...
right now I am on SQL 2005 & GP 9
because of all of the ribbon user interface 'stuff' on GP 10 and some other issues we will not go to 10 'till late fall... We are getting ready to virtualize a number of our servers and I have the opportunity to go to SQL 2008 within the next month.
SQL 2008...
If I have a query that says
select *
from SalesTable
where Territory in ('05', '20')
I get what I would expect (all sales in that territory). So now I want to store the '05', '20' in a table so that I can change the territory
so hopefully the code would look like
select *
from...
Let's say I have a PO that was for 999,999 @ $0.05 ea
but the reciepts / bills that come through for a few of the 999,999 are at $.06 ea.
I would LOVE to find the table where such a difference / variance is stored (so the ideal world would have the .05 in one field and the .06 in another and...
rs 2005
I want to show users the total for a column in a table AND when they export that report have Excel get the formula instead of the number.
so in RS they see (and get on the export)
10.00
20.00
Total 30.00
On export I want Excel to get
10.00
20.00...
I have several reports that I use the User!UserID to determine if the user has access to what set of data. I know that there is also the User's langauge, but is there any way to get the user's AD group (or at least the group that got them to this report) or other AD data?
Instead of limiting...
I have a need to print an SSRS report when a trigger is fired on a table. I MUST be missing something here... can someone point me in the right direction please?
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.