Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Exchange gains/losses ...
Microsoft Dynamics GP (Archived)

Exchange gains/losses transactions are not being reflected in my A/P Historical Aging report, and throwing off reconcilliation to GL

(0) ShareShare
ReportReport
Posted on by TrentDavis 105

Hello All,

I am using Microsoft Dynamics GP 9.0.  It appears that some multi-currency transactions are throwing off the balance between AP and GL.  When these transactions are posted, they correctly generate the amounts for Exchange Gains/Losses to the GL, however the AP Historical Aged Trial Balance report does not reflect these amounts, which results in the GL Balance being more than AP by these amounts.

Is there an updated AP Historical Aging Report or some sort of fix for this?  This is extremely urgent!!

Any assistance would be greatly appreciated!

Thanks

-T.Davis

*This post is locked for comments

  • Peter Muchira Profile Picture
    Peter Muchira 1,910 on at
    RE: Exchange gains/losses transactions are not being reflected in my A/P Historical Aging report, and throwing off reconcilliation to GL

    Hi  Bruce,

    Is the Originating Posted Date the one in the GL  or the sub-ledger?

    McCarthy,

    Any more details on the 'link between the HATB reports and the MC020104/5' ?

    I am using GP 2010, and experiencing revaluation-related issues with GL/Sub Recon.

    Regards,

    Peter Muchira

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Exchange gains/losses transactions are not being reflected in my A/P Historical Aging report, and throwing off reconcilliation to GL

    I would also suggest checking the distributions on your payment apply transactions or any revaluation transactions - any missing accounts because the Realized should have offset all the Unrealized.  

    Having said that -in GP10  we have also seen some interesting balances on the HATB reports for both AR and AP due to MC gain/loss - in our case as with Dale's comment - balances appear that should not as they are paid and in history.  There is a link between the HATB reports and the MC020104/5 tables that seems to cause an issue with paid historical amounts showing up.  I am wondering if there was a 'fix' done for your issue on GP9 that causes the opposite issue on GP10.

  • Bruce Wilkins Profile Picture
    Bruce Wilkins 570 on at
    Re: Exchange gains/losses transactions are not being reflected in my A/P Historical Aging report, and throwing off reconcilliation to GL

    The originating posted date impacts the Aged Trial Balance report. When you apply payment to invoice in Apply payables Document window it shows for example TRX Date of 3/31/2011 but the Originating Posted Date might be 4/04/2011. So when you run Historical Aged Trial Balance for 03/31/2011 it doesn't reflect but if run with 4/04/2011 it shows. So for example the end of March it is a reconciling item but in April it will balance. Run a smartlist in account transactions and locate JE created when applying payment to invoice. Then add column Originating Posted Date and see what the date.

    Best Regards,

    Bruce Wilkins

  • Suggested answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Exchange gains/losses transactions are not being reflected in my A/P Historical Aging report, and throwing off reconcilliation to GL

    Which report are you using to balance A/P with G/L? If your current A/P report does not show the invoices in question as open, and you are using historical to balance, then somehow the historical report has gotten out of sinc with your records and is still showing them as open when they are closed. We have had this happen but on the A/R side (in fact, we have one right now, but luckily, the historical shows all the items as balanced and zero but still showing on the historical report).  We have had to ask our ISV to go on the server and "fix" the historical side to show the invoices are closed out completely so they will not show on the historical A/R report anymore.  Maybe the same issue applies to your A/P side.

    If the amounts are still open and are showing on current and historical A/P, then I am not sure why the A/P reports are not showing the exch rate g/l accurately.  If it occurred consistently, I would have thought it is a setup issue, but if it is intermittent, is it only happening on specific vendors? If the problem always happens on specific vendors, then you may have a card issue with those vendors.

    If you have an ISV, I would contact them to see where the problem lies.

    Good luck.

    Best regards,

    Dale Coulthard

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

Product updates

Dynamics 365 release plans