How to troubleshoot if the Inventory Trial Balance report and the Inventory Valuation report do not match in Microsoft Dynamics SL

Applies to: Dynamics SL 2011Microsoft Dynamics SL 2011 Service Pack 1Microsoft Dynamics SL 7.0 Service Pack 2

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

INTRODUCTION


This article describes how to verify whether the Inventory Trial Balance report and the Inventory Valuation report are out of balance in Microsoft Dynamics SL. Additionally, this article describes how to troubleshoot if the reports do not match.

More Information


Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

To verify whether the Inventory Trial Balance report total differs from the Inventory Valuation report total, follow these steps:
  1. Identify the earliest period and the most recent period for which you have activity in the Inventory module. To do this, follow these steps:
    1. To identify the earliest period, run the following statement against the application database in SQL Query Analyzer:
      select min(perpost) from intran where s4future05 = 0 and rlsed = 1
    2. To identify the most recent period, run the following statement against the application database in SQL Query Analyzer:
      select max(perpost) from intran where s4future05 = 0 and rlsed = 1
  2. Print the Inventory Trial Balance report for the full range of periods that you identified in step 1. To do this, follow these steps:
    1. On the Module menu, click Inventory.
    2. Click Reports, and then click Inventory Trial Balance to open the Inventory Trial Balance (10.630.00) dialog box.


    3. In the Beg Period box, type the period that you identified in step 1a. Type this information in the MM-CCYY format.

      Note In these steps, the placeholder MM-CCYY represents the month and year of the period. For example, if you run a calendar fiscal year, you would type 12-2005 for December 2005.
    4. In the End Period box, type the period that you identified in step 1b.
    5. Click the Select tab, and then specify the following settings:
      • Field: vr_10630.valmthd
      • Operator: Not equal
      • Value: U
    6. Click the Options tab, and then click to select the Exclude Drop Ship sales from Beg Balance check box.


    7. Click Print.
  3. Print the Inventory Trial Balance report for the range of periods that starts with the current period and ends with the period that you identified in step 1b. To do this, follow these steps:
    1. On the Module menu, click Inventory.
    2. Click Reports, and then click Inventory Trial Balance to open the Inventory Trial Balance (10.630.00) dialog box.


    3. In the Beg Period box, type the current period.
    4. In the End Period box, type the period that you identified in step 1b.
    5. Click the Select tab, and then specify the following settings:
      • Field: vr_10630.valmthd
      • Operator: Not equal
      • Value: U
    6. Click the Options tab, and then click to select the Exclude Drop Ship sales from Beg Balance check box.


    7. Click Print.
  4. Print the Inventory Valuation report by using the Include Zero Balance format. To do this, follow these steps:
    1. On the Module menu, click Inventory.
    2. Click Reports, and then click Inventory Valuation to open the Inventory Valuation (10.620.00) dialog box.


    3. In the Report Format box, click Include Zero Balance.
    4. Click Print.
  5. Print Inventory Valuation report by using the Exclude Zero Balance format. To do this, follow these steps:
    1. On the Module menu, click Inventory.
    2. Click Reports, and then click Inventory Valuation to open the Inventory Valuation (10.620.00) dialog box.


    3. In the Report Format box, click Exclude Zero Balance.
    4. Click Print.
  6. Compare the quantity totals and the cost totals in the reports that you printed in the earlier steps. If the totals do not match, print the Inventory Trial Balance / Valuation Variance report first by using the Cost Variance format and then by using the Qty Variance format. To print the report by using these formats, follow these steps:
    1. On the Module menu, click Inventory.
    2. Click Reports, and then click Inventory Trial Balance / Valuation Variance to open the Inventory Trial Bal / Valuation Variance (10.640.00) dialog box.


    3. In the Report Format box, select Cost Variance.
    4. Click Print.
    5. In the Report Format box, select Qty Variance.
    6. Click Print.
  7. Validate the inventory balances. To do this, follow these steps:
    1. Ask all users to log out of Microsoft Solomon.
    2. Maximize the Process Manager (40.400.00) dialog box, and then click Stop.
    3. On the Module menu, click Inventory.
    4. Click Screens, and then click IN Integrity Check to open the IN Integrity Check (10.990.00) dialog box.
    5. Click to select the following check boxes:
      • Validate Inventory
      • Process All Inventory
    6. Click Begin Processing.
  8. When the process finishes, click the System/Fatal Errors tab in the IN Integrity Check (10.990.00) dialog box. Correct any errors that you see. For more information about how to correct these errors, contact Technical Support.
  9. If the following conditions are true, rebuild the inventory balances:
    • You do not see any errors in the System/Fatal Errors tab in the IN Integrity Check (10.990.00) dialog box.
    • Your version of Microsoft Solomon is 5.5 with Service Pack 3 (SP3) or a later version.
    To rebuild the inventory balances, follow these steps:
    1. On the Module menu, click Inventory.
    2. Click Screens, and then click IN Integrity Check to open the IN Integrity Check (10.990.00) dialog box.
    3. Click to select the following check boxes:
      • Validate Inventory
      • Rebuild Inventory Item History
      • Rebuild Item Quantities and Costs
      • Process All Inventory
    4. Click Begin Processing.
If the results of the Inventory Trial Balance report and the Inventory Valuation report are still out of balance after you take these steps, contact Technical Support, and then provide the following information:
  • Electronic copies of the six reports that you printed in the earlier steps.
  • The event logs from the IN Integrity Check process.
Depending on the severity of the problems, Technical Support may request that you upload a copy of the application database and system database.