You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!