Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.


Symptoms

Customer is trying to change the Item Batch Number Key for a Stocked Item.This problem means that when we need to change an Item Batch Number, we need to manually Back Out all related Transactions for the underlying Batch Number Manually to get both the Inventory Position and GL Position to net out to ZERO. From there we need to use the new Batch Number and carry out the same tasks manually and to return to the Inventory and GL State with the NEW Item Batch Number. This is very time consuming. Furthermore if we use the Rename functionality, since all data is not updated, the Data integrity of the system is compromised leaving missing references in Dynamics

↑ Back to the top


Resolution

The hotfix Skips temp tables for SSRS: SalesInvoiceTmp, SalesInvoiceLocalizationTmp, ProdPickListTmp.
ignores Item Id fields which are not linked with InventDimId. Handle some tables specially: PdsComdPricingRunLine, BOMVersion, InventBaileeCalcTrans_RU,InventByProductTable_RU

↑ Back to the top


More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in 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.

↑ Back to the top


Article Info
Article ID : 4033128
Revision : 1
Created on : 6/21/2017
Published on : 6/21/2017
Exists online : False
Views : 326