@Jack Daryl Espiel-Oracle I'm hoping you can help me with this - when I'm aggregating by payee I need the individual payment amounts for each bill displayed. I can use transaction.amount but that just gives me the amount of the bill, not the amount that was paid.
In the below code, it's the Payment Amount field that I need the actual amount paid for each individual bill.
#OUTPUT START#
<#assign recordCount = 0>
Check Number,Check Amount,Payee/Vendor Name,Invoice Number,Payment Amount
<#assign recordCount = recordCount + 1>
<#list payments as payment>
<#list transHash[payment.internalid] as transaction>
<#assign entity = entities[payment_index]>
${payment.custbody_lb_svb_check_number},${formatAmount(getAmount(payment),"currency",".")},${encloseString(setMaxLength(buildEntityName(entity,false)?upper_case?trim,60),60,",","\"")},${setLength(transaction.tranid,10)},${formatAmount(transaction.amount,"currency",".")}
</#list></#list>
#OUTPUT END#
Here are my results:
Check Number,Check Amount,Payee/Vendor Name,Invoice Number,Payment Amount
35635,"43.41","My Vendor, LLC",BILL123,21.21
35635,"43.41","My Vendor, LLC",BILL456,22.22
The payment amount is showing the bill amount, not the paid amount, which should be 21.21 and 22.20, respectively
TIA!
