Vendor Balance certification in CR

[Former Member]

Hi Experts,

I want to develop the Vendor Balance due certificate as below.

Note: If am giving range of Vendor Code From and To. It should develop the statement for all the vendor's in seperate page.

A-ONE CARRIERS

E-101, KAILASH ESPLANDE

OPP.SHREYAS CINEMA

L.B.S. MARG,  GHATKOPAR (W)

MUMBAI – 400 086

Dear Sir or Madam:

     We wish to obtain direct confirmation of amounts due by / to us as of March 31, 2013.  Compare the information below with your
records on that date and confirm that this information agrees with your records
on that date or note the details of any discrepancies in the space provided
below.  Then please sign this request and
return / fax it / mail us to the under mentioned address:

SOCOMEC UPS
INDIA PVT LTD

B1, II Floor,
Thiru-Vi-Ka Industrial Estate

Guindy, Chennai– 600 032

Ph:044 39215400

Fax:044 39215450

Email:accounts@socomec-ups.co.in

Our records showed the following amounts as outstanding as at March 31, 2013.

Particulars	INR
Payable   to you	26,980.00

Please note that
the account balance for which we are seeking confirmation is the balance as of March
31, 2013, which may differ from the current balance as a result of subsequent transactions.

Your prompt attention to this request will be appreciated.

For Socomec UPS India Private Limited,

How to develop this ?

thanks in advance,

Regards,

Dwarak

[former_member226669 · Accepted solution]

Hi Dwarak,

The field address and the amount payable must be a database field I assume.

Rest all is just the Text.

You can put everything in a Details section using a Textbox and format it accordingly.

Go to Section expert and ffor details section check the checkbox New Page After.

- Nrupal

[Former Member · Accepted solution]

hi,

Yes, here, how could i show the line wise statement .

It should be like, Confirmation letter as above and followed by Statement of accounts(line data) in the next page for each Vendor code.

How could we achive this ?

thanks in advance,

Dwarak

[Former Member · Accepted solution]

Hi expert,

Could any give me a clue ?

Regards,

Dwarak

[former_member226669 · Accepted solution]

Hi Dwarka,

You can use two details section and select New Page After checkbox for both the sections.

- Nrupal