Bursting Report Query
Summary:
I want to build report something like below:
payment advise to supplier - |
Subject : Invoice ----- is paid |
mail body : Dear (supplier name)-->Got it , your invoice with below details is paid as under - |
27th june12 am | to |
Invoice No. | 12345 | cc |
Base Amount | 100 | bcc |
GST | 18 |
Invoice Amount | 118 |
TDS applied - section 194JB | -10 |
Payable amount | 108 |
|
|
Amount paid | 108 |
Amount remaining | 0 |
Amount paid details (this should list applied prepayments as well) | installment 1 | installment 2 | total |
Amount paid (aipa.AMOUNT) | 50 | 58 | 108 |
Date of payment (aipa.creation_date) | ######## | ######## |
|
UTR | xyz | abc |
|
Remittance bank account number |
|
|
|
Remittance bank IFSC (aipa.iban) |
|
|
Like it is containing two tables..one with invoice info and other with payment details ..and want to send this through bursting to supplier's email. Is there any option I can send this info in body of email instead as an attachment