I need to auto insert an elim record into HFM but I only have 1 pair of Elim record from FDM
Scenario: I use FDM to load into HFM. I have one Elim Record loaded. In Calculate routine I am grabbing this data using Dataunit.GetItemExtDim. Sample below:
Entity = East
ICP = West
Acct = 10000
c1 = [None]
c2 = [None]
c3 = [None]
c4 = ELIMS
c5 = SAP2
data = 100,000
I do not want to use FDM to insert an opposite record to use to eliminate 100,000 but want to use HFM rule do to so.
So I need to do an insert by flipping West and East and entering the Elim account 20000. Shown below:
Entity = West
ICP = East
Acct = 20000
c1 = [None]
c2 = [None]
c3 = [None]
c4 = ELIMS