Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Swedish Invoice for 17...
Finance | Project Operations, Human Resources, ...
Unanswered

Swedish Invoice for 17,979.19 SEK results in overapply with Multicurrency

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,647

Situation is the Functional Currency for the transaction is Swedish Krona (SEK) and the Reporting Currency is Canadian dollar.

The exchange rate was set correctly for the time / date of the transaction.  When the invoice was sent to customer it was for 17,979.19 SEK (2,729.25 CAD) and when the cheques were received it was done in two payment over a period of 3 months.  

Invoice : 17,979.19 SEK (2,729.25 CAD) - exchange 6.6312997

First Cheque: 344.33 CAD (2,228.64 SEK) - exchange 6.6312997

Second Cheque: 2,375.18 CAD (15,750.55 SEK) - exchange 6.6312997

CAD 344.33 + 2,375.18 = 2,719.51

SEK 2,228.64 + 15,750.55 = 17,979.19 

So now we end up with SEK at ZERO balance and CAD at -6.02 .. To me that means that the amount paid / converted into CAD was over stated by 6.02

What is the best / only / recommended way to resolve this.  It should be noted at this time the client and the customer have no open transactions and it is not anticapted that they will at any soon.  The CFO "just wants the 6.02 removed from the system as it is showing up in the AR Subledger and damit - it should just not be there"

Thanks for your assistance.

Categories:
Microsoft Dynamics GP
  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Swedish Invoice for 17,979.19 SEK results in overapply with Multicurrency

    So funny thing when I was looking in the SQL Tables I was looking at the MC020102 table and that does not have the fields - - cause they are in the RM30201.

    Once that little matter was resolved, then setting the field to zero was no problem and it seems to have corrected the matter.   So the report is correct.  My last question is how will this effect the balance in the GL and AR subledger and how do I fix it if there is a problem.  

    Turns out this "issue" is very very old and I do not want to make any current period GL adjustments.  

    Thanks again for getting me straightened out.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Swedish Invoice for 17,979.19 SEK results in overapply with Multicurrency

    Brandon, I was thinking to do the same thing, however, I am not sure how to get to the field - as it does not show up when I type the name in the query window.

    Settled_Gain_CreditCurrT Settled_Loss_CreditCurrT Settled_Gain_DebitCurrTr Settled_Loss_DebitCurrTr Settled_Gain_DebitDiscAv Settled_Loss_DebitDiscAv Revaluation_Status

    0.00000 0.00000 6.02000 0.00000 0.00000 0.00000 4

    140.55000 -53.55000 53.55000 -69.31000 0.00000 0.00000 10

    sorry bad data pasting but coming over vpn and two workstation - lol - it is the Settled_Gain_debitcurrTr field that is the 6.02 value.  That was my first try - but maybe I am doing something wrong in identifying the field.   My second guess is that it is a calculated field and I can not do anything  with it (hoping I am wrong)

    Thanks.

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Swedish Invoice for 17,979.19 SEK results in overapply with Multicurrency

    Hey Bill,

    Are you seeing the -6.02 value in any of the gain/loss fields in the RM30201? if so, you could try zeroing that field out and see if it drops of the report.

    Without being able to see what fields are populated, It's hard to speculate what/where it might be wrong.

    When I get cases like these, I personally re-enter the document manually to see if I can recreate the same thing. Most time I cannot because the data is imported and usually imported wrong. Then I compare my manually entered transaction to the problem one to determine what values were wrong. Then you can try to adjust the values to match the correct one.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans