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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DaveXYZ

  1. DaveXYZ

    Project Accounting v7 Bugs?

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

    Windows XP Printing problem

    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.
  3. DaveXYZ

    integrating a vb.net app with Great Plains

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

    Generating Invoices

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

    Integrating Invoices

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

    Generating Invoices

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

    Generating Invoices

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

    Integrating Invoices

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

    Smartlists column descriptions

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

    Transaction History Error

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

    Transaction History Error

    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?
  12. DaveXYZ

    Getting Multiple-Step...Errors on SY00500

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

    Integration Manager/SQL

    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...
  14. DaveXYZ

    Urgent Number 2 (FRx and Catalogs)

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

    Urgent Reply Needed

    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...
See more

Part and Inventory Search

Back
Top