Beginning Balances not Showing in Management Reporter

We ran into an interesting issue where the numbers in Management Reporter did not match what was in Dynamics GP. We did the standard first step of re-creating the data mart and integration, but the numbers were still off.

Upon further investigation, the beginning balances were missing from the report. We looked in GP, and the trial balance looked right, but the MR numbers were still off.

Then we noticed that the Source Document for the beginning balances was not the standard "BBF"; it was "BF". It appeared that something had happened to GP during the year end close, so they created a journal entry to replace it then altered it in SQL to change the transaction date.

We had to update the Source Document in SQL and gave it an Original Transaction Source of "CLOSE". After re-creating the data mart, all was well in the world.