SIFT totals are calculated incorrectly when you delete SIFT records in the Microsoft SQL Server Option for Microsoft Dynamics NAV

Microsoft Business Solutions-Navision 4.0 and Microsoft Navision 4.0 are now part of Microsoft Dynamics NAV 4.0. All references to Microsoft Business Solutions-Navision or to Microsoft Navision 4.0 relate to Microsoft Dynamics NAV.

This article applies to Microsoft Dynamics NAV for all countries and all language locales.

Symptoms

Sum Index Field Technology (SIFT) totals that appear in FlowFields are calculated incorrectly when you delete SIFT records in the Microsoft SQL Server Option for Microsoft Dynamics NAV 4.0.

Note Examples of FlowFields are the Inventory field in the Item Card dialog box and the Net Change field in the Chart of Accounts dialog box. When this problem occurs, the FlowFields display incorrect amounts. However, if you click the drill-down button in the fields, the correct amounts appear on the underlying entries.

Cause

This problem may occur if you delete one empty SIFT record or if you delete multiple empty SIFT records. An empty SIFT record is a record in which all amounts equal zero. When Microsoft Dynamics NAV later tries to update a SIFT record that was deleted, the update is aborted. Therefore, the SIFT total becomes incorrect.

Resolution

Hotfix information

A supported hotfix is now available from Microsoft. The hotfix corrects the problem that is described in this article. Apply the hotfix only to systems that are experiencing this specific problem.

To resolve this problem immediately, contact Technical Support for Microsoft Dynamics and related products to obtain the hotfix. You can log on to the Microsoft Dynamics site and create a new support request. To do this, visit the following Microsoft Web site:

https://mbs.microsoft.com/support/newstart.aspx You can also contact Technical Support for Microsoft Dynamics and related products by telephone at (888) 477-7877.

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.



How to obtain the Microsoft Dynamics NAV hotfix or update files

After you request a Microsoft Dynamics NAV hotfix or an update file from Technical Support for Microsoft Dynamics, a hyperlink will be sent to you in an e-mail.


The e-mail will contain a hyperlink and a password. You can use the hyperlink to download the Microsoft Dynamics NAV hotfix or the update files. When you click the hyperlink, the File Download – Security Warning dialog box opens. Then, you are prompted to run, to save, or to cancel the download.


If you click Run, the files start the download and the extraction process. You must specify a folder for the new files, and then provide the password.


If you click Save, you must specify a path for saving the compressed file. When you open the file that you saved, you are prompted to specify a path for the files. You must then provide the password provided in the e-mail.


If you click Cancel, the download process stops.

How to install a Microsoft Dynamics NAV hotfix or an update file

