How to create a JE involving multiple BUs and multiple A/C Codes using Financial Reporting?
We have a situation where we need to reverse and entry that was posted on the previous month on a regular basis. The initial entry credits a specific account and debits a fixed set of multiple accounts. The amounts can vary each month. When the reversal takes place next month, only the credit entry has to be reversed but the debt entries should go to another set of multiple accounts.
Since we have multiple Business units, the Credit entry will go to a balance sheet item that belong to the specific BU at the company level and the Debit entry will go to the P&L accounts at the BU level. The reversal will also have to take place accordingly. This has to be performed to all BUs (33 in total) individually, each and every month.