Accounts Payables

SQL Script for AP-GL Reconciliation – Updated

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

SQL Script for AP-GL Reconciliation

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

Posting Interruptions in Accounts Payable – Check Runs

Posting Interruptions in Accounts Payable – Check Runs

Recently, I was responding to a forum discussion where the issue mentioned was as shown below. “Occasionally, one of the subsystems that we integrate invoices from will send over an invoice with an incorrect date (11/20/1911 instead of 11/20/2011).  These invoices post just fine.  However, when we process a check run that includes an invoice [...]

SQL View for Daily Payment Summary

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

Additional Purchases Accounts for Vendors

Additional Purchases Accounts for Vendors

Hi all Sometimes, when we book invoices against vendors, we might have to post the expense into multiple GL accounts based for the purpose of financial reporting. Mostly I have seen a specific purchases account defaulted at the vendor level and the users manually add additional expense lines at the distribution window at the time [...]

Accounts Receivables

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

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

Receivables Inquiry Window – YTD Sales Amount Logic

Receivables Inquiry Window – YTD Sales Amount Logic

A client of ours, sent out an email today saying that the YTD Sales Amount that they see on the Receivables Yearly Summary Inquiry window does not match with the Receivables Transactions smartlist’s Sales Amount pulled for the specific customer for the specific year. On analyzing the issue, I noticed that they have only pulled [...]

Support Debugging Tool Customization #10 – Credit Limit Check Skip in Receivables Transaction Entry (using SQL Execute in SDT)

Support Debugging Tool Customization #10 – Credit Limit Check Skip in Receivables Transaction Entry (using SQL Execute in SDT)

Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/a3237a4f-fa4c-4603-8048-94cc0b2af467 where the requirement was as below. “Is there anything in Accounts Receivable that will allow a certain type of document (whatever that may be) bypass the Credit Limit Check? My client has a customer with a Credit Limit of $5000. They are additionally seeking a [...]

Indicator to specify single page or multi page customer statements

Indicator to specify single page or multi page customer statements

Recently, I was assisting a forum user, who had requested an option to provide a visual indicator in the footer of the customer statement report, which indicates if the statement has a single page or multiple pages. After a little thought I had come up with this idea and replied back to the forum user [...]

Support Debugging Tool Customization #6 – Removing Voided Documents from Customer Statement

Support Debugging Tool Customization #6 – Removing Voided Documents from Customer Statement

Based on a recent support request, I have decided to post yet another article which utilizes the Support Debugging Tool to achieve the above requirement, where in the voided documents do not appear in the Customer Statement. For this requirement, I have customized the RM Statement On Blank Paper version of the Customer Statement. The [...]

Analytical Accounting

Post Through GL for Computer Checks – with Analytical Accounting

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

Restricting Dimension Codes to Specific Account Numbers

Restricting Dimension Codes to Specific Account Numbers

Hi all In this article, I am going to explain yet another functionality in Analytical Accounting, where we can restrict a dimension code to a specific account number (or) a specific range of accounts. When a dimension code is created, we need to grant access to the dimension codes to specific users who can use [...]

SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Budget Tree Node

SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Budget Tree Node

Hi all This script is in continuation to the previous article where I had posted a script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Dimension Code. This script is for viewing Budgets vs. Actuals (for amounts) at Budget Tree Node level. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = [...]

SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Dimension Code

SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting – By Dimension Code

Hi all Today, I am posting a script for analyzing Budgets vs. Actuals (using Amounts) in Analytical Accounting. However, there are two methods of analyzing the budget information in Analytical Accounting. They are: Node Level Dimension Code Level This script is for viewing Budgets vs. Actuals at Dimension Code level. I will be posting the [...]

Analytical Accounting Information Flow from Purchase Order to Receipts

Analytical Accounting Information Flow from Purchase Order to Receipts

Hi all This article is to explain how Analytical Accounting (AA) information is transferred from Purchase Orders to Receiving Transaction Entry. The scenario explained below is on an environment where there is one transaction dimension configured in Analytical Accounting. Create a Purchase Order with 2 line items as explained below. PO Number Line Seq. No [...]

SQL Server

Dynamics GP 2010 Database SDK – Company Database Details Uploaded

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

Dynamics GP 2010 R2 Database SDK

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

SQL Script for AP-GL Reconciliation – Updated

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

SQL Script for AP-GL Reconciliation

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

SQL View for Daily Payment Summary

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

Support Debugging Tool

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

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

Support Debugging Tool–Build 16 Available Now!

Support Debugging Tool–Build 16 Available Now!

Hi all The all awaited Build 16 of the Support Debugging Tool is available now…and of course with loads and loads of new features and splendid enhancements. Some of the key additions to SDT is listed below. Macro Recording Functionality SQL Profile Tracing Functionality Trigger Administration Functionality Automation Functionality for Microsoft Support Usage These are [...]

