May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Recent Posts

Archives

General Ledger

Page 3 of 41234

GL Transactions with AA Details

Hi all

Today I decided to post a simple SQL code to fetch GL Transaction Details along with dimension codes from the Analytical Accounting module.

SELECT  A.aaGLHdrID,
        A.JRNENTRY,
        A.RCTRXSEQ,
        A.… Continue reading 

Year End Close Issue with AA – Workaround

Hi all

Recently, I was working on the year end for one of our clients and landed up in the error shown below during the YEC process for the General Ledger.

image

Based on the error message, I believed it was… Continue reading

Maintaining Data Integrity between Sub Ledgers and General Ledger

Hi all

I have been involved in the process of reconciliation between the sub ledgers and the general ledger at various clients and there has been various scenarios in which there has been a break between the sub ledgers and… Continue reading

Multicurrency Revaluation Series – Part III – Summary Balance Checks and Reconciliation

Hi all

This is the second part of the series of articles I am planning to write up on multi-currency revaluation process in Dynamics GP. In the earlier articles titled Multicurrency Revaluation Series – Part I – Revaluation Setup and… Continue reading

Multicurrency Revaluation Series – Part II – Revaluation Process Logic

Hi all

This is the second part of the series of articles I am planning to write up on multi-currency revaluation process in Dynamics GP. In the earlier article titled Multicurrency Revaluation Series – Part I – Revaluation Setup,… Continue reading

Page 3 of 41234