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][9D47D857-4AD9-4814-84DA-8E7603C7C2A9] Microsoft Dynamics NAV Item Data Collection Diagnostic

[SDP 2][9D47D857-4AD9-4814-84DA-8E7603C7C2A9] Microsoft Dynamics NAV Item Data Collection Diagnostic

View products that this article applies to.

Summary

This article describes the Microsoft Dynamics NAV Item Data Collection Diagnostic. The Microsoft Dynamics NAV Item Data Collection Diagnostic collects item data to be imported into a test environment for analysis. Setup, Item Ledger Entry, Value Ledger Entry, and other data is collected from Microsoft SQL Server and is used to troubleshoot issues related to Costing and Inventory.

↑ Back to the top

More Information

Information that is collected


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

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2396815
Revision : 1
Created on : 1/7/2017
Published on : 11/4/2011
Exists online : False
Views : 312