Reversal of Unrealized Gain/Loss

ssingla

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.

David_Cox

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.

ssingla

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

David_Cox

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.

ssingla

Thanks for ur help