on 09-09-2014 12:48 PM
Good Day Mentors,
My user has encountered an error during Inventory Posting and its "Item cost not found for one or more items".
The specific Message ID from SAP's System Message Log is 10001287.
I found a similar post which addresses this error here.
But unfortunately it did not help me solve my user's problem.
I already checked if the items had a defined "Item Cost" in the Item Master Data Inventory Tab, and they all have "Item Cost" defined.
I'm not sure if this will help, but below is the Inventory Audit Report of one of the items that is throwing the "Item cost not found" error.
I am not a business consultant neither am I literate in accounting, so thanks for the patience.
SAP Version: 9.0 PL5
Valuation Method: Moving Average
Thanks in advance!
Sean
Hi,
Please refer SAP note. It is an application error.
2032378 - Items with a lower cost value than that defined in the
Decimal settings cannot be issued
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sean,
What is the count date you have entered?
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Augusto and Raviraj,
I've already verified in our production database the points you made:
- Is the "Manage Item cost per warehouse" selected in the Basic Initialization Screen?
YES
- Is the "Manage Inventory by Warehouse" ticked/checked in the "Inventory Data" tab of the "Item Master Data" screen?
YES
* I apologize for not have been able to give this information upfront.
Anyway, the database only has one warehouse at the moment.
I've checked the items, like the item in the screen shot above, and it does have an item cost.
Below is the screenshot of the sample item from my original post,
Thanks in advance!
Sean
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Augusto,
Thanks for your efforts.
Here is the screen shot.
For the sake of continuity, the Item Code is the red box below. This Item is in line 15, which is also boxed in red.
I suspect that the "Total" for this item is 0, that is why we are getting the error, but I am not really sure about it.
I tried, in a test db, to post the items whose "Total"s are not 0 and below, and they all went through, but the items that have "Total"s will throw this error.
Thanks!
Sean
Hi Sean,
Now I got it.
The problem is that the quantity * the avgprice is less than 0.01 therefore B1 says that it's 0.
Every stock document needs at least 0.01 to be done in B1.
In this case becase the stock adjustment is very short, just copy the quantity that you have in stock and no stock adjustment will be done.
Hope it helps,
Regards,
Augusto
Hi Sean,
This is in the Inventory Counting you have to change your Counted qty.
Looking to your print screen,
In the line 15 you have a variance of -0.000183 and with the price 10.249857 the total is less than 0.01.
You can't do this adjustment because it's less than 1 cent therefore you can't do any adjustment in this item.
My suggestion is to put the Counted qty = count Date column in the line 15.
Regards,
Augusto
Hi,
Go to the Item master of respective Item & Check whether item is managed by warehouse.
If yes, then check item cost for warehouse which is entered in transaction.
regards,
Raviraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sean,
In Administration - System initialization - company details - folder basic initialization
Is the Manage Item cos per warehouse selected?
If yes be sure that the warehouse that your user is using is the same that you have on the screen.
If this field is selected an item can have price in the warehouse 01 but in warehouse 02 can be 0 and this can be the reason of this message.
Hope it helps,
Augusto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.