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!

Register Log in
  • Congratulations bkrike 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: dgenne
  • Content: Threads
  • Order by date
  1. dgenne

    IM Employee integration w/ HR

    Hello, I'm running GP 7.5 and IM 7.05 and trying to create an integration to transition newly hired employees from our POS system into GP. I have the HR module installed and when I test a simple .csv file integration with only one line I get: Doc 1 Error: Do you want to save these changes in...
  2. dgenne

    Access Active Directory through SQL2K?

    How can I get access to Active Directory through SQL2K? I have configured a linked server, but I get a syntax error message (Server: Msg 7321, Level 16, State 2, Line 1 ) when I try and run a command through SQL Query Analyzer. Here is some background: I am trying to report off Active...
  3. dgenne

    Select dates within a range if they have *no* entry in database

    Hello All! I've been trying to figure this one out and not having much luck I have a report that queries the user for a start date and an end date. Various totals are calculated and that part works fine. What I am trying to do is then show the user what dates in that range were missing data...
  4. dgenne

    Formula based on Query (.qry) changes field value!!

    I have a formula that is designed to place a 0 or a 1 in a column: if (({Query.STRTDATE}) < Date({?Year of Query},{?Month Of Query},01)) AND (({Query.INACTIVE}=0) OR (({Query.INACTIVE}=1) AND ({Query.DEMPINAC}>=Date({?Year of Query},{?Month Of Query},01))) )then 1 This works as I want in a...

Part and Inventory Search

Back
Top