web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

NAV 2013R2 - Nothing to Post message (GL Journal..Cash Receipt Journal etc)

(0) ShareShare
ReportReport
Posted on by

Good afternoon all,

Just discovered a little issue today and wondering if anyone has experienced the same.

Server details

NAV 2013 R2 (Hotfix 3)

Standard Cronus database.

SQL Server 2008R2

On a server running the above whenever I post a Journal i.e.. GL/Cash Receipt etc. the following happens:

1) The journal posts (can see entries in GL Ledger Entries)

2) Get message "There is nothing to post"

3) The lines still show in the Journal page even though they posted.

4) There is no G/L Register entry for the journal.

I took the same database and put onto my local PC, SQL Server 2012, and I do the exact same process and it works with no issues.

Somewhat concerning!!

Has anyone experienced this? Thoughts? Comments?

Regards

James

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Good afternoon,

    After much review we discovered that "someone" had altered an SQL Setting, and that this change was impacting on the posting of transactions in NAV.

    1) Open SQL Server Properties

    2) Connections page

    3) Default Connection options

    4) The no count option had been turned on.  

    Once turned off all these issues disappeared.

    Regards

    James

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans