we have a Holding with company code 001 und two companies 002 and 003.
The Holding collects costs of Management in a cost center. Example: at the end of the year $ 10,000. The holding company would like to bill this cost to the companies with a margin of 5 %. The costs are divided according to proportions, 40 % for company code 002 and 60 % for 003.
An invoice should be issued to the companies with automatically calculated amounts ideally.
Invoice to Company 002 $ 4,200
Invoice to Company 003 $ 6,300
Is there a way to solve this nicely? Currently this is solved manually in Excel.
Thank you very much