SAP Knowledge Base Article - Public

3516764 - Over-the-Counter Sales Inconsistent With the Error: Item XX: Insufficient Stock for the Product

Symptom

When creating an Over-the-Counter Sales document the status is Inconsistent with the following error: Item XX: Insufficient Stock for the Product (XX represents the Line Item number).

The Invoice button is disabled and the Over-the-Counter Sales document cannot be invoiced.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Over-the-Counter Sales work center.
  2. Select the Over-the-Counter Sales view.
  3. Select the Over-the-Counter Sale ABC (ABC represents the Document ID).
  4. The Status is Inconsistent.
  5. Click on the Check button or open the Over-the-Counter Sale ABC.
  6. The following error occurs:
    Item XX: Insufficient Stock for the Product

Cause

With Release 2411 we introduced a check on the available quantity for Products and the field Available Stocks on Item level of the Over-the-Counter Sales.

You can activate this check in the Business Configuration as follows:  

  1. Go to the Business Configuration work center.
  2. Select the Implementation view. 
  3. Select your implementation project and click on Edit Project Scope.
  4. Navigate to the Questions tab and expand the path: 
  5. Sales -> Customer Invoicing -> Over-the-Counter Sales

You can activate the Question: Do you want to activate the stock availability check for Over the Counter Sales?

The check will validate if the quantity of the Item in the Over-the-Counter Sales document is greater than the Available Stock for the Item.

The field Available Stocks displays the quantity of the available stock for the respective product. (if the field is not visible in the Items tab of the Over-the-Counter Sales you can make it visible via Personalization or Adaptation).

If one or all items do not have sufficient stock the respective line item will be inconsistent, and the Invoice button will be disabled.

If the Available Stocks field displays no value, then there is no stock available for the Product.

Please Note that Negative Stock and Identified Stock is currently not supported for the stock availability check for Over the Counter Sales.

 

Scenario 1:
You create an Over-the-Counter Sales document for a Products with a quantity that exceeds the available stock in the Ship-From Location.
The system displays the available stock for the Product in the Ship-From Location and checks if the quantity maintained for the Product exceeds the quantity available. 

  1. Go to the Over-the-Counter Sales work center.
  2. Select the Over-the-Counter Sales view.
  3. Select New -> Over-the-Counter Sale.
  4. In the General tab enter the respective data.
  5. Navigate to the Items tab.
  6. Click on Add Row and enter Product EFG (EFG represents the Product ID).
  7. In the field Available Stocks the quantity of the Available Stock in the Ship-From Location is displayed as e.g. 10 ea
  8. Enter the Quantity 11 ea for the Product.
  9. The Status of the Item and the Over-the-Counter Sales changes to Inconsistent, the Invoice button is disabled, and the following error occurs: 
    Item 10: Insufficient Stock for the Product

Scenario 2:
You create an Over-the-Counter Sales document with multiple line items and the same Product with an accumulated quantity that exceeds the available stock in the Ship-From Location.
The system displays the available stock for the Product in the Ship-From Location for each line item and checks if the accumulated quantity maintained for the Product in the different line items exceeds the quantity available. 

  1. Go to the Over-the-Counter Sales work center.
  2. Select the Over-the-Counter Sales view.
  3. Select New -> Over-the-Counter Sale.
  4. In the General tab enter the respective data.
  5. Navigate to the Items tab.
  6. Click on Add Row and enter Product EFG (EFG represents the Product ID).
  7. In the field Available Stocks the quantity of the Available Stock in the Ship-From Location is displayed as e.g. 10 ea
  8. Enter the Quantity 5 ea for the Product in line item 10.
  9. The Status of the Item 10 is To Be Invoiced.
  10. Click on Add Row and enter Product EFG (EFG represents the Product ID).
  11. In the field Available Stocks the quantity of the Available Stock in the Ship-From Location is displayed as e.g. 10 ea
  12. Enter the Quantity 6 ea for the Product in line item 20.
    The Status of the line Item 20 changes to Inconsistent, the Invoice button is disabled because line item 10 has the quantity 5 ea and line item 20 has the quantity 6 ea.
    Since the additional quantity of line item 20 exceeds the total available stock, the following error occurs: Item 20: Insufficient Stock for the Product
    The status of the Over-the-Counter Sales document is Partially Inconsistent.

