Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Kathy Barthelt
/ Categories: Infor LN & Baan Tips

Infor LN & Baan Tips & Tricks for FINANCE:  Currency Differences Accounts

Currency differences can make the financial analysis and reconciliation more complex. These types of currency differences can occur:

  • Currency differences
    Currency result caused by fluctuations in the exchange rate, for example, if the rate differs between the invoice date and the payment date.

  • Exchange gain and loss
    Currency result caused by the use of different exchange rate types, for example, the Sales rate type and the Internal rate type, or if using the rate determiner you have changed the exchange rate for a transaction during the order handling procedure.

  • Translation gain and loss
    Currency result caused by the use of different currencies during the order handling procedure, for example, if the order currency or the payment currency differs from the invoice currency.

  • Destination gain and loss
    Currency result caused by different results when the transaction currency is converted to the various home currencies. Destination gain and loss can only occur in an independent currency system.

To support good reconciliation possibilities, currency differences and exchange gain and loss are posted to these accounts:

  • Exchange Gain and Loss
    For differences between related amounts (debit and credit postings) due to different exchange rate types or different currency rates.

  • Currency Translation
    For transactions in which the debit posting and the credit posting are made in different currencies.

  • Currency Differences contra account
    For currency differences on the invoice accrual account due to rate changes between the receipt date and the approval date of the invoice and calculated when you close a financial period.

Previous Article Infor LN & Baan Tips & Tricks for OPERATIONS: Update, Cancel or Remove Outbound Order Lines
Next Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: Advantages of Data Replication
Print
883 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

What will you do when your ERP is no longer supported in 2021?

This is a confusing time for many companies with respect to their ERP system.

"Will I still be able to run my current version?"
"What happens if I want to stay on my version?"
"What options do I have?"

Crossroads RMC is here to help you sort through the confusion and get you to a place where you feel confident about your ERP future.

Let's get started with how we can help. I want Crossroads RMC to…

  • Conduct an Infor ERP Utilization Review – Should I consider moving to the latest version of LX in the cloud, or on prem? If I don’t, what are my options?
     
  • Set up an Infor ERP Demo System – I want to give my employees a chance to try out the latest version to see if it would be of benefit.
     
  • Train My Employees – I want to ensure that we’re operating based on best practices.
     
  • Integrate My ERP to External Systems – My company uses separate systems that don’t talk to one another and that is really inefficient.
     
  • Brainstorm With Me – I’m not sure what to do. I need to talk through some scenarios with someone who has been there, done that.
     
  • Support My Users – I’m short-staffed. I may upgrade, or I may stay where I’m at. Either way, I could use someone to handle our ERP issues. Please help!

Contact us at 800.762.2077 or click here to request a free phone consultation and we'll get you back on track.

Did you know that you can clear production history?

JIT900 - Production History Purge

To clear field values from Production History Inquiry (JIT300). Run monthly as Day End Run and Month End Run which clears M-T-D fields.  There is an option to clear the average per hour and maximum per hour fields. This program can be run as often as you wish.

First4849505153555657Last

Theme picker

Tips: LN | Baan

Instead of sharing tables through logical linking, you can replicate table content between companies. This approach allows certain non-key attributes of a record to vary by company. For example, if you replicate bills of materials rather than sharing them, each company can associate a different warehouse with the same bill of material. This way, the bills of materials are consistent across companies, while the warehouses can differ.

Replication also enables selective availability of records in other companies. For instance, when replicating items, you might limit which items are available in a sales company based on their item group, only including end items. You can further refine replication to specific subsets, such as particular item groups.

Keep in mind that replication requires any referenced tables to be either replicated or shared as well.

12345678910Last

Theme picker

Categories