Analytics Software

Hi Experts:

I’ve designed and developed a data form in HFM to calculate the amount of MARGIN in the inventory of the receiving company (when the receiving company has received the inventory from an intercompany partner).

Does anyone have any experience or ideas how to write a rule (or use IC logic) to automatically eliminate this calculated amount against IC Cost of Sales?

The IC Cost of Goods sold entry will be the same at the margin in inventory (but this is not broken out separately in any account – just buried in COGS).

Does anyone have any suggestions for a rule/account/IC logic that could automatically grab this calculated balance in inventory and remove it from inventory as well as reduce IC_COGS?

We prefer to do this elim entry automatically if possible.    Is it possible to do an “auto” journal entry that could grab these amounts?    Or could we use a rule to populate an IC account so that this would self eliminate?

Should we set up an elim account part and populate them automatically via rules, then allow HFM to use it's built in IC elim logic?   This issue is that this entry occurs all on one entity, but I know it's possible to set up IC accounts so that you can book a balance with yourself.

How do I do this elim entry automatically in HFM?

Thanks,
Mark