Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6500 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

ID:12664
Title:Issue with Journal Entry Back-outs in Analytical Accounting
URL:http://cvakumar.com/msdynamics/2010/04/26/issue-with-journal-entry-back-outs-in-analytical-accounting/
Description:

Hi all

Sorry for not posting for quite some time… Has been a hectic month and a half for me… :( But I have now come back and I have decided to post an interesting issue that we have faced in Analytical Accounting.

The scenario given below is based on the data in Fabricam, in Microsoft Dynamics GP 10 SP4 (but issue occurs in production companies as well). :)

I create a journal entry in Z-EUR as of 04/12/2017 in Fabricam with some debits and credits. The exchange rate for Z-EUR to Z-US$ on 04/12/2017 was 1.4 approximately. I provide all the appropriate AA information and post the journal entry with Analytical Accounting information.

Now when I try to backout the journal entry in GP after a month, I click on the Correct button and choose “Backout a Journal Entry” and choose the journal entry which I posted above. Once I click OK on this window, the voided journal entry details are populated in the journal entry window, where the user is not allowed to change anything, except the transaction date and the batch number.

The reason why the date is allowed to be changed is because when I actually void the journal entry, the actual period where I posted the original entry could have been officially reconciled and closed for posting. So I have to post this void as of the current date that I am voiding.

So I change the date to 05/12/2017. The exchange rate as of this date from Z-EUR to Z-US$ is 1.5. When the back-out journal entry is posted, the functional amounts are posted in the GL20000 table based on the exchange rate as of 05/12/2017 (i.e.) 1.5. But unfortunately, in the AA ledgers the backout automatically posts with the date as the original transaction and the exchange rate as of the original transaction date which is 1.4. This indicates that the date change made at the GL Transaction when voiding does not impact the AA ledgers.

This causes a huge differences in balances between the General Ledger table balances and the AA table balances at the functional level.

Many might feel that revaluation would fix this problem (just as I had thought) but just believe that revaluation does not look at AA tables at all.. It only revalues the values based on the GL summary tables. Hence this difference lying between the AA and the GL tables will never get fixed by the revaluation process… It will have to be a manual fix at the AA table level, which is really a tough ask, but unfortunately, that’s the only solution available right now.

We have raised this issue with Microsoft and have accepted it as a bug in AA, and are slated to release a fix for this in SP5, but please ensure that if you are a client (or) if you have implemented AA in many clients, please ensure that they are aware of this, so that we can handle the journal back-outs better till the fix for this is released by Microsoft… :)

Until next post…

Category:TIPS AND TRICKS BY MODULES: AA (Analytical Accounting)
Link Owner:
Date Added:June 21, 2010 04:09:35 PM
Number Hits:13
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.