How to get the closing balance of GL subtotal line
- EDA001
- Topic Author
- Visitor
-
11 years 7 months ago #15027
by EDA001
How to get the closing balance of GL subtotal line was created 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?
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.
- gm.saran
- Offline
- Elite Member
-
Less
More
- Posts: 203
- Thank you received: 29
11 years 7 months ago #15028
by gm.saran
Replied by gm.saran on topic How to get the closing balance of GL subtotal line
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