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)

Hannes Holst 5,767 on at

Like (1)

Report

RE: GL Entries Reconciliation

Hi Krishnan,

I think the way to go is through either Customer Ledger Entries, Vendor Ledger Entries, Bank Ledger Entries etc.

These tables do have the field "Remaining Amount" and "Open". These fields are indicating that the transactions are not fully reconciled.

G/L Entries itself are not to be reconciled, because the G/L Transactions always consists of two entries in the G/L Table (that's a key ingredient of bookkeeping/accounting).

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

Like (0)

Report

RE: GL Entries Reconciliation

Thank you Mr. Holst for the swift response. I understand the points you mentioned. Unfortunately, the customer has recently acquired NAV and instead of importing opening balances they preferred to post transactions to make the NAV figures match their historical transactional data. They are facing some discrepancies in the figures with regard to expenses they posted via general journals. Now they are trying to identify where the figures are not reconciled exactly and hence this request for filtering the unreconciled journal entries.

The CFO is an SAP aficionado hence the expectation about NAV similar to SAP feature.

Regards,

Krish

Was this reply helpful? Yes No
npanchal on at

Like (1)

Report

RE: GL Entries Reconciliation

You need to use many tables/ fields to reconcille the G/L Entries.

1. G/L Register

2. Transaction No. in G/L Entry Table

3. Source Code in G/L Entry Table

4. Document No. & Posting Date

There are many fields can help you to find solution.

Let me know if more information required.

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (1)

Report

RE: GL Entries Reconciliation

Hi,

I did this for a customer once, too. Posting all transactions instead the open balances only. It's a valid approach. Just make sure, that the problem does not exists already in the source data. Make also sure, that you do not have to end the financial years in NAV (this would generate transactions which will change the numbers in the Chart of Accounts).

As I'm not into the problem, I can only give you general advise.

You could lookup the Customer/Vendor/Bank Ledger entries through the Document No. of the G/L Entry to check if the remaining amount is 0 or not. But because your situation is a migration, it might will not solve your problem.

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

Like (0)

Report

RE: GL Entries Reconciliation

Thank you Mr. Panchal. Customer wants something to similar to SAP's "Display Unreconciled Transactions" so that he can filter it down to those entries that are not reconciled thus reducing his task of poring over thousands of entries. Just wondering if any one in their experience have come up with any solutions or a workaround to fit in this particular feature.

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
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
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
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
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