Management Reporter - Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only

So you are trying to install Management Reporter
You have installed the services
You are trying to deploy the data mart or the legacy and no matter how many times you put in the sa password you get the error above.

How to fix?
-Use a higher version of Management Reporter. The version you are using is possibly not compatible with your SQL version.

Analytical Accounting Error - Assigned amount does not equal the distrbution amount

So you are posting a journal and get the error only when posting not when you print an edit list.

What is wrong? The distributions in the AA Work tables are mixed up.

Review these tables and manually update where you see the credit and debit or even the percentage allocation is incorrect.

Tables:

• AAG10000
• AAG10001
• AAG10002

Revalue vs Non Revalue Items

When an item is not set to be revalued the following happens.

Scenario A with Non Revalued Item:

• Item Purchased and Received into stock at $500.
• Some of the item is subsequently sold
• Item is Invoiced through purchasing at different unit cost say $550.

End Result for Scenario A of Non Revalued Item:

• GL Updated with Inventory value of $500 from the Purchase Receipt
• GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
• Sub-ledger reflects the purchase receipt cost i.e. $500.
• Invoice difference is reflected in the purchase price variance account. This does not affect inventory sub-ledger as the cost remains the receipted cost and the inventory account matches this value in the sub-ledger as the difference is posted to the purchase price variance account instead of inventory.
• In the end the sub-ledger and GL balances but at the Receipt Cost.

When an item is set to be revalued the following happens.

Scenario B with Revalued Item

• Item Purchase and Received into stock at $500
• Some of the item is subsequently sold
• Item is Invoiced through purchasing at different unit cost say $550.

End Result for Scenario B with Revalued Item

• GL Updated with Inventory value of $500 from the Purchase Receipt
• GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
• Sub-ledger reflects the purchase receipt cost i.e. $500.
• Purchase Invoice difference Debits the Inventory sub-ledger for the $50 as well as the GL (instead of the purchase price variance account used in Scenario A). 
• The system automatically creates a journal to update the cost of sale and inventory where sales transactions were posted from this receipt layer. 
• In the end the sub-ledger and the GL balances but at the Invoice Cost.

In the end it is all dependent on what you want to see in your General Ledger. 

And no - Revalue Inventory does not result in your sub ledger to general ledger being out of balanced.

Note the snip below is for the Revalued Item at 600 and not 500 as listed in the example scenario above.

Management Reporter Error - Change Tracking not enabled for tables GL00100, GL00102, etc

So you are deploying Management Reporter Data mart and get the change tracking error.

Now this would result in you having to set each table noted to have change tracking enabled.

Instead of doing this you can -
Go straight to GP,
Admin -> Setup-> Company-> Company, click the Options button, turn off Enable GL Reporting and Turn it back on. This will reset the change tracking and you can proceed.

Some tables your error would note:
GL00100
GL00102
GL00200
GL00201
GL10000
GL10001
GL10100
GL10101
GL12000
GL12001
GL20000
GL30000
GL32000
GL40000
GL40200
MC00200
MC40000
MC40600
SY00300
SY40100
SY40101

Unable to Mount iso image

Unable to mount iso image from a mapped drive, error received as below.

You need to move the file to the c drive and then try again. You are not allowed to mount an iso from a mapped drive..

Error: 'There was a problem mounting the file"

MR Deployment Error

MR takes long to complete initialization.

The error below is found in the service deployment log

Sequence contains no elements
--- Exception Dump ---
Caught Exception: [Microsoft.Dynamics.Integration.Service.Tasks.RecordException] Sequence contains no elements
Stack trace:




To resolve execute the below on the Management Reporter database.

MERGE Reporting.ControlCompanyIntegration AS TARGET
USING Reporting.ControlCompany AS SOURCE ON (TARGET.ID = SOURCE.ID)
WHEN NOT MATCHED BY TARGET AND GLEntityID not in ('5F878A3C-5F4C-4806-B786-5CAB52C98F0F')
--Update the “1” as needed based on value in Reporting.ControlIntegrationSource
THEN INSERT (ID, SourceID) VALUES (SOURCE.ID, 1);

A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' cannot find the table.

Error when opening GP:
A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' cannot find the table.


Possible reason for issue:
The Dynamics.dic file may not be synchronized with the account framework.

To Fix:
To resolve this problem, resynchronize the Dynamics.dic file to the account framework. To do this, follow these steps:

1. Locate the Dex.ini file on the computer. To locate the file, follow the appropriate step:
   
   • If you are using Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 2010, the Dex.ini is in the Data folder of the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
   • If you are using Microsoft Dynamics GP 9.0, the Dex.ini is in the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
2. Open the file in Notepad.
3. Change the Synchronize parameter as follows:
   Synchronize=TRUE
4. On the File menu, click
   Save.
5. On the File menu, click
   Exit.
6. To start the synchronization process, start Microsoft Dynamics GP Utilities.