Recent content by MentatDragon

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

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.

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

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

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

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

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

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

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.

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

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

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

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

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

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.