business function to calculate cummulative balance in F0902

Andrew2009

Well Known Member
I have a period number and I want to calculate the accumulative balance for an account ID in F0902 up to that period number. Do you know of a business function that can do this?

My starting point is I have an account ID, can I get the above information without running my section over F0902?
 
Yep that works.

I used to do a select sum dummy view until I found that guy :)

Library: CFIN
Function: B0900008.ReturnAccountBalance (Account Balance Calculate)
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Index Alias Parm Name Type Value In Value Out
----------------------------------------------------------------------------------------------------------------------------------------------------------------
1 AID szAccountId String(8) 00179711 00179711
2 CO szCompany String(5) 00740 00740
3 LT szLedgerType String(2) AA AA
4 D02 jdThruDate Date(6) 4/1/2012 4/1/2012
5 SBL szSubledger String(8)
6 SBLT cSubledgerType Char(1)
7 CRCD szCurrency String(3)
8 POST cIncludeUnposted Char(1)
9 AN01 mnAmount Math Numeric(15) -.87
10 EV01 cBalanceType Char(1) 1

I think the 1 in cBalanceType adds the buckets up for you


And B0900060 also lists all the buckets for you
 
Last edited:
What if I have only MCU and SUB and i want to get the balance amount for that MCU and SUB in F0902. Is there a business function to do that?
 
Back
Top