Wrong data for document on MC020103 table causes document to revaluate

(0) Share

Report

Posted on by Hernan Breinbauer

I have two documents on on US Dollars (funcional currency) and the other in EURO. Both where posted at the same time on the same batch. Somehow the document with currency in US Dollars (which is the functional currency) has infomation on the table MC020103 as if the originating currency is EURO. After some analisys I found that the information in table MC020103 is a copy of the information of the preceding document with EURO currency.

This garbage causes that the document revaluation is wrong. Does anyone knows how to solve this problem? This is the second time I found the problem. The first time I remove the duplicate info on the MC table. Now I will do the same thing, but I'm worried there is a bigger problem.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Jeff Grant on at

Like (0)

Report

RE: Wrong data for document on MC020103 table causes document to revaluate

Hi Hernan,

You are correct that you have a bad data condition as the MC20103 will interfere with revaluation results if not accurate.

To note, there are no known quality issues in default Dynamics GP code that would cause your end result.

As such, I would recommend is voiding out the invoice with the incorrect MC information (you will need to void out any applied payment as well) and re-entering the invoice in the exact same manner it to see if you get the same SQL result.

If you can recreate the same issue with default code I would then recommend opening up a support case so we can help you determine the exact cause for the jumbled MC data.

Best Regards,

Jeff
Dynamics GP Support