How to get the closing balance of GL subtotal line

  • EDA001
  • Topic Author
  • Visitor
  • Visitor
11 years 7 months ago #15027 by EDA001
I have sub-total field in my GL which contains total overdraft amount.
The line number is 1820.
The various overdraft in gl lines is ranges from 1750 up to 1810 like the following

1750 INDUSTRY (MANUFACTURING)
1760 BUILDING AND CONSTR.
1770 DOM.TRADE & SERVICES
1780 INTL TRADE - EXPORT
1790 INTL TRADE - IMPORT
1800 TRANSPORT & COMMUNICATION
1810 OTHERS


1820 SUB TOTAL - OVERDRAFTS



In RE.STAT.LINE.BAL I have found the opening balance , credit movement, debit movement, and closing balance for the above overdraft types like the following.
@ID............. BOAGL-1810-ETB-20131105*ET0010003
@ID............. BOAGL-1810-ETB-20131105*ET0010003
LINE.CCY.DATE... BOAGL-1810-ETB-20131105*ET0010003
OPEN.BAL........ -4294510
OPEN.BAL.LCL.... -4294510
CR.MOVEMENT..... 66000.23
CR.MVMT.LCL..... 66000.23
DB.MOVEMENT.....
DB.MVMT.LCL.....
CLOSING.BAL..... -4228509.77
CLOSING.BAL.LCL. -4228509.77
MVMT.A.SPLIT....
MVMT.P.SPLIT....
MVMT.R.SPLIT....
CR.MVMT.YTD..... 125592731.89
CR.MVMT.MTH..... 365009.62
CR.MVMT.YTD.LCL. 125592731.89
CR.MVMT.MTH.LCL. 365009.62
DB.MVMT.YTD..... -120996607.2
DB.MVMT.MTH..... -154672.1
DB.MVMT.YTD.LCL. -120996607.2
DB.MVMT.MTH.LCL. -154672.1


But I cannot found the total overdraft amount for the sub total line, in this case 1820.
So can anyone help how to get the closing balance of the subtotal field which is 1820 using JQL statement?

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #15028 by gm.saran
I don't think "Total" fields are available in RE.STAT.LINE.BAL. "Total" fields are calculated ones; so they might be generated when the CRC/CRB reports are created and not stored elsewhere

Please Log in or Create an account to join the conversation.

Time to create page: 0.035 seconds