RSSCategory: Great Plains

Dynamics GP 2010 Database SDK Downloads

| 03/30/2012 | 0 Comments
Dynamics GP 2010 Database SDK Downloads

Hi all I had uploaded the Dynamics GP 2010 database documentation on my site for online reference. For those who love to download this documentation for offline use, they can download the CHM files from the locations below. Download From Box.com Dynamics GP 2010 System Database Documentation Dynamics GP 2010 Company Database Documentation Alternate Download […]

Continue Reading

Dynamics GP 2010 Database SDK – Company Database Details Uploaded

| 03/30/2012 | 0 Comments
Dynamics GP 2010 Database SDK – Company Database Details Uploaded

Hi all As a follow up to my post titled “Dynamics GP 2010 SDK”, I have updated the SDK section with the details of the company database as well, as I had mentioned in the earlier post. You should now see a section in the SDK page as shown below for the company database, from […]

Continue Reading

Dynamics GP 2010 R2 Database SDK

| 03/28/2012 | 6 Comments
Dynamics GP 2010 R2 Database SDK

Hi all I have launched a new section in my blog called Database SDK which can be accessed from Documentation >> GP 2010 >> Database SDK When this page is opened, it gives options for viewing the details of the SQL objects in the Dynamics GP system database (i.e.) DYNAMICS. You can click on the […]

Continue Reading

Support Debugging Tool Customization #11 – Restricting Salesperson ID for Existing Customers

| 03/13/2012 | 1 Comment
Support Debugging Tool Customization #11 – Restricting Salesperson ID for Existing Customers

Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/139b760a-5c63-4b16-b480-79f0a569075c where the requirement was as below. “We want to modify the Customer Maintenance window to make the Salesperson ID field uneditable for existing records only.  I went into Modifier and made this field uneditable but that makes it uneditable each time the window opens.  We […]

Continue Reading

SQL Script for AP-GL Reconciliation – Updated

| 03/07/2012 | 4 Comments
SQL Script for AP-GL Reconciliation – Updated

Hi all Sometime back, I had posted the SQL Script for AP-GL Reconciliation in my blog. At the time of posting the script, it had supported only one account index for AP. Today, I have updated the script to support multiple account indexes for Accounts Payable. Please take a look at the updated script in […]

Continue Reading

Unable to drill into PA Inventory Transfer Inquiry Zoom from Historical Journal Entries

| 02/10/2012 | 4 Comments
Unable to drill into PA Inventory Transfer Inquiry Zoom from Historical Journal Entries

I was troubleshooting a recent issue in the community forums, where the user was trying to drill into the PA Inventory Transfer Inquiry Zoom window from a historical year journal entry. The PA Inquiry window opened but it did not populate any values in the window. However, when I tried to drill into the same […]

Continue Reading

SQL Script for AP-GL Reconciliation

| 01/17/2012 | 7 Comments
SQL Script for AP-GL Reconciliation

Hi all It has been some time since I have posted something useful on my blog. This was because I was busy writing up and testing the reconciliation script that I had developed to reconcile payables and receivables with the general ledger. In this article, I have posted a script to reconcile payables with general […]

Continue Reading