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

Notifications

Announcements

No record found.

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
    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
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans