Applied amount of a customer ledger entry

Cem_Karaer · 2009-12-30

Hi all,

I have a cust. ledger entry with a debit amount. In the Customer Ledger Entries form, I use Entry -> Applied Entries function so that I can find other cust. ledger entries applied to the particular debit entry. But Applied Customer Entries form does not show the amount that was applied to the particular debit entry. It only shows the Original Amount, Amount and "Closed by Amount". The "Closed by Amount" is useless because this value belongs to another irrelevant debit entry. How can I find the necessary applied amount by code?

Best regards.

Savatage · 2009-12-30

from the applied entries form have you tried Ctrl-F5 (Detailed Ledger Entries) to see if that has what you are looking for?

philippegirod · 2009-12-30

The "Closed by Amount" is useless because this value belongs to another irrelevant debit entry.

No, the Closed by Amount and Closed by Currency Amount show the value allocated to close this entry (the record you'are looking).

If you want for an entry to have the detail of entries which are related to the entry you are looking (original entry, currency reevaluations, discounts, applications, etc..) use the Remaining Amount drilldown.
If you want to have the entry (or the entries) which closed use Applied Entry.

Closed By Amount is very usefull.

Cem_Karaer · 2009-12-30

When I drill down the remaining amount, detailed cust. ledger entries of the debit entry are shown but those detailed entries have no data that will correctly lead me to the applying customer ledger entries. Yes remaining amount gives me correct applied amounts but not customer ledger entries that are applied. The Applied Entries function gives me the correct entries applied but not amounts applied. I cannot create the link between two. This is the problem.

The main reason why I want to link applied entries and applied amount is that finance charge routine of one of our customers is completely different from the standard one. I must precisely know which entries and how much of their amount applied to the credit entries.

Cem_Karaer · 2010-01-04

It seems that what I request is not possible with standard functionality or have I not been able to express it? If it is not possible with the standard then I will have to handle it with a high-impact development.

philippegirod · 2010-01-04

No....
You have another kind of problem in your database because, with a standard using of Navision:
Drilldown in Remaining Amount shows all detailed entries linked to the Entry, so, also the closing entries (see Entry Type = Application, and Navigate on it).

Entry, Apllied Entries shows only the entry (or the entries) applied to your entry, with exact Applied Amount.

It must be like that, if it's not, there is a problem somewhere, show us an detailed example.

Cem_Karaer · 2010-01-04

The example for debit entry, its detailed ledger entries, the applied credit entries and their respective detailed entries can be examined in the excel file below:

http://rapidshare.com/files/330142464/Cust._Ledger_Entry_Example.xls.html

philippegirod · 2010-01-04

Sorry but your link doesn't work (unless to purchase a premium menbership access... what I don't want).

I suggest you to try in a Cronus database and check if the problem is the same.
If it is, I hardly recommend you to read again documentations related to Financial Management or Payment Management.

supportnav · 2011-05-19

hi anyone have solution for this ????

hi Cem Karaer, how did u handle this, any hotfix is thr ?

Applied amount of a customer ledger entry

Comments

Categories