Reversal of Unrealized Gain/Loss

ssinglassingla Member Posts: 2,973
Client requires as per their accounting policy, to reverse the unrealized gain and loss at the end of the reporting period calculated by running the batch job of Adjust Exchange Rate on the first day of the next reporting period.
Is their any standard functionality or customization needs to be done.
CA Sandeep Singla
http://ssdynamics.co.in

Comments

  • David_CoxDavid_Cox Member Posts: 509
    You could change the code to use a Reversing, Reccuring Journal, I am not sure how this function is run a codeunit or report, but copy the object to a new range and Alter to suit, then call the new object, so it will be easy to switch back if required.

    I have not looked as to how this function works, and if the records are marked in any way, I expect it just creates a few entries based on dimensions, so a reversing Journal should do what you want.

    Another safer way, is to change the report to just a hard copy report, then let them use the standard reccuring Journals manually to make the end of period postings.
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • ssinglassingla Member Posts: 2,973
    I have checked no mark is left after creation of entries. Further how we can use the reversing journal. I think recurring journal can not be used.


    Suggestion required.

    Thanks in advance
    Sandeep Singla
    CA Sandeep Singla
    http://ssdynamics.co.in
  • David_CoxDavid_Cox Member Posts: 509
    ssingla wrote:
    I have checked no mark is left after creation of entries. Further how we can use the reversing journal. I think recurring journal can not be used.


    Suggestion required.

    Thanks in advance
    Sandeep Singla

    Hi The Reccuring Journals are designed for the posting type's you require.
    If you select a type of variable reversing, navision will post in on the day you enter and reverse out the next day, have a play with it in the test system.

    All you need to do is use the report to calculate the currency gains and losses, without posting, and either create the entries manually in the reversing Journal, or do it in code, if you can.

    I have not looked at this area of the system for some time, so I cannot give you a step by step how to, at the moment.
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • ssinglassingla Member Posts: 2,973
    Thanks for ur help
    CA Sandeep Singla
    http://ssdynamics.co.in
Sign In or Register to comment.