Fixing Ledger Entry for Reconciliation

ffomenko

Hello!

We run into the following problem during Reconciliation process. We have some ledger entries which are Open but which have Statement Status as Bank Acc. Entry Applied. When we look into the statement to which these entries appear to be applied they are not there.

Is there a way we can modify these entries and set Status Status to Open so that we can reconcile them properly with a latest statement? Or do we need to do something different to properly reconcile them?

- Fedor

ara3n

Is this a modification or localization?

Which Ledger table are you referring too?

ffomenko

Thank you for your reply!

I do not quite understand what do you mean by localization or modification. We have NAV 3.7 UK with some modifications (but i do not think that Bank Reconciliation was modified).

We were trying to reconcile a bank account. This was done before and everything worked fine. But now we run into an issue. We have few transactions which we know were not reconciled but they are not picked up by Suggest Lines function. When I looked at these transactions in Bank Ledger Entries I found that they had Statement Status set to Bank Acc. Entry Applied. I guess that is the reason why they are not picked up for reconciliation. But when I look at the statement these entries were applied to they are not there. So I guess a mistake occured, probably we did something wrong.

I wonder how can we rectify this situation. By posting correcting entries may be? I have never done that before so any help would be appreciated.

ara3n

If you are 100 % positive that the lines are not on the Statement they are associated, and this was caused by a bug, then you will need your solution center to fix the entries using their license.
If the lines are on the old statement, you can clear them and they would then appear on the new statement when you suggest lines.

ffomenko

Rashed, thank you for your help!

What is "old statement" and how can I clear lines from it?

ara3n

Those Bank Account Ledger Entry Have a field called "Statement No.". This statement No is the "old Statement"

Do you have any Bank Rec. Worksheet with that Number?

ffomenko

I understand now.

The lines in question are do not appear on the old statement they are associated with. So this can only be fixed by a partner?

ara3n

Yes, you cannot modify Ledgers with customer license directly.