Skip to main content
Solved

Group Consolidation - Automate intercompany elimination on unsold stocks

  • Jun 26, 2023 9:11 AM UTC
  • 2 replies
  • 408 views

Forum|alt.badge.img+6

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?

 

Best answer by Ieva Rituma

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.

View original

2 replies

Ieva Rituma
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Answer
  • Jun 26, 2023 10:47 AM UTC

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.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • Jun 26, 2023 11:17 AM UTC

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