To get the Payment details against a customer

shibily

Hi
How can get the payment details from a customer against each invoice. It can be part payment. So how do i link the tables to get payment records against invoices?

Thanks in advance,

Shibily

kapil4dynamics

It is already there in the db see Customer Ledger and Detailed Customer Ledger entry tables.

shibily

kapil4dynamics wrote:

It is already there in the db see Customer Ledger and Detailed Customer Ledger entry tables.

Hi ,
I used the same tables as you mentioned.
I intended the tables as following
DataItem Name
Sales Invoice Header <Sales Invoice Header>
Cust. Ledger Entry <Cust. Ledger Entry>
Detailed Cust. Ledg. Entry <Detailed Cust. Ledg. Entry>

DataItemLink b/w sales Invoice header and CustLedger entry table is Document No.=FIELD(No.)
DataItemLink b/w CustLedger entry table and detailed cust.ledger entry table is Cust. Ledger Entry No.=FIELD(Entry No.)

Also filtered the detailed cust.ledger entry table with
Document Type FILTER <>Invoice
Credit Amount FILTER >0
The problem here i am facing here is sometimes i am getting repeated values in the report. The same records repeats in the detailed cust.ledger entry table. I dont have any specific field to filter further.

Regards,
Shibily

kapil4dynamics

Oh man u caught me on this, i am not a techie. I thought u wanted to know what tables to look for. Wait for some techie to see this.

ssingla

Use one more filter:
Entry Type<>Initial Entry

For more details have a look on Report 121 : Customer Balance to Date