Costing update rollup 2 for Microsoft Dynamics NAV 2009

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

Symptoms

This costing rollup includes an update fixing 44 costing issues related to Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2.

Costing Rollup Update for Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2 available in Microsoft Knowledge Base article (KB2781950 )is a prerequisite for this release.

The following objects are included in provided fob and txt files addressing W1 version:
  • Table 36,38, 83, 339, 5802, 5820
  • Report 1001, 1002, 5802, 5848, 5855, 5899, 99001025
  • Codeunit 22, 5802, 5816, 5847, 5895, 6620, 7320
The following changelog files are included:
  • R2_Changelog.txt — changelog file describing modifications of both first costing rollup (KB2781950 ) and this second costing rollup in the application compared to the Dynamics NAV 2009 R2 version. Preferably used by those running RTM version and want to take part of both costing rollups on one go.
  • R2_IC1_Changelog.txt — changelog file describing modifications of this second rollup in the application compared to the Dynamics NAV 2009 R2 with first costing hotfix rollup (KB2781950 ) already applied.

Resolution

Problems that are resolved in this hotfix rollup

The list below refers to published Knowledge Base articles (KB) and internal references. (Can be used when contacting support).
KBInternal reference IDTitle
No KB ArticlePS 57602Cost Amount (Expected) (ACY) is wrongly reversed by Undo Shipment.
No KB ArticlePS 57299Apply-to on sales order line where inbound ILE remaining qty < outbound ILE
2405102 217035Inventory value zero with invoice discount applied updates unit cost and last direct cost fields on the item card
2845156 323184Cost Amount (Expected) is incorrect on partially invoiced Sales entry when source of cost has been assigned several item charges
2792002 341004Posting a Purchase Invoice for Item Charge of S-FREIGHT and applying the Freight to a Sales Shipment results in "Cost Amount (Non-Invtbl.)" updating but not related "Cost Amount (Non-Invtbl.)(ACY)
2879153 339266Application worksheet - partial fixed applications made for average cost item.
2813781 343200Incorrect valuation dates modified when Average item has multiple output against same prod. Order
No KB Article353055Decrease performance Adjust Cost Item Entries batch job after hotfix 343200|346673
2874959 346855HF from 245349 (part of Costing Rollup) causes R1002 to clear T5811 and show entries on report but value entries not reconciled with G/L.
2763255 241424Running CU5895 through the NAS is not allowed since DIALOG window is run
2874961 343656Follow up VSTF 267677 (part of Costing Rollup) Adjust Cost Overflow error, Average by Item and transfers not handled as exception
2880682 344033Produced Item with Standard cost demonstrate Cost Amonut (Actual) deviation of +/- 0,01..0,02 to defined Standard cost
No KB Article352069Inventory Valuation Report zero quantity but a value.
No KB Article352593Slow Adjust Cost Performance with Average Cost and many SKUs, Stockkeeping Units
No KB Article352536Inventory Valuation Report zero quantity but a value.
No KB Article357121After implementation of changes made TFS 349084 the Performance of the Adjust Cost – Item Entries is 5 times slower.
2829782 349805R1001 does not provide expected cost for the item (NAV 2013 was corrected with TFS 344286)
2980142 354346R1001 does not provide “Expected cost Included” line for specific item
No KB Article343727RTC: Sum Information “Inventory Cost Posted to G/L” is missing in Report 1002 in the RTC Option (Classic behaves as expected)
2523479 252682'Output' and 'As of Date' columns on the Inventory Valuation - WIP Report (R5802) are not correct after posting only Output for a Production Order
2786792 282849Report 5802 - Inventory Valuation WIP report carries a mix of expected and invoiced costs.
2689150 306899Inventory Valuation - WIP Report 5802 shows incorrect Output on the RTC after multiple Output entries per Production Order have been revalued
2786792 311376Inventory Valuation - WIP Report 5802 Classic/RTC - Revaluation causes incorrect numbers on report.
2711751 318341Inventory Valuation - WIP Report 5802 has wrong 'Cost Posted to G/L' amount ONLY on RTC after Revaluing Output
2786792 319826Rep 5802 Classic + RTC: consumption has been reversed. Inbound consumption is thereafter revalued. Makes the Prod.order to show values in period after Revaluation on Report
2786792 323610Report 5802 RTC - Total amount in Cost Posted to G/L is different in RTC report compared to Classic
2786792 327534Report 5802 lists all Finished Prod.order even though they don't have postings/values within the selected Starting and Ending date, by time it will be a loooong list.
2786792 326574Rep 5802 - Inventory Valuation - WIP, Revaluation of Output, Expected cost brings incorrect Opening balance in report
2786792 330586Report 5802 - Expected cost of Output is revalued in period 2, while Output is later invoiced in period 1
2786792 336592Report 5802 RTC - Cost Posted to G/L column incorrect
2786792 336376Report 5802, Prod.order is missing on report (or is inaccurate) in period 2, when Output is made to Expected cost in period 1 and Output invoiced in period 3
2786792 340491Report 5802 - Cost Posted to G/L incorrect after implementing VSTF 336376
2786792 341917Report 5802, Opening Balance incorrect in Period 3, when partial Output is made to Expected cost in period 1 and Period 3. Output invoiced in period 4
2908944 354375Report 5802 - Inventory Valuation WIP report "As-of" beginning balance does not match the ending balance "As-of" from prior period. Output is excluded
2796454 340461Report 5848 - Cost Shares Breakdown - Shows incorrectly when Sales Return/Credit Memo is posted.
2815558 343766Cost Shares Breakdown Report (R 5848) shows incorrect value when Partial Revaluation has been completed
2406355 208111Create batch name on the fly on the Implement Standard Cost Changes report triggers error message that it does not exist on 2009 SP1
No KB Article353129Standard Cost Worksheet has issues with the Implement Standard Cost Changes Action in that the process can be run more than once and result in duplicated Revaluation Journal lines and duplicate Value Entries for revaluation if posted
No KB Article207929Report 5899 performance problems (Key suggestion)
No KB Article349084With the Costing Rollup Update implemented in a 2009.R2.RTM, Item Charges not registered correctly when Average by Item (Average Cost Calc. Type = Item) is used and are Transfers made between Locations
No KB Article355655Code optimisation due to function IsAvgCostException in table 5802
2980151 355737Average cost item is wrongly cost adjusted causing inventory value <> 0 when stock=0
2901572 351452"You cannot revalue individual item ledger entries for items that use average costing method" error message when you select a purchase item ledger entry to revalue in the Applies-to Entry field in the revaluation journal for an average cost item

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website: You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

