Monthly Archives: November 2011

How to clear Change Log Entry table from SQL?

In my previous article about Change Log, I have explained how to clear Change Lot Entry table from Dynamics NAV. However, I also mentioned, that when clearing entries from Dynamics NAV, system is deleting only one change log entry at … Continue reading

Posted in Dynamics NAV / Navision, SQL | Tagged , | Leave a comment

My posted sales invoice is missing from Dynamics NAV!

If you go to Sales & Marketing > History > Posted Invoices, and search for invoice by filtering in “Order No.” sometimes you might not find any invoices. There are two possible reasons for that – 1. (Quite common one) … Continue reading

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | 4 Comments

How to clear Change Log table?

There are a few tables that can become really big in Dynamics NAV. It is expected for our Ledger Entries to grow as time passes, but, quite often I hear people saying about Change Log Entries table is growing out … Continue reading

Posted in Dynamics NAV / Navision, functionality | Tagged , , | 1 Comment

How to delete ZUP file for Dynamics NAV in Windows 7?

In older Dynamics NAV versions (and obviously, working on Windows XP), I needed to delete ZUP files quite often. Now, when I think back, maybe too often… Anyway, C:\Documents and Settings\YourUsername\Application Data\ path (that’s where ZUP files were saved in … Continue reading

Posted in Dynamics NAV / Navision, functionality | Tagged , , , | 4 Comments

Error: BACS Exported must be No in Gen. Journal Line Journal Template Name=’PAYMENT’,Journal Batch Name=’GIRO’,Line No.=’10000′.

Once in a while someone will ask me: could you reset “BACS Exported” on Payment Journal for me? When faced with this question for the first time, my first though was – but why? And scenario is quite simple. Imagine … Continue reading

Posted in Dynamics NAV / Navision, errors, functionality | Tagged , , , , | Leave a comment

How to publish Dynamics NAV Web Services?

Today, I was asked – how do I publish Dynammics NAV web services? – That’s easy… click “Published”! – was my short answer. And only then I realized, that if you have never done this before, my short answer (even … Continue reading

Posted in Dynamics NAV / Navision, functionality | Tagged , , , | Leave a comment

How to find the size of the Company in Dynamics NAV?

I would like to share a quick and easy (well, maybe not the best way of doing things, but it gets results quite quickly) on how to check the size of the company in Dynamics NAV. Let’s say, you need … Continue reading

Posted in Dynamics NAV / Navision, Tips & Tricks | Tagged , , , | 1 Comment