Multi-currency and multi-ledger variances

Is there a process guide to set up and process period currency variances for multi ledger/currency journal entries that are using Daily Rate?  The scenario is when a non-collective clearing account, or, accrual account, like Payroll Payable, is posted against on one date and then the offset clearing entry is posted on another date.  The two journal entries reference the daily exchange rate, and, post in both a legal and group ledger.  The legal ledger matches and balances, however the group ledger (different currency) does not because the daily exchange rate is different.  This is not an AP or AR account, so the normal Gain/loss conversion variance does not calculate.  

What is the correct way to set this up in X3?  The group ledger is carrying an exchange rate variance that must be resolved.  One ledger JE's are not permitted.

Thanks!

Tom

  • 0

    Did you manage to resolve this? Am having similar issues with currency revaluations   

  • 0 in reply to mavara

    Thank you for asking.  There were no responses to the inquiry.  However, I would suggest looking at the conversion variance function.  When setting up your ledger there is a feature that is designed to manage these variances.  I believe X3 will record an adjusting entry line on the group ledger to accommodate the variance when a specific document is matched.  So the test might be to make the GL account of concern matchable.   I've not tested this solution, but it sounds reasonable.  Let me know if you find a good solution.