Well I've messed around with it and not gotten any where other than removing the HR package to make it work. Or course, since it is our Payroll department's job to do this and they are required to have the HR module installed it makes this solution untenable. I have resorted to asking GP tech...
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...
I ran into this error when upgrading from Dynamics 6.0 to 7.5 and upgrading IM as well. The solution I came up with was to select the Dynamics 6.0 adaptor as well as the dynamics 7.x adaptor when installing IM. That allowed my existing integrations to run. Of course, I planned to update the...
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...
I'm not sure I follow what you mean there stormtrooper. The dataset I will be reporting on does not have blank or null entries for the dates in question. There are no entries at all. I'm not sure how I could compare the missing days to my date range within Crystal (If that's what you were...
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...
Oh well. I was hoping that there would be an explanation, or at least something to use as a workaround; like a better way to format the equations or something. Looks like my next best bet is to try and get access to the Pervasive SQL server and figure out how to create Stored Procedures...
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...
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.