Financial Reports from Management Reporter do not match the Trial Balance Reports in Microsoft Dynamics GP

In case you encounter issue where the amount in financial reports which generate using Management Reporter is not tally to the GL value in Microsoft Dynamics GP, try perform the following self-check evaluation to determine the problem:-

1. Make sure the "Provisional" setting is always point to "Posted Only"

2. Is the report printing the same period as in GP?
3. Is there a huge chunk of data just posted in GP? Please allow ample time to let GP sync the data to Management Reporter if you are using Datamart.
4. Is the new account code created in GP included in Row format?
5. The posted transaction in GP with Analytical Accounting (AA) does not match to the AA data in Management Reporter, this might due to posting disruption in GP which causing data issue. Need to contact your GP vendor.

For more troubleshooting which due to Datamart, you may refer to link below which written by our peers Nancy Hogan.
Troubleshooting Data Sync Issues Management Reporter and Dynamics GP

For more troubleshooting which due to AA, you may refer to link below which written by Microsoft Support.
KB - Financial Reports from Management Reporter do not match the General Ledger Trial Balance Reports in Microsoft Dynamics GP

Comments

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries. Path: Reports > Financial > Cross-Reference > Select "Journal Entries" Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry Path: Reports > Sal...

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for numerous accruals and reversals, allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches i. After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii. There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j...

Using Inquiries in Dynamics GP to view document status - Work, Open, History

User will be able to check document status from Inquiry screen, whether is in Payables or Receivables. Path: Inquiry > Sales > Transaction By Customer Inquiry > Purchasing > Transaction By Vendor Work Status In both Receivables and Payables modules, the document is saved in the batch, not posted yet. Open Status In Payables modules, the document is posted but still have outstanding balance. In Receivables, fully paid document or voided document will still show Open status. You need to perform "Paid Sales Transaction Removal" in routine to change the status from Open to History. Refer to this link on how to perform. History Status In Payables module, a document is moved to ‘history’ status when the document is fully applied or voided.

GP How to Reconcile Payable/ Receivable Ledger to General Ledger Control Account using "Reconcile to GL"

The “Reconcile to GL” tool helps you find differences between Payables Management (and GL) and Receivables Management (and GL) automatically by coming out a report. The Rule of Thumb, GL balance for the AP Control Account should match up with the total on the Payable Ledger report and the GL balance for the AR Control Account should match the total on the Receivables Ledger report. "Reconcile to GL" will match each transaction between GL and Sub-ledger based on the setup account and posting date. Any transactions that don’t match and users have to start digging through detailed transactions to see what went wrong, “Reconcile to GL” can be helpful in this scenario. To perform Payable/Receivable Reconciliation Path: Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL 1. Type in your date range. 2. Select “Module”, either Payable Management or Receivable Management. ...

Hello Dynamics! The most dynamics software that bring your business forward

Search This Blog