4 Signs your growing business needs to rethink sales tax
August 15, 2017
Create a Consolidation and elimination entity
August 25, 2017

Currency Revaluation on Bank Transactions

We recently had a client that was transferring funds into a Bank account in one specific currency (EUR), and then would transfer the money out at a later date, using a different currency (USD.)
The issue here is that each transaction has different Currency Exchange rate on each transaction, meaning, that both transactions will generate a balance difference in the bank account.

 

They required AX to account for the exchange rate difference between these transactions. As this was not an AR, or AP sub-ledger transaction, Microsoft Dynamics AX 2012 would not automatically update the funds in the Unrealized gain/loss account.

To record this information correctly, users must follow the next steps:

1. Update the Main Account marking the “Foreign Currency Revaluation” checkbox.

2. Verify if the Realized, and Unrealized gain/loss accounts in the Ledger form (General Ledger/Setup/Ledger) are configured correctly

3. Go to General Ledger/Periodic/Foreign Currency Revaluation and run the process for the desired accounts. Make sure you select a date range, as well as the account type being revaluated (Balance Sheet, or Profit and Loss)

4. After the transactions are posted, the trial balance for the Unrealized Gain/Loss will show the following information

5. In the bank account involved, the balance will be updated taking into account the exchange rate difference as seen below

About the authors

Carolina Anzola is a System Engineer and Microsoft Dynamics AX/365 for Enterprise Senior Consultant at Pangea Group. Carolina is passionate about helping clients reach their operational goals and has over 10 years of experience working with clients in numerous industries, including telecommunications, technology, financial services, public sector and entertainment

David Diab is a Microsoft Dynamics AX/365 for Enterprise consultant at Pangea Group, a CRM and ERP solutions provider that helps understand, adapt, and improve customer business processes. Previously, David worked as an Information Technology specialist at Minnesota State University, Mankato; University from which he graduated with Magna Cum Laude honors with a Business Management Degree.

20 Comments

  1. cash payday loans online low rate loans easy payday loan online payday advance online

  2. Jamesgef says:

    payday loan instant payday loan online payday loan student loan refinancing online loans online loans online loans loans online direct lending payday loan centers a payday loan unsecured debt consolidation loans website personal loans online ace cash loans online private money lenders installment loans guaranteed installment loans guaranteed installment loans quick loans get a personal loan quick loans payday loan direct lenders only holiday money payday loan direct payday loan direct credit loans for bad credit bad credit personal loan quick loans loans online instant approval 5000 loans with low interest online loans payday loans online best online loans online loans no credit large payday loans cash advance mobile loans applying for a loan

  3. Jamesgef says:

    no credit check signature loans loans online loans online online pay day loans online loans online loans online personal loans get cash now loans payday loan direct apply for a loan with bad credit loan online a payday loan payday loan direct payday loan instant payday loan payday loan

  4. Jamesgef says:

    installment loans online online installment loans payday loan no debit card no interest loan online loans cash loans online online loans loans online cash advance fast cash advance fast cash advance cash advance fast cash loan payday loan how to get a loan advance payday loan loans online direct personal loans online loan apr debt consolidation advice plain green loans bad credit loans approved loans online no credit check payday loans online installment loans guaranteed installment loans guaranteed installment loans instant loan no credit check

  5. Loans Online says:

    loan payday payday loan payday loans lenders only payday loans

  6. free video chat rooms camgirls cam girl girls

Leave a Reply

Your email address will not be published. Required fields are marked *