SAP B1 Troubleshooting – Item cost not found for one or more items. ITEM 1

Step-by-Step Fix for Missing Item Costs in SAP Business One

Error Description:

One common issue that SAP Business One users may encounter is the error message: “Item cost not found for one or more items. ITEM No#.” This error typically occurs during transactions that involve stock release, such as delivery creation, where inventory is affected.

Symptom:

When creating a delivery for an item in SAP B1, you may see the following error message:

“Item cost not found for one or more items. ITEM 1”

This occurs when there is an issue with the cost assignment for the item in question.

Solution:

The error arises because the item (e.g., Item 1) has been purchased with a zero cost or inwarded with no price. To resolve this, you need to define a cost for the item in the Inventory Revaluation or adjust settings to allow stock release with zero cost. Here’s how to fix it:

Option 1: Assign Cost to the Item via Inventory Revaluation

• Navigate to Modules > Inventory > Inventory Transactions > Inventory Revaluation.

• Select the item and input the appropriate cost for it. This cost will be posted to the expense account. After entering the cost, click Add to save the document.

Option 2: Enable Zero-Cost Stock Release

If the item is intended to have zero cost (e.g., for promotional or sale purposes), you can adjust the system settings to allow delivery transactions with zero cost.

• Go to Modules > Administration > System Initialization > Company Details. ![Company Details Screen]

• Under the Basic Initialization tab, locate the setting for Allow stock release with item cost. ![Allow Stock Release Setting]

• Enable this setting, which will allow you to complete delivery transactions even if the item has a zero cost.

After performing either of the above solutions, try adding the delivery document again. The transaction should now post successfully.

By following these steps, you can quickly resolve the “Item cost not found” error and proceed with your SAP B1 transactions seamlessly.

Item Cost Not Found – FAQs

What does the error “Item cost not found for one or more items” mean in SAP Business One?

This error typically occurs when SAP B1 cannot determine the cost for one or more items during a transaction. It often happens due to missing cost data for items in inventory or configuration issues with the costing method.

What are the common scenarios that trigger this error?

• Items are set to “Moving Average” or “Standard Cost,” but the cost value is missing.
• There are stock movements (e.g., goods receipt or delivery) without an associated cost.
• Items are non-inventory items but are incorrectly included in transactions requiring cost calculation.
• Issues with the valuation method assigned to the item in the Item Master Data.

How can I identify which items are causing the issue?

When the error message appears, note the item codes mentioned (e.g., “ITEM 1”). Use the Inventory Audit Report or Item Master Data in SAP B1 to check the item’s costing method and inventory value.

What steps can I take to fix the missing cost issue?

• Check the Item Master Data for the affected items and ensure the valuation method (e.g., Moving Average, FIFO, or Standard) is properly configured.
• Update the missing cost values using a Goods Issue/Receipt Adjustment if applicable.
• Ensure transactions such as Goods Receipts or Inventory Transfers have accurate cost values.
• If using Standard Cost, update the cost through Inventory Revaluation.

How can I prevent this error from happening in the future?

• Always ensure costs are entered correctly when creating items in the system.
• Regularly review stock transactions to identify any discrepancies.
• Configure item groups and valuation methods accurately during item setup.
• Implement robust checks during Goods Receipt to verify that costs are recorded.

Does this error impact financial reporting or inventory valuation?

Yes, unresolved cost issues can affect inventory valuation and lead to incorrect financial reports. It is important to address the error promptly to maintain accurate accounting records.

What should I do if I can’t resolve the issue on my own?

If you’re unable to resolve the error, consult your SAP B1 consultant or raise a support ticket with SAP. Ensure you provide detailed information, such as the affected item codes, transaction details, and valuation method.

Can this error affect transactions other than Goods Issue or Delivery?

Yes, this error may also appear during Inventory Transfers, Production Orders, or any process requiring item cost calculation.

Why does this error occur specifically for “ITEM 1”?

“ITEM 1” is a placeholder for the actual item code. The error appears when SAP B1 cannot find a valid cost for the specified item(s) due to missing data or misconfigurations.

Are there any tools in SAP B1 to help troubleshoot inventory cost errors?

Use the Inventory Audit Report and Item Cost Audit Report to identify discrepancies in cost values. Additionally, review the Transaction Journal for historical cost movements of the affected items.

Keep following my blog for more SAP Business One troubleshooting insights and solutions to ensure smooth operations and hassle-free transactions!