SAP Knowledge Base Article - Public

2096678 - Warning Message: Selected Records are Too High. Please Select Less than 1000 Records.

Symptom

When trying to create a Supplier Invoice with more than 1000 goods and services receipts, it is triggered an warning message.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Supplier Invoice work center.
  2. Go to Invoice Entry view.
  3. In the dropdown, choose "Show All Deliveries to Be Invoiced".
  4. Open the Advanced Filter and choose the parameters.
  5. Click in Go button.
  6. Select all the related Goods and Service Receipts, in a total of more than 1000 records.

It is triggered the warning message: "Selected records are too high. Please select less than 1000 records."

Cause

Due to the technical limitation, it is not possible to select more than 1000 records.

The system is working as expected.

Resolution

As a workaround, the user can select a Purchase Order with more than 1000 Goods and Services Receipts. The user can also select different Purchase Orders for the same Invoice if the Suppliers and Buyer Company are the same. Please follow the steps below:

  1. Go to Supplier Invoicing work center.
  2. Go to Invoice Entry view.
  3. In the dropdown, select All Orders to Be Invoiced.
  4. Select one or multiple Purchase Orders.
  5. Click in the New Invoice button. 

All Goods and Service Receipt ID are selected as Items in a new Supplier Invoice screen.

Note: If it is created an Invoice for more than 100 delivery items, the system triggers a deplayed verification after the document is posted. It means that the system assigns the delivery items to the invoice items in the background. During invoice entry, the system only references the preceding Purchase Orders and therefore accelerates the processing. If it is reduced the number of delivery items to 100 or less using the Advanced search, the system directly assigns the delivery items to the invoice items during invoice entry as usual (standard verification).

Second note: Creating purchase orders with more than 200 goods and services receipts is not recommended. The workaround can be followed, however refrain that the system may not perform reliably. This is explained in the KBA "2956449 - Limitation on Number of Items in ByDesign Documents".

See Also

Keywords

1000 records, Supplier Invoice, Goods and Services Receipt, Delayed Verification , KBA , SRD-SRM-SI , Supplier Invoicing , How To

Product

SAP Business ByDesign all versions