2651521 - Sorting of Line Items in Customer Invoices From Multiple Invoice Requests

SAP Knowledge Base Article - Public

2651521 - Sorting of Line Items in Customer Invoices From Multiple Invoice Requests

Symptom

When invoicing multiple invoice requests, there is no option to change the sorting of line items.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the Customer Invoicing workcenter.
  2. Select the Invoice Request view.
  3. Select multiple Invoice Requests that you would like to Invoice together.
  4. Create a Customer Invoice.

The line items from the invoice are not sorted as you would expect.

Cause

Business ByDesign uses four conditions for sorting line items:

  • Comparison for Invoice and Credit Memo Item if scoped:
    1. Invoice Line item.
    2. Credit Memo Line Item.
  • Ascending order for the Invoice Request ID.
  • Invoice Request Type in this order:
    1. Sales Order Invoice Request
    2. Service Order Invoice Request
    3. Service Confirmation Invoice Request
    4. Outbound Delivery Invoice Request
    5. Customer Project Invoice Request
    6. Customer Contract Invoice Request
    7. Manual Invoice Request
    8. Manual Credit Memo Request
    9. Down Payment Invoice Request
    10. Correction Invoice Request
    11. Scheduled Invoice Request
    12. External Customer Invoice Request
    13. Rebate Credit Memo Request
  • Line Item on Invoice Request in ascending order.

Resolution

If you invoice a Sales Order invoice Request with ID 1000 and a Service Order Invoice Request with ID 1000, you will receive the following application of logic:

  1. There are only Invoice Items.
  2. There is a comparison of ID - in this case both have the ID 1000.
  3. Sales Order Invoice Requests are chosen before Service Order Invoice Requests.
  4. In this case the line items from the Sales Order are listed before the items from the Service Order in the invoice.

This is the expected system behaviour.

A manual adjustment of the sorting is currently not available.

Keywords

Sorting, Line Items, Invoice, Invoice Request, Sortieren, Rechnung, Rechnungsanforderung, Positionen , KBA , AP-CI-CI , Customer Invoice , How To

Product

SAP BUSINESS BYDESIGN 1808 ; SAP Business ByDesign 1805