Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

HFM cash flow script on inventory and account payable

2922523Jun 4 2015 — edited Jun 5 2015

i  have script on hfm cash flow  for inventory and account payable but i could not figure out how it is working out .. please look out and have a words.

How decreses and increase is calculation here....

-------------------------------------------------------------------

Hs.Exp "A#CFInven = A#Inventories.C4#Decreases - A#Inventories.C4#Increases"

is it from here??? if so it looks another misery.... pls help...

'--------------------------------------------------

'

'       INCREASE_DECREASE Procedure

'

'--------------------------------------------------

Sub Increase_Decrease(Destination,Source,Factor,Scale,Inverse)

  If Inverse = False Then

    HS.EXP Destination & " = " & Source  & " * (1 + (" & Factor & " / " & Scale & "))"

  Else

    HS.EXP Destination & " = " & Source  & " * (1 + ((" & Factor & " * -1) / " & Scale & "))"

  End If

End Sub

  this looks completely unfamiliar

----------------------------------------------  

Hs.Exp "A#CFAcctsPay = ((A#BankOverdraft.C4#Increases - A#BankOverdraft.C4#Decreases) + (A#ShortTermPay.C4#Increases - A#ShortTermPay.C4#Decreases) + (A#ShortTermPayInterco.C4#Increases.I#[ICP Top] + A#ShortTermPayInterco.C4#MOvement.I#[ICP Top] - A#ShortTermPayInterco.C4#Decreases.I#[ICP Top]))"

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details