How to Group and Sum rtf elements - BPA Template
Dear Friends,
I am trying to create external template for Bill Presentment Architecture which is in .rtf. Template is having 3 section Invoice header, Lines and Tax summary.
Invoice Header and line section is ok, but facing some issues with Tax section.
LINE SECTION
LINE_ID ITEM RATE QTY BASE_AMT TAX_RATE TAX_AMT TOTAL_AMT
1 P0001 20 10 200 21% 42 242
3 P0003 40 30 1200 21% 252 1452
4 P0004 20 100 2000 10% 420 2200
5 P0005 50 10 500 10% 105 550
2 P0002 50 20 1000 6% 210 1060
I am trying to create external template for Bill Presentment Architecture which is in .rtf. Template is having 3 section Invoice header, Lines and Tax summary.
Invoice Header and line section is ok, but facing some issues with Tax section.
LINE SECTION
LINE_ID ITEM RATE QTY BASE_AMT TAX_RATE TAX_AMT TOTAL_AMT
1 P0001 20 10 200 21% 42 242
3 P0003 40 30 1200 21% 252 1452
4 P0004 20 100 2000 10% 420 2200
5 P0005 50 10 500 10% 105 550
2 P0002 50 20 1000 6% 210 1060
EXPECTED RESULT IN TAX SUMMARY SECTION WHICH I AM LOOKING FOR
TAX_RATE BASE_AMT TAX_AMT TOTAL_AMT
21% 1400 294 1694
10% 2500 525 2750
6% 1000 210 1060
I am able to do grouping on the basis of tax code but it's not summing BASE_AMT, TAX_AMT, TOAL_AMT at tax code level.
1