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 TouchToneTommy 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: *

  • Users: jymm
  • Content: Threads
  • Order by date
  1. jymm

    any good/quick way to find which custom reports...

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

    change GP user ID

    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?
  3. jymm

    Escape Sequences in literal strings

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

    Looking for an upgrade path chart

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

    putting in orders for the future

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

    backup/restore for test not 100%

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

    Does a view change things at the bit level?

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

    Look-up button

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

    Sync Status

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

    Quick start for Modifier

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

    odd set-up question

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

    looking for a program that interfaces with GP

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

    Variable format in a chart

    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 $...
  14. jymm

    any way to change the default for the start of a week?

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

    Curious about experience on upgrade

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

    How do I store this for SSRS to work

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

    GP 9 - how to see PO difference

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

    how do I get formulas to export in xls

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

    Security question - more to User!UserID?

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

    'Schedule' a report to run from a trigger

    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?

Part and Inventory Search

Back
Top