Printing Customer Payment Entries

vicky_dada

Hi,

I am trying to create a report in which all the invoices and the applied payment entries are shown,

Eg:

Customer Inv No Amount
Applied Entries Amount

The report should also contain the invoices to which no payments are applied and the payment entries to which no invoices are appled

Please give some sugeestion

I have tried by linking the Detailed Cust Ledg Entry table and CUst Ledg Entry, but the problem I am facing is I am not able to pring the Payment discount Entries.

Eg: for 2000/- Invoice, 200/- is the discount and 1800/- is the payment recieved, I am not able to print

Invoice 2000
Payment 1800
Payment discount 200

Instead my report is
Invoice 2000
Payment 2000

Savatage

Do you have report 10042 - Customer Account Detail?

ssingla

Savatage wrote:

Do you have report 10042 - Customer Account Detail?

Its should be a localization report not present in Indian Database.

Savatage

http://savatage99.googlepages.com/10042 ... Detail.txt

Edit the text file 10042 - to 50000+ whichever you have open.
Several of My fields end in ($) Like Amount ($) - Yours might be (vat) or something else.

Find & Replace ($) with whatever it is and see if it gives you what you need.