Liquidated entities with nil balance in forms
Hi all,
I'm after some guidance for a capex form that I'm currently developing. Simply, it's a form that takes the current month closing balance (BS accounts) less the prior month closing balance, and need to categorise these movements.
At the end of FY24, 2 entities liquidated (LQE) and transferred assets to a new entity. In the entity dimension, it's timestamped in the 2 entities as no longer in use from FY25 M1 onwards. So for FY25, there is no form to fill in for the 2 LQE's but there is for the new entity.
However, at group level, it shows the FY24 balance with 2 LQE's and no balance for new entity, and FY25 is no LQE's, just the new entity. Because the setting means the 2 entities are no longer part of the group, it's no longer showing in the movement columns. See below.
The real movement for the month to be explained is -33k, but the calculated movement ignores the 2 LQE's and just shows the new entity with +164k addition. Any ideas how I can develop this form so that the liquidated entity movements can be incorporated? At the individual entity level, the forms work, but it's when it consolidates at Group level it's the issue. I feel like I'm just missing something very simple, but it's been a long day...
Presumably, the LQEs should have a closing balance of 0 at some point? In the screenshot they end 2024M12 with closing balances. I think you would either need to post some adjustment in 2024 to have these entities end the year with a nil closing balance, or alternatively, don't disable those two entities immediately until the 2025 opening position has been resolved.
