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:

  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.

Need more help?

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

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×