Post Through GL for Computer Checks – with Analytical Accounting

| 08/04/2011 | 0 Comments

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

image

If we try to activate the same manually (with Analytical Accounting activated), we get the following error message and the system prevents us from turning on the Post Through GL functionality for Computer Checks.

image

However, when we login to another company on the same DYNAMICS instance, where Analytical Accounting is not activated, the system does not allow us to mark the Post Through GL option for Computer checks and gives the same error message as above. However, I had confirmed that Analytical Accounting was not installed by trying to open the Transaction Dimension window from Cards >> Financials >> Analytical Accounting >> Transaction Dimension, and I obtained the message below.

image

This indicated that Analytical Accounting was not installed or activated on this company and yet the system does not let me mark the Post Through GL option. (This issue happens on both Fabricam, Inc. and on a regular production company). This appears to be a genuine bug in Analytical Accounting, and I had tested this on GP v2010 R2 (11.0.1752)

As a work-around for this, I enabled the Post Through GL for Computer Checks in a company where Analytical Accounting was not activated by a SQL query, and “Eureka…”, it worked brilliantly and the computer check batches got posted through into the General Ledger successfully without any errors. The script I had used for updating the Posting Setup is given below. This script needs to be run on the specific company database where Analytical Accounting has not been activated.

UPDATE dbo.SY02300
    SET AUTPSTGL = 1
    WHERE SERIES = 4
        AND TRXSOURC = 'Computer Checks'

Hope this helps the community…

Until next post!

VN:F [1.9.22_1171]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)
Post Through GL for Computer Checks – with Analytical Accounting, 10.0 out of 10 based on 1 rating

Tags: , , , ,

Category: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008

About the Author ()