RSSCategory: SQL Server

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

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

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

SQL View for Daily Payment Summary

| 08/05/2011 | 2 Comments
SQL View for Daily Payment Summary

Hi all Based on a request from the community, I have decided to post a script for identifying all the payments made on a specific date from a checkbook and the details of what was voided for the specific date. This query helps a great deal in reconciling the funds that were used for processing […]

Continue Reading

Post Through GL for Computer Checks – with Analytical Accounting

| 08/04/2011 | 0 Comments
Post Through GL for Computer Checks – with Analytical Accounting

When you have Analytical Accounting module installed and configured in a GP company, the Post Through GL for Computer Checks gets automatically disabled in the specific company (even if it was turned on). If we try to activate the same manually (with Analytical Accounting activated), we get the following error message and the system prevents […]

Continue Reading

Payables HATB With Aging By Payment Terms (using Document Date)

| 07/25/2011 | 2 Comments
Payables HATB With Aging By Payment Terms (using Document Date)

As a follow up to my script for generating the Payables HATB With Aging By Due Date (using Document Date), I have decided to post a script for the same with aging buckets based on the document date (with the logic of payment terms). This will provide the aging buckets for each transaction based on […]

Continue Reading