Support Debugging Tool Customization #10 – Credit Limit Check Skip in Receivables Transaction Entry (using SQL Execute in SDT)

Support Debugging Tool Customization #10 – Credit Limit Check Skip in Receivables Transaction Entry (using SQL Execute in SDT)

Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/a3237a4f-fa4c-4603-8048-94cc0b2af467 where the requirement was as below. “Is there anything in Accounts Receivable that will allow a certain type of document (whatever that may be) bypass the Credit Limit Check? My client has a customer with a Credit Limit of $5000. They are additionally seeking a [...]

Support Debugging Tool Customization #9 – Credit Limit Check Skip in Receivables Transaction Entry (using Native Dexterity Save Logic)

Support Debugging Tool Customization #9 – Credit Limit Check Skip in Receivables Transaction Entry (using Native Dexterity Save Logic)

Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/a3237a4f-fa4c-4603-8048-94cc0b2af467 where the requirement was as below. “Is there anything in Accounts Receivable that will allow a certain type of document (whatever that may be) bypass the Credit Limit Check? My client has a customer with a Credit Limit of $5000.  They are additionally seeking a [...]

Support Debugging Tool Customization #8 – Displaying Long Item Descriptions on SOP Blank Invoice

Support Debugging Tool Customization #8 – Displaying Long Item Descriptions on SOP Blank Invoice

This article is based on a recent support request on the SOP Blank Invoice Report form. The Item Description on the report was just 60 characters and the actual item description was about 100 characters. This resulted in the item description getting truncated. I have written this article using the article titled “How to display [...]

Blogs I Follow

Xbox One is revealed

Last night at 1 am (Perth Time), Microsoft revealed details of the next generation Xbox. The successor to the Xbox 360 will be named the Xbox One. The Xbox One, so called because it is the all-in-one entertainment system

Mailing Systems in CRM 2011 Demystified – Part 1

Note: Credits to Aishwarya Ramachandran for this series of articles. This is the first part of the series of articles that we are planning to publish on Mailing Systems in CRM 2011 Demystified . CRM online does not have a mailing system of its own…( read more )

Technical Tips for Management Reporter 2012 with Data Mart

Technical Tips for Management Reporter 2012 with Data Mart

Starting with RU3, Management Reporter 2012 includes a new “Data Mart” data provider for Dynamics GP in addition to the one included with earlier versions, which is now referred to as the “Legacy Provider.” With a few exceptions, Data Mart is Microsoft’s preferred data provider for Dynamics GP.

Extender 2013 Feature of the Day:  Extender Table Changes

Extender 2013 Feature of the Day: Extender Table Changes

What table changes were made? With all the new features that have been added to Extender 2013, the Extender tables had to change.

Microsoft Dynamics GP 2013 Web Client Unexpected Error

Microsoft Dynamics GP 2013 Web Client Unexpected Error

I restarted the virtual machine running the Microsoft Dynamics GP 2013 Web Client and tried to login but got the beow error message; An unexpected error has occurred. Press the Sign-in button to reconnect to the application

Other Recent Posts

Xbox One is revealed

| 05/22/2013 | 0 Comments

Last night at 1 am (Perth Time), Microsoft revealed details of the next generation Xbox. The successor to the Xbox 360 will be named the Xbox One. The Xbox One, so called because it is the all-in-one entertainment system

Continue Reading

Mailing Systems in CRM 2011 Demystified – Part 1

| 05/21/2013 | 0 Comments

Note: Credits to Aishwarya Ramachandran for this series of articles. This is the first part of the series of articles that we are planning to publish on Mailing Systems in CRM 2011 Demystified . CRM online does not have a mailing system of its own…( read more )

Continue Reading

Technical Tips for Management Reporter 2012 with Data Mart

Technical Tips for Management Reporter 2012 with Data Mart

| 05/21/2013 | 0 Comments

Starting with RU3, Management Reporter 2012 includes a new “Data Mart” data provider for Dynamics GP in addition to the one included with earlier versions, which is now referred to as the “Legacy Provider.” With a few exceptions, Data Mart is Microsoft’s preferred data provider for Dynamics GP.

Continue Reading

Extender 2013 Feature of the Day:  Extender Table Changes

Extender 2013 Feature of the Day: Extender Table Changes

| 05/21/2013 | 0 Comments

What table changes were made? With all the new features that have been added to Extender 2013, the Extender tables had to change.

Continue Reading

Microsoft Dynamics GP 2013 Web Client Unexpected Error

Microsoft Dynamics GP 2013 Web Client Unexpected Error

| 05/21/2013 | 0 Comments

I restarted the virtual machine running the Microsoft Dynamics GP 2013 Web Client and tried to login but got the beow error message; An unexpected error has occurred. Press the Sign-in button to reconnect to the application

Continue Reading