SBX - Search With Button

SBX - Forum Post Title

Error In Processing VAT Statement - Unbalanced TB

Microsoft Dynamics NAV Forum

Shuaib_iqbal asked a question on 9 Aug 2018 12:54 PM

Question Status



We are currently using NAV 2013 R2

While processing the VAT calc. & Settlement Statement Nav had crashed

When I logged back in NAV had only processed one side of the journal [for the purchase ledger] but did not post the double entry into the settlement G/L account

This has resulted in an unbalanced TB

I can not reverse the transaction as it's not a journal and I cant post a journal to rectify this one sided entry as my journal wont balance.

Any idea's on how I can fix this problem - reverse/delete this one sided entry 



Hannes Holst responded on 10 Aug 2018 9:53 AM
My Badges


Did your SQL-server did crash too?

Or do you have any customization in that process?

What you are describing is impossible with the NAV-standard. As soon as the client crashes, the SQL-server notices the connection loss and runs a rollback automatically.

Shuaib_iqbal responded on 10 Aug 2018 10:00 AM

I believe the SQL server did crash - the message I received was the Program is not responding and then shut down

I would of thought there was a fail safe for this not to happen - but unfortunately it has

Any suggestion's on how to resolve this?



Hannes Holst responded on 11 Aug 2018 4:21 AM
My Badges

Hi Shuaib,

Normally, when the client does crash, the SQL is still alive.

Did you had to restart the ServiceTier or SQL-Server then?

From a solution point of view:

- when the incident is not to far away, restore an SQL-backup

- or, analyse the postings and cleanup manually (but this should be done by someone with experience)


SBX - Two Col Forum

SBX - Migrated JS