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
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.
Based on the error message, I believed it was… Continue reading
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
Hi All
I have been getting questions from many of my clients and network on the various levels of postings to the General Ledger accounts that are available in Dynamics GP. Hence I decided to provide some information on the… Continue reading
Hi all
Having used Analytical Accounting for quite some time now, I have come across various issues in Analytical Accounting module, which has caused serious data discrepancy between the General Ledger tables and the Analytical Accounting tables.
So I had… Continue reading
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
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