web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Elimination of profits on inter-company stock sales

(0) ShareShare
ReportReport
Posted on by

During consolidation, we need to eliminate the profit margin on stock on hand arising out of inter-company transactions.

Is there any configuration or other setup that will help identify such stocks on hand at balance date and will help reverse the inter-company profit margin?

thanks

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi JacksNZ,

    How do you record and post the IC profits?

    Companies often make use of IC charge codes for that purpose that are posted against separate ledger accounts, which allows you identifying the IC profits recorded.

    Once you have that you can eliminate it against the 'higher' IC purchase costs.

    Best regards,

    Ludwig

  • JacksNZ Profile Picture
    on at

    As always, I admire your deep knowledge and experience and thanks for this.

    The idea was to have normal Revenue account in the selling account to post the sale price to the buying company (this will include the margin).

    From what you are suggesting, we can have another GL account, also in Revenue category in the selling company to record the margin -raised in the form of  a charge.-is this correct?

    So, the selling company would recognise the margin in a separate and identifiable account.

    As an example, one company sells to another IC in the group at $17 per unit 100 units (where the cost is $15 per unit).

    So, the revenue is recorded at $1500 (cost) and $200 recorded against another Revenue charge account.

    The buying company records the cost at $1700 for 100 items and during the period sells 80 units. At the end of period, the buying company will have 20 units at a cost of $17 = $340. However, of this $40 is unrealised margin for the consolidated entity.

    While the separation of margin at the time of inter company sale can be thus tracked and offset against the higher cost of purchase in buying company, not sure how to handle the unrealised margin on closing stock on hand.

    Looking forward to your insights here and thanks again.

    regards

  • AshokKumarGuptaEga Profile Picture
    Microsoft Employee on at

    HI JacksNZ,

    In the current design we don't have any out of box functionality to remove/exclude unrealized gain/loss on closing stock/inventory.  

    Based on my knowledge this needs to be handled outside the system as the mark-up percentage and process is different from product to product.

  • JacksNZ Profile Picture
    on at

    Thanks Ashok,

    appreciate quick response and advice.

  • Verified answer
    AshokKumarGuptaEga Profile Picture
    Microsoft Employee on at

    Hi JacksNZ,

    Please help to mark the thread as answered.

    Best Regards

    Ashok Kumar Gupta Ega

  • FinOps Profile Picture
    20 on at

    Hello,

    any solution we have now for this case? we are in 2023 :)

  • FinOps Profile Picture
    20 on at

    Any solution found for this scenario now, or workaround?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 659

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 465 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 304 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans