web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2009 Customer Excha...
Microsoft Dynamics AX (Archived)

AX 2009 Customer Exchange Adjustment report showing wrong balance

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

        I refer to AR -> Periodic -> Exchange adjustment

        The issue is that the Customer exchange adjustment report generated after running the exchange adjustment totally incorrect 'Balance as at' figures for certain customers.

Analyzed one of the Customers as follows

   - Listed the customers open transactions

   - Ran a simulation of the exchange adjustment . Correct balance appeared

  - Identified the exchange amounts that will be posted to the Forex Unrealized Loss A/C and Trade Receivables

    - Ran the Customer Adjustment.

    - Compared the Customer exchange report's balance of the customer with the customers aging report and Customer outstanding balance.

 - Thee customer I checked for had only ONE open transaction ( As per Customer details -> Balance -> Open transactions) , but it was nothing was displayed for the customers transactions in Exchange adjustment when the 'Show Open  only' checkbox was selected.

Note:   The ledger postings were correct after this exercise ( Good!)

Since we cannot reprint the customer exchange adjustment report , is there any other way to access it ? ( Table ?)

Also I did not run the Batch job for Customer adjustments. Will running this adjust the already settled transactions or just the open transactions ?

Thanks in advance!

Adrian.V

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Good day,

     Is there anyway to reprint the Customer Exchange adjustment report after running the Exchange Adjustment ?

     Seems quite baffling that the Simulation report ( run before adjustment ) and the Actual exchange report ( run after adjustment) are different, the simulation report being correct.

    Also please direct me to the Customer Exchange adjustment report in AOT.

    Much appreciated!

    - Adrian.V

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    Hi Adrian,

    This functionality only has a simulation report. After posting you can only see the transactions within the voucher or the customer transactions.

    The functionality will only revaluate open amounts unrealized.

    If you run the simulation report and then someone posts additional transactions, also the new posted transactions will be reavaluated. The same happens when settling or unsettling transactions.

    Based on the customer transactions  you could create a new report yourself.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

     Yes I understand that. However I am  running the customer exchange in a testing environment where I am the only person  using it.  The customer transactions seem correct but  Customer ecxhange report's Amount Currency and MST values are way off.  

    I could design a report but I would need to understand how the records are fetched from the data source.

    Strangely the following query ( from data source of CustTran)  is what seems to output the incorrect Amount Currency and MST

    Select CurrencyCode,Accountnum,Sum(AmountCur),SUM(AmountMST) from

    CustTrans

    Group By CustTrans.CurrencyCode ASC,CustTrans.AccountNum ASC

    where CustTrans.AccountNum == <Cust code>

    Will dig around some more and see.

    Regards,

    Adrian

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Found the root cause.The report is not wrong after all.

    The  Exchange report shows the summation of all the customer’s transactions in the customers currency only. This excludes any settlements made for an invoice with a different currency.  For Eg :- if an invoice was issued in CNY but settled in USD , then that particular invoice amount will be taken up in the summation for CNY currency in the report. The report sums of these transactions plus the open amount.

    Trust this helps if you have a similar issue with the report. Or else as Andre says , customization!

    Cheers!

    Adrian

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans