Search results for query: *

Our vendor recently assisted us in creating a file to bulk load payment details into a bank's electronic payment offering for Electronic Funds Transfer. The payments were made ok - but the issue of remittance advices was not addressed. I therefore built a query using MS Access against PM30300...

I'm interested Phil Itex

I am in the Channel Islands. MGP advise that there are perhaps only 5 sites throughout the UK that have Field Series - but they are not sure who they are! Our VAR does not wish to be accredited for Field Series so we would have to find someone in the UK. Anybody know of anybody accredited in...

Brian, Thanks for this. Please can you advise in which country your client has implemented Field Service. Phil

Hi, Can anyone advise if the setup is unique across each company in an installation or does the posting setup window (specificaly posting to/through general ledger) apply to an installation globally? Thanks in anticipation Phil

I would be interested to hear from any users that have implemented any element of the MGP field series or can recommend a 3rd party alternative for integration with Great Plains. The company I work for is looking to replace its ageing service management software. Ideally such software should...

I would suggest you go along the FRX route. It is highly versatile and well worth the initial investment in time to get it up and running. We score many brownie points by being able to produce new financial information very quickly in a fashion that is understood by all departmental managers...

Brilliant. This works a treat. Obviously I need to improve my SQL skills Thanks

Ok Thanks for this. I went and looked at some of the sample alerts and see how this command is used however, I I still have a problem. If try and run the alerts where ABCCODE = 1, I get a repoirt e-mailed to me as expected. If I try and run the report using the where as advised above I...

Thanks for this. Does this mean I need to build the alert in native SQL or can I build a simple plain vanilla alert using the business alert front end and then edit the resulting SQL script. If the latter - where do I find the SQL script? Thanks in anticipation Phil

I am trying to build a business alert that will report inventory items set up each day. I am using IV00101. The logic I require is where created date is today-1 but when I come to define the alert, obviously IV00101 does not contain today as a field. I presume I have to join a date field from...