Options

Applying payments to customer ledger entries

Gurn39Gurn39 Member Posts: 8
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. ](*,)

Comments

  • Options
    SavatageSavatage Member Posts: 7,142
    nothing has been applied.

    How are you determining that? Are you looking at the Remaining Amount field? Is the "Open" field still checked?
  • Options
    ssinglassingla Member Posts: 2,973
    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?
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    Gurn39Gurn39 Member Posts: 8
    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?
  • Options
    ssinglassingla Member Posts: 2,973
    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?
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    Gurn39Gurn39 Member Posts: 8
    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.
  • Options
    GRIZZLYGRIZZLY Member Posts: 127
    I think if you're so smart to import CLE directly, then it would be no problem for you to debug application codeunit...
    Sincerely yours, GRIZZLY
    Follow my blog at http://x-dynamics.blogspot.com
  • Options
    Gurn39Gurn39 Member Posts: 8
    =D> =D> =D> =D> =D> =D> =D> =D>
    Thank you very much for being helpful.
  • Options
    genoviagenovia Member Posts: 2
    Hi how did you correct the error?
  • Options
    davmac1davmac1 Member Posts: 1,283
    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.
  • Options
    AyuWulanDewiAyuWulanDewi Member Posts: 5
    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,
    Best Regard,



    Ayu Wulan Dewi
Sign In or Register to comment.