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 Chriss Miller 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: *

  1. MentatDragon

    GP Definitions and Descriotions

    Steve, Go to: http://msdynamicsgp.blogspot.com/ ...and then to the downloads section. In the list you will see table details, which is a start. For fields, your best solution is the SDK, but I don't know how to get that to you without CustomerSource. -Mark
  2. MentatDragon

    GP Definitions and Descriotions

    If you have access to CustomerSource, you can download the SDK which should help. Otherwise, you can go to Tools>Resource Descriptions>Tables in GP.
  3. MentatDragon

    Test Server for GP 10

    Sorry that the link is bad - not sure how to post the script.
  4. MentatDragon

    Test Server for GP 10

    There is an article in KB #878449 - and it includes the script to move user accounts.
  5. MentatDragon

    SQL for GL trial balance

    The period net activity, in summary, is stored in GL11110 for Open years, and GL11111 for Historical years.
  6. MentatDragon

    Integration Manager Codes

    It is under the Documentation for Developers for Microsoft Dynamics GP 10.0 - and the filename is SDK10sp2.zip
  7. MentatDragon

    Adobe PDF Send by email

    Another product, that we use, is pdf995. It is very cheap licensing, and very fast. Also is very programmable. You can use vbscript or Access/Excel VBA to automate emails. If you own Modifier, you can also automate/drive PDF and email generation. We send reports directly from GP to pdf...
  8. MentatDragon

    Advice on creating Invoice/Returns Statements for someone new to GP

    Posted Invoices and Returns are in the SOP30200 and SOP30300 tables. They also leave a trail in the AR files, as RM-type: 1-Invoices or 8-Returns, but only in total, not in detail. (RM20101) You will be severly handicapped trying to adjust the canned AR statements. I have written a lot of...
  9. MentatDragon

    Integration Manager Codes

    There is an SDK that lists the codes for most of the master and transaction files. If you have access to Customersource you can download it.
  10. MentatDragon

    Paid Leave Liability Report

    How are you running the report? Is this a payroll or HR report?
  11. MentatDragon

    Where is SOP Line Item Description stored

    Since the postings to the GL are based on the total invoice, not each line item, (one posting for multiple invoice lines) it is not possible without additional work. You can open the distributions window and enter additional 30 characters per GL Distribution line, and that transfers to the...
  12. MentatDragon

    Database setup has not been completed error on new company

    Try logging in as sa - some third party apps require you to login as sa, the first time you go into a new company.
  13. MentatDragon

    Integration Manager help - getting started but in deep

    If you have any more problems, let me know. I have worked on GP Integration Manager for 8 years.
  14. MentatDragon

    Integration Manager help - getting started but in deep

    You probably set some fields in the dirstibution tree or have set the source record tab of that tree to something other than default.
  15. MentatDragon

    A/R Aged Trial Balance with Options

    Under SQL 2005, there is a new ODBC driver, and if you are on the old driver, that could be a problem. We just loaded SP5 in December and it was a very stable Service Pack.
  16. MentatDragon

    Signature on Checks

    The file can be BMP, also, if that helps. To add a logo or a graphic to a Great Plains report, follow these steps: 1. Copy the picture from a graphics program such as Paint. To do this, open the picture, then from the Edit menu click Copy. The logo can be no larger than 32KB and should be a...
  17. MentatDragon

    Dexterity Modification

    There are two ways, either user Modifier and add a DUOS field, or use Extender. both Modifier and Externder are separate modules, which you may or may not already own.
  18. MentatDragon

    Integration Manager help - getting started but in deep

    Can you upload or post the first 4 lines in the file? In Integration Manager, you may need to refresh your columns. Aslo, if the Itme number is numeric, the column may be setting itself to numberic instead of String.
  19. MentatDragon

    Great Plains periodically running slow

    You may have a memory leak or a misbehaved application - or even spyware on the bad workstation. Try this: 1) Be sure that you have loaded the latest NT service packs. 2) Load a memory manager on the workstation (like CacheMan) and it will prevent memory problems. 3) Examine you Startup...
  20. MentatDragon

    How to get modfied form with new field to save changes?

    Great Plains has some excellent help on VBA and modifier. If you have access to CustomerSource, they have a word document that explains how to have a new field on the main screen update the real filed on the "drill-to" screen, and even avoid "winking" the form. Here is a sample: The easiest way...

Part and Inventory Search

Back
Top