HFM Rules, negative cash entry
Hi,
I'm trying to replace a journal I do every month during consolidation.
Currently, a few accounts each month get a journal processed to reclass negative numbers from our GL cash account to liabilities.
how would I write script to accomplish this?
For example,
Account 110300 has a value of -1000, so a journal is put through for that balance of 1,000 to go to our liabilities account 297900.
Custom 1 is our average balance dimension.
A# 110300 C1#[None] D 1000
A# 297900 C1#[None] C 1000
A# 110300 C1#[MAB] D 1100
A# 297900 C1#[MAB] C 1100
The 110300 account sits in a rollup called CASHDF, and there are similar accounts which require entries when the account is < 0.