Error message when you print the SOP Posting Journal report or the Sales Edit List report in Microsoft Dynamics GP: “One or more line items contain warnings or errors”


Symptoms


When you print the SOP Posting Journal report or the Sales Edit List report in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you receive the following error message:

One or more line items contain warnings or errors.
This problem occurs even if the following conditions are true:
  • Valid posting accounts exist in the Sales Line Distribution Entry window for the cost of goods sold account and for the inventory account.
  • The Reconcile Sales Documents procedure has been performed.
  • The Inventory Reconcile Quantities procedure has been performed.
  • The Check Links procedure has been performed.
  • You have transferred the transactions in the batch to a new batch.
  • You have performed the steps in the following Microsoft Knowledge Base articles:
    865877 Error message when you try to post invoices for noninventory items in Microsoft Dynamics GP: "One or more line items contain warnings or errors"

    850972 Error message when you try to post a document in Sales Order Processing in Microsoft Dynamics GP: "One or more line items contain warnings or errors. Line accounts are missing or invalid"

Cause


This problem occurs when invalid values exist in one or more fields in the SOP10200 table.

Resolution


To resolve this problem, follow these steps.

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.
  1. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

    Method 1: For SQL Server Desktop Engine

    If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

    Method 2: For SQL Server 2000

    If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    Method 3: For SQL Server 2005

    If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
  2. Run the appropriate statement against the company database. For one transaction, run the following statement:
    SELECT SOPLNERR, * FROM SOP10200 where SOPNUMBE = ‘<xxx>’
    For a range of transactions, run the following statement:
    SELECT SOPLNERR, * FROM SOP10200 where SOPNUMBE BETWEEN ‘<xxx>’ and ‘<xxx>’

    Note In each statement, replace the <xxx> placeholder with a document number.
  3. Note the value in the SOPLNERR field, and then compare it to the following values.

    ValueDescription
    1The master record for the item does not exist.
    2The site record for the item does not exist.
    3The serial numbers and the extended quantity of the item do not balance.
    4The lot quantities and the extended quantity of an item do not balance.
    5The serial number already exists for this item in the serial number file.
    6The serial number is missing for the item and for the site in the serial number file.
    7The lot number is missing for this item and for this site in the lot number file.
    8The line accounts are missing or invalid.
    9The returned quantities were not distributed correctly.
    10The lot number already exists for the item in the lot number file.
    11The intrastate information is missing or invalid.
    12The line quantity is zero.
    13A severe error occurred while the program was adjusting the inventory. Revert to a backup if you can do this.
    14The line quantity is not completely distributed.
    15A part of the line quantity is backordered.
    16The line quantity is not correctly allocated.
    17The line quantity is not correctly fulfilled.
  4. Determine whether the errors are valid. Make corrections as appropriate. For example, if the value in the SOPLNERR field is 2, follow these steps:

    1. On the Cards menu, point to Inventory, and then click Quantities/Sites.
    2. In the Item Number list, click an item.
    3. In the Site Lookup area, click All.
    4. In the Sites area, click Site ID.
    5. In the Sites list, click a site.
    6. Click Save.