web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Subledger Journals are...
Microsoft Dynamics AX (Archived)

Subledger Journals are posted but account balance is not updated in Ax 2012

(0) ShareShare
ReportReport
Posted on by Madankumar Kasthuri 595

Hi,

I am using AX 2012 demo database system RTM. I have registered my company demo registration keys. I think this key is provided for AX 2009. It has accepted and working. However, I made an vendor invoice and posted from Accounts payable module. I selected the post option "post and transfer". When I look General Ledger trial balance report, this transaction wasn't there. I have seen similar type of issue mentioned in this forum. The solution what they mentioned is that to rebuild balances and update balances in Financial diemension sets. Also mark the option "update balances during posting process". I rebuilt and generated the General Ledger Trial balance detail report but it didn't bring the transaction. Also I made an general journal entry and posted. Still the account balance remains the same.

As I said, am using AX 2009 keys in demo database. Is this because of no valid registration keys for AX 2012?

Or

Can anyone suggest what could be the reason?

Thanks,

Shan

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    i have a similar issue in that when I run the detailed trail balance and compare to the summary trial balance I don't get the same total.  Updating the balances in the dimension sets doesn't seem to help.

  • Karen Hanley Profile Picture
    Karen Hanley 815 on at

    Check to see if you are posting to GL real time or you may be setup for batch processing.

    Go to General ledger > Setup > parameters > Batch transfer rules > Transfer mode

    Syncronous = Real time

    If you are setup for Batch processing, you will need to go to Periodic - Batch Transfer for subledger journals.   You can also go to Inquiries > subleger journal not yet transferred to see if there is anything in there.

    I hope this helps.

  • Community Member Profile Picture
    Community Member on at

    Our GL is set up for realtime posting.

  • Madankumar Kasthuri Profile Picture
    Madankumar Kasthuri 595 on at

    Hi,

    Thanks for your reply.

    Yes, I checked my parameter settings. It has rule type "Company", Source document type "ALL" and transfer mode "Synchronous", and Summarize accounting entries "No".

    I think its in real time. Your help and suggestions are welcome.

    Thanks,

    Madan

  • Karen Hanley Profile Picture
    Karen Hanley 815 on at

    Have you run the TB in Detail?  There are some issues with the summary TB.

    Have you validated the AP transaction did post and shows on the Vendor transactions?

    If you go to GL > Common > Trial Balance and click on posted transactions, can you see the transaction there?

    If you still can't find the posted transaction, you may want to log a MS support case.

  • Pranav Kumar Profile Picture
    Pranav Kumar on at

    Hi Madan,

    Did you get any succes with the issue?

    Thanks,

    Pranav

  • Community Member Profile Picture
    Community Member on at

    Rebuilding the balances in the financial dimension sets seemed to help.  GL>setup>Financial Dimensions>Financial Dimension Sets> Rebuild Balances (and I update balances as well.)  

    Be sure the box next to "Update balances during the posting process" is checked as well.

  • wbaguinaldo Profile Picture
    wbaguinaldo 40 on at

    Same with my problem, when i run detailed trial balance on the report, the total amount in detailed and summary is not the same they have different.  Is any body knows how to solve the issues.. Please help us.. Thanks in advance.. I tried to process what they advice of KJ but still the same problem.... Check to see if you are posting to GL real time or you may be setup for batch processing.

    I TRIED IT on the bellow instruction.. but the problem still the same...

    Go to General ledger > Setup > parameters > Batch transfer rules > Transfer mode

    Syncronous = Real time

    If you are setup for Batch processing, you will need to go to Periodic - Batch Transfer for subledger journals.   You can also go to Inquiries > subleger journal not yet transferred to see if there is anything in there.

  • Karen Hanley Profile Picture
    Karen Hanley 815 on at

    There are 2 new hotfixes avaialable from MS that may address your issue.  Log a MS case to confirm it is the same issue.  Ask about KB 2708448 (Records dead-locking causing GL imbalance issues) or KB 2717490 (Removes option to update dimension set at posting and instead will update balances by dimension set at time of report execution).  

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I believe you don't need a fix as this is the default AX behaviour. Suggest you to try the resolution mentioned by Ramona to re-build the balances on your dimension sets before running the TB list page in AX 2012.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans