Applying payments to customer ledger entries

Gurn39

Hi everyone,

Firstly let me apologise for being a pain. My problem is probably simple to resolve but i have been banging my head against a brick wall.

The problem is as follows :-

We have transferred the customer ledger entries from an existing system to the Navision Sales application. We are now using the cash receipt journal to post payments against customers. This seems to work ok but the problem is when we try to apply the payment against what we have transferred to the customer ledger entries and a remaining amount remains against the payment.

Process used to apply payment :-
1. From Customer drilldown on balance field to display ledger entries.
2. Use the Apply Entries function.
3. Press Shift + F9 to set the payment as the applying entry.
4. Then press F9 to set applies to id on invoices to allocate payment against.
5. Press F11 to post and message appears that all lines have been posted successfully but nothing has been applied.

Would like to take this opportunity to thank everyone for assisting me with this problem.

Nav 5.0 (SP1) SQL Database.

Gurn. ](*,)

Savatage

nothing has been applied.

How are you determining that? Are you looking at the Remaining Amount field? Is the "Open" field still checked?

ssingla

Gurn39 wrote:

against what we have transferred to the customer ledger entries

How did you transferred the data to customer ledger entries? Was it direct impport in the tables or you followed the NAV posting routine?

Gurn39

The customer ledger entries were imported into the table directly because all that was required was to transfer the open items from existing system into Navision and did not want to update information on the Nominal hence the reason for not posting through a journal. Can we post usinga journal without affecting the nominal?

ssingla

Gurn39 wrote:

The customer ledger entries were imported into the table directly because all that was required was to transfer the open items from existing system into Navision and did not want to update information on the Nominal hence the reason for not posting through a journal. Can we post usinga journal without affecting the nominal?

This is not a recommended way and we strongly discourage this method.
Did you imported entries in the "Detailed Cust. Ledg. Entry" table too?

Gurn39

Detailed cust ledger entries were also created through the import.

I agree that this is not recommended and something i also discourage but how can i import open transactions from existing system into the customer ledger entry table with out affecting the gl account. If i import through a journal then i will need a balancing account.

The existing system is a Progress system and i have exported details out to a csv file.

GRIZZLY

I think if you're so smart to import CLE directly, then it would be no problem for you to debug application codeunit...

Gurn39

=D> =D> =D> =D> =D> =D> =D> =D>
Thank you very much for being helpful.

genovia

Hi how did you correct the error?

davmac1

In NAV, everything ticks and foots between customer ledger and the general ledger Ledger Entries. Bypassing this will destroy the integrity of your system.
You would be better off posting through to the General Ledger then reversing the journals.
A minor mod to the reverse journal functionality will allow you to do this easily, though I would put back the restriction after conversion has been finished.
Another way would be to set up a G/L account purely for the cash entries, and a dummy bank account too, then post the cash entries. Then you could have a pair of G/L entries reverse the amounts.

AyuWulanDewi

hi all...
i need help, i forgot to applying all payments to customer ledger entries when migrating to new database..it pains in my head when i must to applying again with that lots payments.. is there any easy way to applying all of it?

Best Regards,