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

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.

Applies to:   Microsoft Dynamics SL 2011, Microsoft Dynamics SL 2011 Service Pack 1
Original KB number:   848418

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, select Inventory.

    2. Select Reports, and then select 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. Select the Select tab, and then specify the following settings:

      • Field: vr_10630.valmthd
      • Operator: Not equal
      • Value: U
    6. Select the Options tab, and then select the Exclude Drop Ship sales from Beg Balance check box.

    7. Select 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, select Inventory.
    2. Select Reports, and then select 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. Select the Select tab, and then specify the following settings:
      • Field: vr_10630.valmthd
      • Operator: Not equal
      • Value: U
    6. Select the Options tab, and then select the Exclude Drop Ship sales from Beg Balance check box.
    7. Select 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, select Inventory.
    2. Select Reports, and then select Inventory Valuation to open the Inventory Valuation (10.620.00) dialog box.
    3. In the Report Format box, select Include Zero Balance.
    4. Select Print.
  5. Print Inventory Valuation report by using the Exclude Zero Balance format. To do this, follow these steps:

    1. On the Module menu, select Inventory.
    2. Select Reports, and then select Inventory Valuation to open the Inventory Valuation (10.620.00) dialog box.
    3. In the Report Format box, select Exclude Zero Balance.
    4. Select 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, select Inventory.
    2. Select Reports, and then select 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. Select Print.
    5. In the Report Format box, select Qty Variance.
    6. Select 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 select Stop.
    3. On the Module menu, select Inventory.
    4. Select Screens, and then select IN Integrity Check to open the IN Integrity Check (10.990.00) dialog box.
    5. Select the following check boxes:
      • Validate Inventory
      • Process All Inventory
    6. Select Begin Processing.
  8. When the process finishes, select 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, select Inventory.
    2. Select Screens, and then select IN Integrity Check to open the IN Integrity Check (10.990.00) dialog box.
    3. Select the following check boxes:
      • Validate Inventory
      • Rebuild Inventory Item History
      • Rebuild Item Quantities and Costs
      • Process All Inventory
    4. Select 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.