Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Reversal Entry for Intercompany General Journal

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

We are facing issue for Intercompany daily Journal. Dynamics 365 F&O does not reverse exact same general journal entry when using the Reversal entry and Reversal date functionality. Mainly issue is getting created due to Intercompany Posting Profile.

For Example, Company A wants to allocate expense from GL 73330 of $100 to Company B in the month of April 21 and it should be reversed on the 1st day of the next month.

Original Entry posted to general journal for Source Company -

Entry Description Dr. Cr.
I/C Receivable Account (IC Posting profile) 100
Expense GL 73330 100

Reversal Entry for Source Company -

Entry Description Dr. Cr.
I/C Payable Account (IC Posting profile) 100
Expense GL 73330 100

My Main Issue is with Reversal entry whereby I/C Receivable Account should have been credited instead of I/C Payable Account. and Same kind of reversal effect should have been given for destination company as well.

Is there any way to handle this situation ?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reversal Entry for Intercompany General Journal

    Hi All,

    We have resolved the issue with additional Customization where we are copying the Original lines with (-) sign in the same Journal rather using Reversal Entry functionality. For Example, If Original line 1 is having debit value then we put (-) sign before value in reversal lines which will exactly reverse the intercompany Journal too.

    Thank you !!

    Regards,

    Viral Thaker

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reversal Entry for Intercompany General Journal

    Hello Viral,

    Thanks for the update.

    When you deal with IC transactions then companies often create and post invoices.

    You can of course do 'internal' allocations in the way illustrated but those allocations should typically be done on statistical account, i.e. those that are not included in your external financial reports that you submit to authorities.

    Irrespective of that, what might help in your case is PowerAutomate.

    I once did a blog for IC free text invoices.

    The same principle can be applied for IC journals.

    With journals things should actually be much easier.

    Maybe have a look at this post to get an idea how things might work for your scenario.

    dynamicsax-fico.com/.../

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reversal Entry for Intercompany General Journal

    Hi Ludwig,

    Thanks for the feedback !!

    I have used the following standard available feature for Auto Reversal of Intercompany Journal. It works well within company but is failing when Intercompany is involved.

    Reversal-Entry.PNG

    Can you please provide more details with regard to your Power Automate suggestion ? That will help.

    Regards,

    Viral Thaker

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reversal Entry for Intercompany General Journal

    Hi Momen,

    I have already raised a Service ticket with Microsoft Support.

    Thanks for Advice !!

    Viral Thaker

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reversal Entry for Intercompany General Journal

    Hi Viral,

    Don't you need proper invoices to 'allocate' costs among different legal entities?

    In case you don't, have you tried the reversal entry functionality? I have not tested this for IC GL journal transactions. Would be great if you could check if this does the job for you.

    Alternatively, have a look at PowerAutomate to create the allocations and reversals. This should work in any case.

    Best regards,

    Ludwig

  • Suggested answer
    RE: Reversal Entry for Intercompany General Journal

    Hi Viral, 

    Thanks for submitting your question, I would recommend to open a Service Request directly with Microsoft Support so the reported issue can be assessed by our Program Managers. 

    Thanks in advance. 

    Regards, 

    Momen Mansour

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans