Hello all,
I've been dealing with this error for couple of days now and I still cannot understand why am I getting it.
What I need to do, is to move current period's profit and loss into balance sheet. Below are the source and destination account properties:
- Source account: 910000, Revenue
- ICP = R,
- Custom1TopMember = [None],
- Custom2TopMember = AllCustom2 (all members including [None])
- Custom3TopMember = AllCustom3 (all members including [None])
- Custom4TopMember = AllCustom4 (all members excluding [None])
- Custom aggreation enable for all custom
- Is consolidated = Y
- Is calculated = N
- Destination account: 290030, Liability:
- ICP = N,
- Custom1TopMember = EQ_Movements(does not include [None]),
- Custom2TopMember = [None]
- Custom3TopMember = AllCustom3 (all members including [None])
- Custom4TopMember = AllCustom4 (all members excluding [None])
- Custom aggreation enable for all custom
- Is consolidated = Y
- Is calculated = N
The rule I'm creating in Calculation manager is of calculate type, the script is as follows:
Sub MoveProfitToBS(bLog)
HS.Exp "A#290030.C1#EQ_106.C2#[None].I#[ICP None] = A#910000.C1#[None],C2#AllCustom2.I#[ICP Top]"
End Sub
The rule validates but not deploys. The deploy error is as follows:
Error: Invalid Expression
HS.Exp "A#290030.I#[ICP None].C1#EQ_106.C2#[None].C3#[None].C4#[None] = A#910000.I#[ICP Top].C1#[None].C2#ALL.C3#ALL.C4#ALL"
Invalid Custom2 member specified for this function.
Invalid Destination specified for this function: A#290030.I#[ICP None].C1#EQ_106.C2#[None].C3#[None].C4#[None].
I have tried to change destination account Custom2TopMember, however with no effect.
Calculation Manager version: 11.1.2.3.500.063
HFM version: 11.1.2.3.500.4435
Has anyone of you have any ideas about the error reason and how to corect that?
Best regards
Marcin