Currency Exchange Rates from RSS (using .NET Interop)

This great blog post from Bardur Knudsen (Currency Exchange Rates from RSS) sounded to me like an invitation to extend it using .NET interop variables with Microsoft Dynamics NAV 2009 R2 based on System.XML namespace. http://msdn.microsoft.com/en-us/library/system.xml(v=VS.80).aspx Attached to this blog you will find 3 objects in TXT format (1 table, 1 codeunit, 1 page). Inside…


Currency Exchange Rates from RSS

An often requested feature is automatic download of currency exchange rates, and this short article illustrates how you can build your own using RSS feeds and MS XMLDOM 6.0 which should work with all NAV versions 2.0 to 2009R2. Going forward, you should consider using DotNet types instead. There are a lot of RSS feeds…


Using XBRL to Submit Balance Sheet and Profit and Loss Statement Electronically in Germany – Part 2

As a follow up on previous blog post we looked a bit deeper into draft XBRL specifications for Germany and came across couple of additional interesting findings. After importing the taxonomy you may get some lines with “Unexpected type: xxxxx”. When the Description field says “Unexpected type: xxxxx” it just means that built-in support for…


New VAT Registration Number in Switzerland

From 1.1.2011, Switzerland will enforce a new Tax Number called UID (Unternehmens-Identifikationsnummer). Authorities will assign new tax numbers to all new tax persons instead of old 6-digit VAT Registration Number. Existing tax persons will be informed of their new tax number in the first semester of 2011. During the period from 2011 – 2013 both…


New SEPA Whitepaper on PartnerSource and CustomerSource

I am happy to announce that due to popular demand, we have recently posted a whitepaper covering SEPA on PartnerSource and CustomerSource.   To give you a little bit of background, in 2002, key European banks decided to create a standardized payment strategy called the Single Euro Payments Area or (SEPA) to allow payments to easily…


What is SEPA?

We get a couple of questions asked quite regularly: “How can I make my ERP system SEPA compliant” and a more basic one “What is SEPA? And how does this affect my daily work?” With this blog entry I’ll try to answer these questions. SEPA is short for Single European Payment Area – which is…


Starting out with Fixed Assets Functionality in Dynamics NAV

One of the top customer questions we receive in the Fixed Assets area is about starting to use Fixed Assests instead of General Ledger. For example, a company wants to start using the Fixed Assets module from the 1st of January 2002. Acquisitions and depreciations have been posted in the general ledger until the 31st of December 2001….


Correcting Acquisition Cost Errors in Dynamics NAV

One of the top customer questions we receive in the Fixed Assets area is about correcting Acquisition Cost Errors. For example, an acquisition cost has by mistake been posted the 1st of May 2002 instead of the 1st of May 2001. The mistake is corrected by removing the entry with the function Cancel Entries and then…


Money Up Front: Prepayments in Microsoft Dynamics NAV 5.0

In a lot of business contracts, you’ll find that payment either in full or partial has to be made before the order is handed over to fulfillment. Like in ordering imported items, made-to-order items, or simply when a customer has no previous record with the selling company. On way of creating the proper documents for…