ITem cost was not found --- error

[Former Member]

Hi

When i try to copy a sales order to delivery, the contents gets copied but when i try to post it, an error pops us as "Item cost was not found". I have this error only for some items and other items gets added and posted.

Please help me with this

[former_member187989 · Accepted solution]

Remove tick mark - Allow Stock Release without Item Cost in document settings in test DB.

Jeyakanthan

[former_member187989]

Pl read previous post.

Jeyakanthan

[Former Member]

Hi Nat

ITs a test Database

[Former Member]

Hi Abishek

We are managing items using FIFO

[Former Member]

Hi,

Run the Stock Posting List and see if you had any costs for the item when you received it. If there's no cost it means you don't have any FIFO price for this item in the system.

Is it a test database or a live system?

Regards,

Nat

[former_member187989]

hi sanath,

Customer Cannot Issue Item From Warehouse
Item Cost = 0 and Allow Stock Release without Item Cost is disabled



Symptoms
Error message on adding outgoing inventory document:
"Cannot issue item from WH which is managed by batches or serial numbers". 

Customer cannot issue an item from warehouse (with some transaction decreasing on-hand quantity). When issuing item, customer cannot select an item batch or serial no. although it exists and has enough available quantity.


Resolution
Check setup options in SAP Business One:
If in Company Details > Allow Stock Release Without Item Cost is selected.
What the valuation method is in Item Master Data > Inventory Data Tab.


Check Item Cost:

For moving average price (MAP) and standard price, please check Item Cost in Item Master Data > Inventory Data Tab. If customer selected option: "Manage Item Cost per Warehouse" in Company Details, check the Item Cost for relevant warehouse in the tab row.


For FIFO item, please check the Item Cost of open FIFO layers. In version 2004 C and 2007 A, Item Cost can be seen for remaining Open Quantity of FIFO layers in Inventory Revaluation window after selecting relevant item and warehouse.

For all versions, please run following SQL query:

SELECT T0.[ItemCode], T0.[Warehouse], T0.[OpenQty], T0.[OpenValue], T0.[OpenValue]/ T0.[OpenQty] as ItemCost FROM OINM T0 WHERE T0.[ItemCode] =[%0]

If the ItemCost is zero and Allow Stock Release Without Item Cost is not selected, Customer needs to change Item Cost to a non-zero value.

Jeyakanthan

[ladislav_meszaros]

Hi,

Please refer to SAP Note 1132028 to get the details information about this unnecessary system error message: No item cost was found.

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team

[Former Member]

Hi

Goto that specific Item Master Data and move to Inventory Tab, choose validation method as Standard then below that put cost of that Items..

By

Kalai

[Former Member]

i wasnt able to locate a item cost section there and i tried to add from the form settings, its unavailable. But my demo db carries it, I dont know why is that happening like that

[Former Member]

Hi Sanath,

Is your item master is maintained with Valuation Cost - Standard / Moving Average or FIFO ?

Regards,

Abhishek