Recent content by DaveXYZ

ePartners Solutions or Revere Group are companies I've worked with. ePartners is very strong in Great Plains and Revere Group has a great technical team.

Is this a laser printer or a dot matrix. If its a dot matrix try using the generic printer driver. If its a laser/inkjet try using one of the drivers it emulates.

There is a sdk on the installation disks. This will list some table name descriptions and links, etc. There are no APIs to great plains. It is built on a 4GL system. It is not object based. Parts of the code are in stored procedures and some in dexterity script. You have several options...

My rates are very reasonable, starting at .... Seriously, read the Great Plains documentation!

IM isn't guaranteed to work with 3rd party apps, but I don't think that POP here should affect SOP. If you take your text file and manually key in the data does it work or is there a data violation? Are you using the right .SET file? That would be the one with your 3rd party app included. It...

There is no batch scheduler in Great Plains. The script you would have to write yourself in the integration manager. If you go right click on integration name, select properties > scripts in IM you'll see the events you can script for.

Did you try using a custom script in Integration Manager that would kick off an invoice after a successful integration? There really isn't an API for great plains like we're used to.

Gotta love GPS precise error messages. Are you using SQL optimized or regular integration manager destination? Try both if you have them. Have you applied all the service packs for your version? Did you try techknowledge on customersource? Please post your error log, maybe we can tell moer...

LYR is last year sales. Did anyone ever perform the year-end close procedure for receivables? If not you won't get any values there. LTD would be life to date sales. If you have never run the year end close then the smart list data current year (YTD = year to date, CY = current year) will...

That might be your only solution other than a complete restore. No one closed out the year for the financials module between the udpate and now did they? Do you have access Great Plains support or a reseller for support? If your idea doesn't work I would definately contact them because that g/l...

Sounds like your update didn't work completely. Usually the core financials updates are pretty smooth. I'd revert to the backup and try your update again. Did you do any Dexterity customization to this system, like using core fields in a custom panel?

You find out if the error is in your ADO code or a database error. Use SQL Profiler (part of the Microsoft Sql tools) and monitor all exception events. It will tell you the specific error (key violation, type exception, etc.) so you can fix your code.

Integration Manager depending on options will run in the $10,000 to $20,000 ballpark. It doesn't currently work with all modules/objects so you need to ask very specific questions when evaluating the product. For example, it does financials but won't integrate sales territories. I think you can...

I just updated the last thread with some more info. You will need the .f32 files in your new install, as well as the other files I mentioned on the other thread.

You won't have any *.tdb files if you didn't do an export/backup before the old system went down. Are you copying all the .mdb, .ldb, .tpl files from the old sysdata to the new one? Is your ODBC connection set up *exactly* the same as the old one was, same name, same server, etc? Are your FRx...