The Microsoft Dynamics NAV hotfixes and updates are made available as single files. To install a Microsoft Dynamics NAV hotfix or update, use the hotfix or the update files to replace the existing Microsoft Dynamics NAV installation files. To do this, follow these steps:

  1. Use the hotfix or the update files to replace the following files in the Microsoft Dynamics NAV client installation.

    File name

    File version

    File size

    Date

    Time

    Platform

    Dbm.dll

    4.0.3.24843

    345,552

    01-Jul-2007

    21:32

    x86

    Fin.exe

    4.0.3.24843

    8,119,760

    01-Jul-2007

    21:32

    x86

    Fin.exe.manifest

    Not Applicable

    711

    01-Jul-2007

    10:24

    Not Applicable

    Finhlink.exe

    4.0.3.24843

    120,272

    01-Jul-2007

    21:32

    x86

    Finsql.exe

    4.0.3.24843

    8,168,912

    01-Jul-2007

    21:32

    x86

    Finsql.exe.manifest

    Not Applicable

    714

    14-Dec-2006

    16:41

    Not Applicable

    Nc_netb.dll

    4.0.3.24843

    79,312

    01-Jul-2007

    21:31

    x86

    Nc_tcp.dll

    4.0.3.24843

    83,408

    01-Jul-2007

    21:31

    x86

    Nc_tcps.dll

    4.0.3.24843

    91,600

    01-Jul-2007

    21:32

    x86

    Ndbcs.dll

    4.0.3.24843

    1,086,928

    01-Jul-2007

    21:32

    x86

    Slave.exe

    4.0.3.24843

    95,696

    01-Jul-2007

    21:32

    x86

    Note The Microsoft Dynamics NAV client is typically installed in the following folder:

    C:\Program Files\Microsoft Business Solutions-Navision\Client\To replace the existing files, follow these steps:

    1. Close Microsoft Dynamics NAV.

    2. Locate the Microsoft Dynamics NAV client installation folder.

    3. Copy the files that you downloaded.

    4. Paste the files that you downloaded into the Microsoft Dynamics NAV client installation folder.

    5. In the Confirm File Replace dialog box, click Yes to overwrite the files in the installation folder.

    6. If the hotfix or the update includes translated versions of the fin.stx file or of the fin.etx file, you must replace the fin.stx file or the fin.etx file that is installed in the specific language folders of the installation folder.

      To replace the fin.stx file or the fin.etx file, follow these steps.

      Note The following example references a German installation.

      1. Copy any W1 fin.stx file or fin.etx file to the following folder:

        C:\Program Files\Microsoft Business Solutions-Navision\Client\

      2. Copy any fin.stx file or fin.etx file from the ENU folder to the following folder:

        C:\Program Files\Microsoft Business Solutions-Navision\Client\ENU\

      3. Copy any fin.stx file or fin.etx file from the DEU folder to the following folder:

        C:\Program Files\Microsoft Business Solutions-Navision\Client\DEU\In some cases, the new client executable files convert the database format. Therefore, you must update all clients. For the Native option, you must also update the server installation.

  2. If you have Microsoft Dynamics NAV Application Server installed, replace the following files in the Microsoft Dynamics NAV Application Server installation.

    File name

    File version

    File size

    Date

    Time

    Platform

    Dbm.dll

    4.0.3.24843

    345,552

    01-Jul-2007

    21:32

    x86

    Nas.exe

    4.0.3.24843

    1,422,800

    01-Jul-2007

    21:32

    x86

    Nassql.exe

    4.0.3.24843

    1,463,760

    01-Jul-2007

    21:32

    x86

    Ndbcs.dll

    4.0.3.24843

    1,086,928

    01-Jul-2007

    21:32

    x86

    Slave.exe

    4.0.3.24843

    95,696

    01-Jul-2007

    21:32

    x86

    To replace the existing files, follow these steps:

    1. Stop the Microsoft Dynamics NAV Application Server.

    2. Locate the Microsoft Dynamics NAV Application Server installation directory. The Microsoft Dynamics NAV Application Server is typically installed in the following folder:

      C:\Program Files\Microsoft Business Solutions-Navision\Application Server\

    3. Copy the files that you downloaded.

    4. Paste the files that you downloaded into the Microsoft Dynamics NAV Application Server installation directory.

    5. Click Yes to overwrite the files in the directory.

    6. Start the Microsoft Dynamics NAV Application Server.

  3. If you have the Microsoft Dynamics NAV ODBC driver installed, replace the following files in the Microsoft Dynamics NAV ODBC driver installation.

    File name

    File version

    File size

    Date

    Time

    Platform

    Cfront.dll

    4.0.3.24843

    873,936

    01-Jul-2007

    21:32

    x86

    Dbm.dll

    4.0.3.24843

    345,552

    01-Jul-2007

    21:32

    x86

    Nc_netb.dll

    4.0.3.24843

    79,312

    01-Jul-2007

    21:31

    x86

    Nc_tcp.dll

    4.0.3.24843

    83,408

    01-Jul-2007

    21:31

    x86

    Nc_tcps.dll

    4.0.3.24843

    91,600

    01-Jul-2007

    21:32

    x86

    Nodbc.dll

    4.0.3.24843

    1,227,728

    01-Jul-2007

    21:32

    x86

    Nodbccfg.cfg

    4.0.3.24843

    446,464

    01-Jul-2007

    11:25

    Not Applicable

    Nodbccfg.hlp

    Not Applicable

    12,940

    14-Dec-2006

    16:42

    Not Applicable

    Nodbccfg.xml

    Not Applicable

    2,360

    14-Dec-2006

    16:42

    Not Applicable

    Slave.exe

    4.0.3.24843

    95,696

    01-Jul-2007

    21:32

    x86

    To replace the existing files, follow these steps:

    1. Locate the Microsoft Dynamics NAV ODBC driver installation directory. The Microsoft Dynamics NAV ODBC driver is typically installed in the following folder:

      C:\Program Files\Common Files\Navision\NODBC\

    2. Copy the files that you downloaded.

    3. Paste the files that you downloaded into the Microsoft Dynamics NAV ODBC driver installation directory.

    4. Click Yes to overwrite the files in the directory.

Workaround

To work around this problem, disable the MaintainSIFTIndex property on the keys of the affected table. Then, enable the MaintainSIFTIndex property on those keys. The SIFT table will now be rebuilt by using the correct amounts.

Status

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

More Information

To delete empty SIFT records, use one of the following methods.

Method 1

  1. In the Microsoft SQL Server Option for Microsoft Dynamics NAV, point to Database on the File menu, and then click Information.

  2. Click Tables. Then, click Optimize.

Method 2

Use external SQL scripts.

References

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×