PartnersCustomersIn 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, 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. Then, you must provide the password provided in the e-mail.


If you click Cancel, the download process stops.

File information

The global version of this hotfix rollup has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
File nameFile versionFile sizeDateTimePlatform
Costing rollup 2 for microsoft dynamics nav 2009 r2.exeNot Applicable1,492,48029-Oct-201417:40x86

How to install the hotfix rollup

Follow these steps to install this rollup update:
  1. Open the Object Designer.
  2. Make a backup of the involved objects in your database in case something goes wrong. You do not need the backup as such for the update:
    1. Select the objects (or you can do that for each object separately).
    2. Click File, and then click Export.
    3. Enter a file name.
    4. Click Save.
  3. Export language (if you use more than one language, you must repeat the following steps for each one):
    1. Select the objects (or export the language(s) for each object separately).
    2. Click Tools, click Language Module, and then click Export.
    3. Enter a file name.
    4. Choose a language (the update contains ENU, so it is not necessary to export ENU).
    5. Click Ok.
  4. Import the costing rollup update:
    1. If your customer uses functionality that was added in the localization process or by you to the involved objects, you must add this functionality now.
    2. Compile the imported objects.
  5. Import language (if you use more than one language, you must repeat the following steps for each one):
    1. Select the objects (or import the language(s) for each object separately).
    2. Click Tools, click Language Module, and then click Import.
    3. Choose the language file you created in step 3.
    4. Click Yes to confirm.

Field Outbound Entry is Updated in table 339 "Item Application Entry"

New field was added to the table 339 "Item Application Entry":
Field 5805 "Outbound Entry is Updated"
This field is used internally by the Adjust Cost – Item Entries batch job and specifies that the cost of the related outbound item entry is already updated. If the field is selected, then the cost adjustment routine will not try to update any previous related outbound entries. This improves system performance during cost adjustment of item entries with long application histories.

Prerequisites

You must have one of the following products installed to apply this hotfix rollup:
  • Microsoft Dynamics NAV 2009 R2
  • Microsoft Dynamics NAV 2009 Service Pack 1

Restart requirement

If you are prompted to restart the computer, restart the computer after you install the hotfix rollup.

Status

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

More Information

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

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Egenskaper

Artikel-id: 3011240 – senaste granskning 30 jan. 2017 – revision: 2

Feedback