Scenario 3:
You create an Over-the-Counter Sales document with multiple line items and different Products. One Product does not exceed the available stock and one Product exceeds the available stock in the Ship-From Location.
The system displays the available stock for the Product in the Ship-From Location for each line item and checks if the quantity maintained for each Product in the different line items exceeds the quantity available.

  1. Go to the Over-the-Counter Sales work center.
  2. Select the Over-the-Counter Sales view.
  3. Select New -> Over-the-Counter Sale.
  4. In the General tab enter the respective data.
  5. Navigate to the Items tab.
  6. Click on Add Row and enter Product EFG (EFG represents the Product ID).
  7. In the field Available Stocks the quantity of the Available Stock in the Ship-From Location is displayed as e.g. 10 ea
  8. Enter the Quantity 5 ea for the Product in line item 10.
  9. The Status of the line Item 10 is To Be Invoiced.
  10. Click on Add Row and enter Product HIJ (HIJ represents the Product ID).
  11. In the field Available Stocks the quantity of the Available Stock in the Ship-From Location is displayed as e.g. 2 ea
  12. Enter the Quantity 5 ea for the Product in line item 20.
    The Status of the line Item 20 changes to Inconsistent, the Invoice button is disabled because line item 20 has the quantity 5 ea which exceeds the quantity of the available stock.
    The following error occurs: Item 20: Insufficient Stock for the Product
    The status of the Over-the-Counter Sales document is Partially Inconsistent.

Scenario 4:
You create an Over-the-Counter Sales document with a Sales Kit that has 2 Sales Kit - Sub Items. One Sales Kit - Sub Item does not exceed the available stock and one Sales Kit - Sub Item exceeds the available stock in the Ship-From Location.
The system displays the available stock for the Product in the Ship-From Location for each line item and checks if the quantity maintained for each Product in the different line items exceeds the quantity available.

  1. Go to the Over-the-Counter Sales work center.
  2. Select the Over-the-Counter Sales view.
  3. Select New -> Over-the-Counter Sale.
  4. In the General tab enter the respective data.
  5. Navigate to the Items tab.
  6. Click on Add Row and enter Sales Kit KIT (KIT represents the Product ID of the Sales Kit – Header Item).
  7. The system automatically expands the Sales Kit header and Items and the Sales Kit - Sub Item LMN is added as line item 20 and the Sales Kit - Sub Item OPQ is added as line item 30 (LMN and OPQ represent the Product ID of the Sales Kit - Sub Items).
  8. For the Sales Kit – Header Item KIT in line item 10 no value in the Available Stocks is displayed since this is a Sales Kit – Header Item. The Status of the line item 10 is To Be Invoiced.
  9. For the Sales Kit - Sub Item LMN in line item 20, in the field Available Stocks the quantity of the Available Stock for the Product in the Ship-From Location is displayed is e.g. 10 ea. The quantity determined for the Sales Kit - Sub Item is 1 ea. Since the quantity does not exceed the available stock the status of the item is To Be Invoiced.
  10. For the Sales Kit - Sub Item OPQ in line item 30, in line item 20, in the field Available Stocks the quantity of the Available Stock for the Product in the Ship-From Location is displayed is e.g. 2 ea. The quantity determined for the Sales Kit - Sub Item is 4 ea. Since the quantity exceed the available stock the status of the item is Inconsistent and the following error occurs: Item 30: Insufficient Stock for the Product
    The status of the Over-the-Counter Sales document is Partially Inconsistent.

Scenario 5:
If the Over-the-Counter Sales document is created via the web service ManageOvertheCounterSaleRequestIn and one or multiple line items do not have sufficient stock the Over-the-Counter Sales document will be created in status Inconsistent or Partially Inconsistent.

The following information message will be passed in the Response Payload (XXX represents the BaseBusinessTransactionDocumentID passed in the Request Payload):

<Log>

<MaximumLogItemSeverityCode>1</MaximumLogItemSeverityCode>

<Item>

<TypeID>036(/A1SCI_CINV_ECO_MSG/)</TypeID>

<SeverityCode>1</SeverityCode>

<Note>Invoice Request XXX is inconsistent.</Note>

</Item>

</Log>

Resolution

To solve the issue you need to ensure that there is enough stock available for the Product or you need to remove the line Item from the Over-the-Counter Sales document.

Once enough stock if available you can perform the following steps:

  1. Go to the Over-the-Counter Sales work center.
  2. Select the Over-the-Counter Sales view.
  3. Click on the Check button.
  4. Click on the Redetermine All button.
  5. The error message is not displayed anymore.
  6. Click on the Save and Close button.
    The Over-the-Counter Sales document is consistent and in Status To Be Invoiced. The Invoice button is enabled again.

Keywords

OTC; Over the counter; Over-the-Counter; Invoice; Button; Read Only; Inconsistent; Partially Inconsistent; Invoice Request; ManageOvertheCounterSaleRequestIn; web service; Available Stock; Stock; Available Stocks; Insufficient; Insufficient Stock;  , KBA , AP-CI-CI , Customer Invoice , Problem

Product

SAP Business ByDesign all versions