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
0
Comments
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.
http://www.BiloBeauty.com
http://www.autismspeaks.org
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
http://ssdynamics.co.in
But when I navigate from the payment, I still can't see the invoice applied + its applied amount. Am i missing something?
Thx
Go into the Cust Legder Entries
Pick a payment -> goto Applied Entries
Hit Ctrl-F5
does that give you what you need?
http://www.BiloBeauty.com
http://www.autismspeaks.org
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.
](*,)
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