Adjust Exchange Rate only for selected month

julkifli33julkifli33 Posts: 808Member
Hi All,
I have a question regarding adjust exchange rate
I set my user allow posting from 1 jan to 31 jan 2018 (User Setup)

when I do adjust exchange rate from 1 jan to 31 jan 2018
it will show error message, posting date not allowed

is there a way that i can do revaluation only for month of jan 2018?
Thanks

Answers

  • einsTeIn.NETeinsTeIn.NET Posts: 1,025Member
    If you have open transactions in the system that are only shipped/received but not invoiced, the system posts some kind of estimation that will be corrected once the real value is determined. This correction is posted as close as possible to the original date of the estimation posting based on the General Ledger Setup. If the date of the correction posting is not allowed by the user setup, you will get this error message.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • julkifli33julkifli33 Posts: 808Member
    so how do I reval exch rate only for the month of Jan ?
  • einsTeIn.NETeinsTeIn.NET Posts: 1,025Member
    Well, if the issue is really related to what I think of, then the answer to your question depends on your situation and what you want to allow the system to do. I think the easiest way to bypass this error is to set the allowed range in General Ledger Setup to the same range than your User Setup. But I'm not sure if this is the best way since there's more to be considered, e.g. your period closing rules, where do the open transactions come from, and so on.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • BlackTigerBlackTiger Posts: 1,108Member
    julkifli33 wrote: »
    so how do I reval exch rate only for the month of Jan ?

    This is financially wrong operation.
    "You can’t just ask customers what they want and then try to give that to them.
    By the time you get it built, they’ll want something new.” Steve Jobs
  • BlackTigerBlackTiger Posts: 1,108Member
    There is a thing... In properly working environment there must be no exchange rate adjustments in the past. This procedure (adj. posting) must be run on daily basis to recalc all open documents. So there is only one possibility to have some "previous period" postings - posting something to the past period or entry application using wrong date.

    In this case posting date limitation and error message caused by this indicates there is definitely something wrong.
    "You can’t just ask customers what they want and then try to give that to them.
    By the time you get it built, they’ll want something new.” Steve Jobs
Sign In or Register to comment.