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).

KB	Internal reference ID	Title
No KB Article	PS 57602	Cost Amount (Expected) (ACY) is wrongly reversed by Undo Shipment.
No KB Article	PS 57299	Apply-to on sales order line where inbound ILE remaining qty < outbound ILE
2405102	217035	Inventory value zero with invoice discount applied updates unit cost and last direct cost fields on the item card
2845156	323184	Cost Amount (Expected) is incorrect on partially invoiced Sales entry when source of cost has been assigned several item charges
2792002	341004	Posting 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	339266	Application worksheet - partial fixed applications made for average cost item.
2813781	343200	Incorrect valuation dates modified when Average item has multiple output against same prod. Order
No KB Article	353055	Decrease performance Adjust Cost Item Entries batch job after hotfix 343200\|346673
2874959	346855	HF 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	241424	Running CU5895 through the NAS is not allowed since DIALOG window is run
2874961	343656	Follow up VSTF 267677 (part of Costing Rollup) Adjust Cost Overflow error, Average by Item and transfers not handled as exception
2880682	344033	Produced Item with Standard cost demonstrate Cost Amonut (Actual) deviation of +/- 0,01..0,02 to defined Standard cost
No KB Article	352069	Inventory Valuation Report zero quantity but a value.
No KB Article	352593	Slow Adjust Cost Performance with Average Cost and many SKUs, Stockkeeping Units
No KB Article	352536	Inventory Valuation Report zero quantity but a value.
No KB Article	357121	After implementation of changes made TFS 349084 the Performance of the Adjust Cost – Item Entries is 5 times slower.
2829782	349805	R1001 does not provide expected cost for the item (NAV 2013 was corrected with TFS 344286)
2980142	354346	R1001 does not provide “Expected cost Included” line for specific item
No KB Article	343727	RTC: 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	282849	Report 5802 - Inventory Valuation WIP report carries a mix of expected and invoiced costs.
2689150	306899	Inventory Valuation - WIP Report 5802 shows incorrect Output on the RTC after multiple Output entries per Production Order have been revalued
2786792	311376	Inventory Valuation - WIP Report 5802 Classic/RTC - Revaluation causes incorrect numbers on report.
2711751	318341	Inventory Valuation - WIP Report 5802 has wrong 'Cost Posted to G/L' amount ONLY on RTC after Revaluing Output
2786792	319826	Rep 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	323610	Report 5802 RTC - Total amount in Cost Posted to G/L is different in RTC report compared to Classic
2786792	327534	Report 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	326574	Rep 5802 - Inventory Valuation - WIP, Revaluation of Output, Expected cost brings incorrect Opening balance in report
2786792	330586	Report 5802 - Expected cost of Output is revalued in period 2, while Output is later invoiced in period 1
2786792	336592	Report 5802 RTC - Cost Posted to G/L column incorrect
2786792	336376	Report 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	340491	Report 5802 - Cost Posted to G/L incorrect after implementing VSTF 336376
2786792	341917	Report 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	354375	Report 5802 - Inventory Valuation WIP report "As-of" beginning balance does not match the ending balance "As-of" from prior period. Output is excluded
2796454	340461	Report 5848 - Cost Shares Breakdown - Shows incorrectly when Sales Return/Credit Memo is posted.
2815558	343766	Cost Shares Breakdown Report (R 5848) shows incorrect value when Partial Revaluation has been completed
2406355	208111	Create 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 Article	353129	Standard 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 Article	207929	Report 5899 performance problems (Key suggestion)
No KB Article	349084	With 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 Article	355655	Code optimisation due to function IsAvgCostException in table 5802
2980151	355737	Average 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:

https://mbs.microsoft.com/support/newstart.aspx 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:

Partners

https://mbs.microsoft.com/partnersource/global/support/support-news/support_telephoneCustomers

https://mbs.microsoft.com/customersource/Global/NAV/support/support-news/global_support_contacts_engIn 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 name	File version	File size	Date	Time	Platform
Costing rollup 2 for microsoft dynamics nav 2009 r2.exe	Not Applicable	1,492,480	29-Oct-2014	17:40	x86

How to install the hotfix rollup

Follow these steps to install this rollup update:

Open the Object Designer.
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.
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.
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.
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.