Customer Ledger Entries applied amount

amphysvenaamphysvena Member Posts: 113
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

Comments

  • SavatageSavatage Member Posts: 7,142
    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.
  • amphysvenaamphysvena Member Posts: 113
    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
  • ssinglassingla Member Posts: 2,973
    Navigate and see detailed customer ledger entries.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • amphysvenaamphysvena Member Posts: 113
    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
  • SavatageSavatage Member Posts: 7,142
    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?
  • amphysvenaamphysvena Member Posts: 113
    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.

    ](*,)
  • amphysvenaamphysvena Member Posts: 113
    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
Sign In or Register to comment.