GL Entries Reconciliation

(0) Share

Report

Posted on by Krish-NAV

122

Hello,

Is there any way to filter out unreconciled entries alone in GL Entries? One of our client, who is coming from SAP, asking for a mechanism/feature to filter out in posted GL entries only those entries that are not reconciled. Was shown the SAP feature which has a check box, upon checking that shows only those entries that are not reconciled out of the entire entries.

Is there a workaround solution similar to the above in NAV? Any ideas or suggestions welcome.

Thanks & Regards,

Krish

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (2)

Krish-NAV 122 on at

Like (2)

Report

RE: GL Entries Reconciliation

Thank you Bleika.

Regards,

Krish

Was this reply helpful? Yes No
B on at

Like (1)

Report

RE: GL Entries Reconciliation

Hi,

I always insist with my customers that the G/L Accounts corresponding to Customers and Vendors should not allow direct posting. It's a complicated task to stay on top of the corresponding G/L Accounts if you allow that, and really no entry should be posted to these accounts if it's not backed up by a corresponding C/V Ledger Entry. If you loose control of that, then your Receivables/Payables won't match your accounts (and they should always match).

However, I must correct one thing: Customer & Vendor entries stay open until you apply a C/V entry with the opposite sign to them - reconciling G/L accounts has nothing to do with that.

My curiosity was basically because I have a customer I'm preparing to upgrade from 2009R2 to 2018. They've had a similar functionality (as your customer wanted) for over a decade and I must provide for a valid substitution (or re-implement the same).

Regards,

Bleika

Was this reply helpful? Yes No
Krish-NAV 122 on at

Like (0)

Report

RE: GL Entries Reconciliation

Hi,

As such no solution has been provided since the customer doesn't want any customisation. Moreover, it is posted entries. It is recommended that Direct posting is restricted to G/L Accounts. And suggested them to use sub-ledgers so that they can reconcile between sub-ledgers like Customer, Vendor ledger entries with G/L. It's a learning curve for me as well as am not a core finance person. There is no way to reconcile if you allow posting balances directly to G/L. At least that is my understanding.

And there is a column Open (with check boxes in each entry) in ledger entries of Customer, Vendor and Banks which remains checked if the entries are not reconciled with G/L. Anyone can correct me if am missing something here or if my understanding is wrong.

Regards,

Krish

Was this reply helpful? Yes No
B on at

Like (0)

Report

RE: GL Entries Reconciliation

Hi Krishnan,

Out of curiosity: how did you solve the the customers requirement?

Regards,

Bleika

Was this reply helpful? Yes No
Suggested answer

Krish-NAV 122 on at

Like (0)

Report

RE: GL Entries Reconciliation

Hi Sachin,

Thank you. Yes, I know and we have convinced the customer at last. At times we compromise on providing custom features without charging the customer. In this case it was my academic interest to know more about the feature as it is a learning for me personally as well.

Regards,

Krish

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: GL Entries Reconciliation

Hi Krish,

If customer is insisting in having the similar feature then we have to do customization. Please try to tell customer that each product has its own benefits, if they want best of the world by consolidating the best features of all products then customization will be required which will eventually add up to the product implementation cost.

I hope above will help you to convey the message to customer.

Was this reply helpful? Yes No
Krish-NAV 122 on at

Like (0)

Report

RE: GL Entries Reconciliation

Thank you Sachin. In fact what the customer wants is something similar to SAP (screenshot given below). I have highlightedd the feature with red rectangle. It is a check box to filter/display unreconciled entries only.

Convincing a SAP person seems quite difficult..

Reagrds,

Krish

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

RE: GL Entries Reconciliation

Hi Krish,

The scenario relates to reconciling sub-ledger figures with G/L Figures, NAV system allows users to prevent this issue where in user can I untick the Direct Posting field at G/L Account [Chart of Account]. This means, users will not be able to make any direct entry to those G/L A/c which are linked to Sub-ledger [Customer, Vendor, Bank, Fixed Assets, Inventory] etc.]

In case, user has not added the control & now want to verify the transactions which have impacted the discrepancy, those can be found by following below quick check points.

1. Go to General ledger Entries

2. Select the respective G/L A/c

3. Add the Date filter

4. Search for a field 'System Created Entry' under Additional Filter & add the value as No. System will show all entries manually posted to respective G/L A/c which has not impacted Sub-ledger.

Was this reply helpful? Yes No
Verified answer

Krish-NAV 122 on at

Like (1)

Report

RE: GL Entries Reconciliation

Sounds quite simple. However, am not a technical guy. Just the functional side predominantly. I know how to create a field but to link to other tables I need to talk to my technical guy. Thank you for the quick reply. Much appreciated. It is all a learning process for me as someone from a totally different background entered into NAV Functional Consultancy. :-)

Was this reply helpful? Yes No
npanchal on at

Like (1)

Report

RE: GL Entries Reconciliation

Looks simple using customization, if it goes to manual Reconciliation.

You need to create field in Ledger Entries, and give them access to G/L Register page, where you give them a boolean to mark them as reconciled, and it should update all field in Ledger Entry as Reconciled.

Was this reply helpful? Yes No