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. The amount in the "Shipped" box in the "Balance" area on the Customer Information tab on the Customer Maintenance (08.260.00) screen is incorrect in Microsoft Dynamics SL

The amount in the "Shipped" box in the "Balance" area on the Customer Information tab on the Customer Maintenance (08.260.00) screen is incorrect in Microsoft Dynamics SL

View products that this article applies to.

Symptoms

The amount in the Shipped box in the Balance area on the Customer Information tab on the Customer Maintenance (08.260.00) screen is incorrect in Microsoft Dynamics SL. This problem occurs when the customer consolidates invoices but does not accrue revenue.

↑ Back to the top

Cause

The value is updated incorrectly by the Process Manager (40.400.00) screen when the screen updates a shipper for the same customer to a closed status in Order Management.

↑ Back to the top

Workaround

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 work around this problem, follow these steps:
  1. Verify that the customer does not accrue revenue. Run the following statement against the Microsoft Dynamics SL application database by using SQL Server Management Studio. If the statement returns anything other than NULL, the customer has accrued revenue or does accrue revenue, and you should not use this workaround. 
    select distinct AccrShipRegisterID from soshipheader
    The following file is available for download from the Microsoft Dynamics File Exchange Server:

    KB968810_ADG_AR_SetTotOpenOrd.sql
    Release Date: October 15, 2010

    Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
  2. Download the following file, and then run it against the Microsoft Dynamics SL application database by using SQL Server Management Studio.
  3. Run the AR Integrity Check to recalculate the shipped total. To do this, follow these steps:
    1. In the navigation pane, click Financial.
    2. In the Financial navigation pane, click Accounts Receivable.
    3. In the Accounts Receivable pane, click AR Integrity Check under Processes.
    4. Click to select the following check boxes:
      • Verify Customer Balances
      • Correct Customer Balances to Total Doc Balances
    5. Click Begin Processing.

↑ Back to the top

Keywords: kbbug, kbsurveynew, kbtshoot, kbprb, kbmbspartner, kbexpertisebeginner, kbmbsmigrate, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 968810
Revision : 2
Created on : 2/2/2017
Published on : 2/3/2017
Exists online : False
Views : 410