Changes in Microsoft Dynamics NAV NL 5.0 SP1

This document describes the changes between Microsoft Dynamics NAV NL 5.0 SP1 and Microsoft Dynamics NAV NL 5.0.

Table of contents

Lookup button of No. field on sales order form doesn't work
Audit file is updated according to the latest requirements
Docket should be printed in the language of the customer
Rounding problem of amounts in electronic VAT declaration
Message appears when applying payment and refund
Cash Journal closed after error message
Audit file generates low virtual memory message
Initialize remaining Amount when clearing previous consolidation
Check on bank account goes wrong when using trailing P/G characters.
Update analysis view when posting Cash Journal
Not able to use the dataports to import Bank Statements
Spelling error in option string of field Information type
Wrong error message when changing currency euro field
Cash and Bank/Giro Journal sub forms contain 2 debit and 2 credit columns
No page break between dockets
Missing Functions button on form General Ledger Entries
License update needed for Audit file
Country code is missing on electronic ICL declaration

Lookup button of No. field on sales order form doesn't work

An error appeared when you use the lookup button of No. field on the Sales Order form. The table relation on this field is removed and also the lookup button on the form.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS23678 (Service Pack Fix)

Audit file is updated according to the latest requirements

The audit file is updated with the latest requirements from the Dutch tax authority. Next to that the audit file will now be generated from a report instead of a dataport.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS26257 (CDCR)

Docket should be printed in the language of the customer

General reports will be printed in English, but reports specific for a customer/vendor should be printed in the local language of the customer/vendor. A docket is a specific document for a customer, so for a customer with language code NL it should be printed in Dutch. This has been fixed.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS27519 (Service Pack Fix)

Rounding problem of amounts in electronic VAT declaration

The rounding of amounts in an electronic VAT declaration goes wrong when the field 'Print' on the VAT Statement form is unchecked. Code changes are made to take care that the rounding of the amounts is independent of the value of the 'Print' field.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS29032 (Request for Hotfix)

Message appears when applying payment and refund

When you have set up Payment Tolerance in Navision and you apply a payment to a refund in a journal, the system will not show any message and the payment will still be open. This is the way it is designed in the W1 version of Navision. When you perform the same action on the local Bank/Giro Journal form the message will pop up. This has to do with the fact that there is no document type available in the Cash Bank Giro functionality. Code has been added to the application to determine if we are dealing with a refund. When this is the case, the message will not appear anymore conform W1 design.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS29306 (Collaboration Request)

Cash Journal closed after error message

The number series for Cash Journal has a date which is last used for that number series. When you want to enter a new Cash Journal line with a date before this last date used, the system will give an error message. The form Cash Journal closed after you push the OK button on the error message. This has been fixed.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS29544 (Service Pack Fix)

Audit file generates low virtual memory message

Running the tax authority audit file in a database with more than one million G/L entries, will give several error message and ends with the message 'virtual memory low'. This problem is solved in the new released version of the tax authority audit file. See also 'Audit file is updated according to the latest requirements'.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30632 (Request for Hotfix)

Initialize remaining Amount when clearing previous consolidation

After performing a consolidation twice the amount and the remaining amount of the G/L accounts were different. This has been fixed by initializing the remaining amount when clearing the previous consolidation.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30705 (Request for Hotfix)

Check on bank account goes wrong when using trailing P/G characters.

The check on account numbers went wrong when it concerns Postbank account numbers, which are preceded with a P or G. This has been fixed.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30706 (Code Defect)

Update analysis view when posting Cash Journal

After posting a Cash journal the analysis view is not updated while the field 'Update on posting' is marked on the Analysis View form. This is caused by the fact that the local functionality for posting a Cash journal does not use codeunit 13, but uses codeunit 12 directly. A small change is made in table 11400 'CBG Statement' to fix this problem.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30713 (Service Pack Fix)

Not able to use the dataports to import Bank Statements

In previous versions the dataports to import Bank Statements must be started from the 'Bank/Giro Journal' form. In that case the bank account code needed by the process was known. Now, these dataports can be started from the menu because there can be multiple internal bank accounts in one file. To determine the bank account code changes were needed in the concerning dataports.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30789 (Collaboration Request)

Spelling error in option string of field Information type

The option sting of field 'Information Type' of table 11000006 'CBG Statement Line Add. Info' contains a spelling error. The text 'Adress Acct. Holder' is changed into 'Address Acct. Holder. Because of this change other relevant objects are also updated.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30790 (Code Defect)

Wrong error message when changing currency euro field

If the field 'Local Currency' on the Telebanking tab of form General Ledger Setup is equal to Euro, you are not allowed to specify the 'Currency Euro' field. The text of this error message is updated.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30794 (Code Defect)

Cash and Bank/Giro Journal sub forms contain 2 debit and 2 credit columns

By default only 1 debit and 1 credit column is showed on the sub form Cash Journal and Bank/Giro Journal, but you can add another debit and credit column to the sub forms which are identical to the default columns. From both sub forms 1 debit and 1 credit column is removed.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30798 (Code Defect)

No page break between dockets

When printing multiple dockets for Electronic Banking, not every docket starts on a new page. This has been fixed.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30803 (Code Defect)

Missing Functions button on form General Ledger Entries

The Functions button exists on form 'General Ledger Entries' but is lying right underneath the Application button. Menu items from button Application are moved to other buttons on the form.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS30805 (Collaboration Request)

License update needed for Audit file

As from this version Audit file uses report instead of dataport. Therefore an update of license is needed. Please request license change at EOC License update in Dublin.

Product Studio Vedbaek SE reference: PS31349 (Work Item)

Country code is missing on electronic ICL declaration

If the field 'EU Country/Region Code' of a country is empty on the form Countries/Regions and this country is used on the electronic ICL declaration, the country code is missing in the data. This has been fixed.

The following object(s) have been changed:

Product Studio Vedbaek SE reference: PS31744 (Code Defect)