Display output for a single vendor with multiple rows -- Credit and Debit details in one stretch
I have a requirement to display the output in XML like the below Account TrxAmt FncAmt
Vendor Name Venodr No Dr. BGB005XR8P.E00HQ9410000.80171 12,800.00 8,211.97
GENPACT DANBURY117 Cr. BGB005XR8P.E00HQ9410000.80171 12,800.00 8,211.97
A Single vendor 'GENPACT' has two rows : One for Debit amount and other for Credit amount
I was able to display the output in different table outputs in RTF by grouping Vendor details in one group...and Debit and Credit information in another group like the below
for-each LIST_G_INVOICE
for-each G_INVOICE
Vendor Name Venodr No Dr.
GENPACT DANBURY117 Cr.
for-each LIST_G_DISB
0