Microsoft KB Archive Search

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.

  1. Home
  2. [SDP 2][D5668A07-E205-4751-86A5-2C2B48541DCA] Microsoft Dynamics NAV Item Data/Costing Analysis Worksheet Diagnostic

[SDP 2][D5668A07-E205-4751-86A5-2C2B48541DCA] Microsoft Dynamics NAV Item Data/Costing Analysis Worksheet Diagnostic

View products that this article applies to.

Summary

This article describes the Microsoft Dynamics NAV Item Data/Costing Analysis Worksheet diagnostic. The Microsoft Dynamics NAV Item Data/Costing Analysis Worksheet diagnostic collects item data and creates Microsoft Excel worksheets that are formatted for analysis. Setup, Item Ledger Entry, Value Ledger Entry, and other data are collected from Microsoft SQL Server. This information is used to troubleshoot issues that are related to Costing and Inventory.

↑ Back to the top

More Information

This article describes the information that is collected when you run the Microsoft Dynamics NAV Item Data/Costing Analysis Worksheet Diagnostic.

Information that is collected

Item Cost and Setup (for Analysis)
Description
File Name
Excel Workbook that contain worksheets that are used for Costing analysis. The file also includes worksheets for item-specific data for the following tables:
Accounting Period (50)
Accounting Period GB (10560)
Avg Cost Adjmt Entry Point (5804)
Capacity Ledger Entry (5832)
Gen_ Business Posting Group (250)
Gen_ Product Posting Group (251)
General Posting Setup (252)
Inventory Period (5814)
Inventory Posting Group (94)
Inventory Posting Setup (5813)
Inventory Setup (313)
Item Application Entry (339)
Item Ledger Entry (32)
Item Tracking Code (6502)
Item Unit of Measure (5404)
Item Variant (5401)
Item (27)
Location (14)
Post Value Entry to G_L (5811)
Prod_ Order Line (5406)
Production Order (5405)
Unit of Measure (204)
Value Entry (5802)
VAT Posting Setup (325)
VAT Product Posting Group (324)


Analysis.xlsx


Item Cost and Setup (for Import)
Description
File Name
CSV-formatted files for item-specific data are collected from the following tables to be used for importing data for further analysis:

Accounting Period (50)

Accounting Period GB (10560)

Avg_ Cost Adjmt_ Entry Point (5804)

Capacity Ledger Entry (5832)

Gen_ Business Posting Group (250)

Gen_ Product Posting Group (251)

General Posting Setup (252)

Inventory Period (5814)

Inventory Posting Group (94)

Inventory Posting Setup (5813)

Inventory Setup (313)

Item Application Entry (339)

Item Ledger Entry (32)

Item Tracking Code (6502)

Item Unit of Measure (5404)

Item Variant (5401)

Item (27)

Location (14)

Post Value Entry to G_L (5811)

Prod_ Order Line (5406)

Production Order (5405)

Unit of Measure (204)

Value Entry (5802)

VAT Posting Setup (325)VAT Product Posting Group (324)


{TableName}_{TableID}.csv


Additional Information

The diagnostic can be run directly on the server that is running Microsoft SQL Server. Or, the diagnostic can be run from any computer that can connect to SQL Server when the computer has sufficient credentials to query the SQL Server Database.

↑ Back to the top

References

For more information about this topic, click the following article number to view the article in the Microsoft Knowledge Base:
926079 Frequently asked questions about the Microsoft Support Diagnostic Tool (MSDT)

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2384690
Revision : 1
Created on : 1/7/2017
Published on : 10/14/2011
Exists online : False
Views : 276