Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

TechKnowledge Content

Issue

How can I update Multidimensional Analysis (MDA) accounts with Bank Reconciliation transactions?


Resolution

1. Before you post transactions in Bank Rec, you will want to make sure that you are set up to Post To General Ledger. You may do this by going to Setup | Posting | Posting. Here you will want to select your Financial series, and select the windows you are posting from in Bank Rec.


2. Make sure that Post to General Ledger is checked, and Post through General Ledger is not checked. This will create a batch in General Ledger after posting your information in Bank Rec.


3. You may now post your information in Bank Rec.


4. After posting, go to Transactions | Financial | Batches. Select the CM batch that was created from you posting in Bank Rec.


5. Select the transactions button, and pull up your transactions by selecting the VCR button in the bottom left side of the window.


6. When your transaction is showing, select (Highlight) the account that should have MDA information assigned to it.


7. Select the Account Analysis button. When this window opens, select OK, then close the Transaction Entry Window.


8. You may now select your batch in the batch entry window, and post it. You MDA information will be updated.

This article was TechKnowledge Document ID:32624

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×