Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Error In Processing VA...
Microsoft Dynamics NAV (Archived)

Error In Processing VAT Statement - Unbalanced TB

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi 

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 

Thanks

Shuaib

*This post is locked for comments

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Error In Processing VAT Statement - Unbalanced TB

    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)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error In Processing VAT Statement - Unbalanced TB

    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?

    Thanks

    Shuaib

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Error In Processing VAT Statement - Unbalanced TB

    Hi,

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans