Customer Ledger Entries applied amount

amphysvena

Hi,
In form Customer Ledger Entries (form id : 25), I could see many entries. For example payment. Then if I choose one of them (for example payment), then click the menu entry -> applied entries, I could see entries applied to this payment. In this case, invoices that was paid by this payment. The problem is, there is no applied amount for every single invoice applied.
The report Customer - Payment Receipt(Report ID :211), only shows the invoice that already closed by the payment. If the invoice still have remaining amount, it didn't show.
So, how I could get the applied amount for the applied entries?
Any help would appreciated. Thx

Savatage

What you could do is add "Remaining Amt. ($)" to form 62 "Applied Vendor Entries". Go to field list & drop it in.

Now when you look at what inv/credit were applied to a payment you will see the Remaining amount. This field you can drill into and if you do it will bring you to the detailed vendor ledger enties where you will see the amount that was paid.

amphysvena

Thx Harry.
If i looked from invoice, I could see the payment applied to this invoice + the amount allocated for this invoice.
There are 2 lines if I drill into the remaining amount:
- invoice; initial entry; invoice amount
- payment; application; amount applied for this invoice

But if i looked from the payment, there is no detail about the invoice paid.
It only contain 2 lines:
- payment; initial entry; payment amount
- payment; application; payment amount
note:the payment was used to pay many invoices

Btw, i'm using form 61 Applied Customer Entries.

Thank you

ssingla

Navigate and see detailed customer ledger entries.

amphysvena

Thx ssingla.
But when I navigate from the payment, I still can't see the invoice applied + its applied amount. Am i missing something?
Thx

Savatage

Sorry I originally was talking about Viewing Vendor Payments not Customer. Ooops :oops:

Go into the Cust Legder Entries
Pick a payment -> goto Applied Entries

Hit Ctrl-F5

does that give you what you need?

amphysvena

Hi Harry. Thx for the reply.
For some invoice (in the applied entries from a payment), the Ctrl-F5 showed the payment & its applied amount to the invoice.
But some invoice, when I hit Ctrl-F5, it didn't show the payment.

](*,)

amphysvena

Finally Made a report, with the algorithm in form 61 to get the documents (invoices), applied from a payment.

Then for each document i've got, get the applied value from the detailed cust ledger entry (detailed cust ledg entry document no. = payment no).
If there is no document no. the same with the payment no.,
I check the detailed cust ledg entry of payment, then get the applied value (cust ledg entry document no. = invoice no.)

But the problem is whenever there is a payment with, entry type in detailed cust ledg entry = correction of remaining amount.

Any help, would be greatly appreciated. Thanks