Microsoft Dynamics NAV (Archived)

Difference in G/L Entry in Debit/Credit Total

(0) Share

Report

Posted on by jsshivalik

3,099

I Have Difference in G/L Entry in Debit/Credit Total . How can i find in which Transactions there is difference.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Difference in G/L Entry in Debit/Credit Total

It is not possible at all to have difference in debit and credit amount

1) Is anybody changed the amount from backend

2) Have you stop consistent function ?

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

RE: Difference in G/L Entry in Debit/Credit Total

Hi

That is ok. Now if exists how we can find in which Document's there is difference.

Thanks

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: Difference in G/L Entry in Debit/Credit Total

How do you know that there is difference ?

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

RE: Difference in G/L Entry in Debit/Credit Total

Hi

When i Sum Debit & Credit in G/L Entry

Thanks

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: Difference in G/L Entry in Debit/Credit Total

As amol told it is not possible system shall post mismatch entries.

Second ally you will have to manually find out the mismatch entries, and pass the adjustment entry.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Difference in G/L Entry in Debit/Credit Total

Are you sure is not about filters?

To find the difference:

- Export T17 entries.

- Summarize fields Amount grouped by transaction number and find the results different from null (zero).

You can do that in an sql query/view if you can connect to sql database.

NAV don't post transaction when there are differences (standard validation).

Someone modified a posted transaction manually or some development affected posting CUs so bad.

BR

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

RE: Difference in G/L Entry in Debit/Credit Total

You can export all the entries to excel (using configuration packages will be the ideal way) and then sum it based on document numbers. You will be able to find which document no is out of balance.

As everyone suggested, it is not possible to have a un balanced (Credit/Debit) chart of account. Once you find the document number, then try to find which or who causes the issue.

Was this reply helpful? Yes No