Solved

Group Consolidation - Automate intercompany elimination on unsold stocks

  • 26 June 2023
  • 2 replies
  • 115 views

Userlevel 3
Badge +5
  • Do Gooder (Partner)
  • 11 replies

Through elimination rules, IFS can automatically eliminate AP & AR. Is there an automatic way to eliminate the profit from unsold stock? Any improvements introduced in Cloud?

Example: Subsidiary A sells a stock worth of $100 @ $120 (keeping a margin of $20) to subsidiary B. The selling price of the stock in subsidiary B is $150. Company B sells 75% of the stock to 3rd party (150*.75=112.5). How can we eliminate the profit of unsold stock in IFS?

 

icon

Best answer by Ieva Rituma 26 June 2023, 12:47

View original

2 replies

Userlevel 6
Badge +16

There is currently no automated process for this. The way to get around this is to create a report which lists out any serial/lot tracked stock items still in stock at the period end, to show stock which has been purchased from an internal company. Then use the data around stock values to generate a journal for eliminating intercompany profit relating to unsold stock.

 

This does require serial/lot batch tracking to be enabled in order to trace stock back to its origins.

Userlevel 3
Badge +5

Thank you very much leva for the swift, clear response.

Reply