cancel
Showing results for 
Search instead for 
Did you mean: 

Item cost Missing

Former Member
0 Kudos

Hi Expert

when am entering Open A/R credit memo, for an item eg:- (SP001), only for some whse "Item Cost " is not appearing and due to that JE is posting with "0" value,

so we need to reconcile the item which had been done through such open A/R credit memo,

Why is it happen? Pls any one could sort it out

Regards

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please run the query attached in SAP note, to find whether item cost defined or not. If not item cost not defined, JE will be posting with 0 value.

1295350 - How to identify items which have no item cost?

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi rajan

i had run those query , but out of that only one query generates Report

pls could u explaine the same

Regards

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check whether above item  (SP001) included in query result.

Meaning, the above item is not assigned with item cost.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi rajan

thanks for the Replay

am not able to join the two query together as per said, when am trying to join and run the query, some error is getting

regards

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

I never mentioned to you join query.

1. Run the query and find the items that do not have item cost.

2. Check your problem item whether included in the query result.

Hope you understand.

Thanks & Regards,

Nagarajan

Answers (6)

Answers (6)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

If you got answer, please close this thread by marking correct/helpful answers.

Regards,

Nagarajan

Former Member
0 Kudos

Yes rajan

it was solved, thanks for the support and Sap Note u had provided

Regards

Former Member
0 Kudos

Please close your thread by marking correct answer.

K_Pauquet
Advisor
Advisor
0 Kudos

Hi Satheesh Babu,

when you post an unbased credit memo the application will pull the item cost from the warehouse that is to receive the item. If you don't have an item cost or a cost of zero for that item, then no value will be attributed.

In case FIFO, even if there is no stock at present, the item will be received back into the warehouse at the item cost of the last layer. If there are no layers in that that warehouse, then there is no item cost & hence no value attributed to the item.

You can however assign a value to the item using the Stock revaluation functionality. The journal will show a debit for the stock account & a credit for the GL Increase account.

All the best,

Kerstin

Former Member
0 Kudos

Thanks Kersti

for u r valuable advice

Regards

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Have you checked above SAP note?

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Yes

Thnaks for the support

Regards

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check with SAP note :

1057681 - Item received in AR Credit Note with zero cost,
FIFO.

Hope helpful.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi,

What is business background for you to create this open Credit Memo? Is the item sold out before system went live?

Thanks,

Gordon

Former Member
0 Kudos

Hi experts

pls find the attached query report

Regards

Former Member
0 Kudos

Hi,

Can you run the Inventory audit report for this item for this warehouse 'RPR' and post screen shot ?

Thanks,

Priya

Former Member
0 Kudos

Hi Priya

Thanks for the Response

pls see the attachement

its of 3 parts, as the report is form 01/04/2013 till today, it too much length

regards

Former Member
0 Kudos

Hello,

Which SAP Version you are using.  Looks like when the A/R CM was made, the 'enable setting cost' was selected and no 'return cost' was defined.

Pls check in the AR CM 130700065.

Thanks,

Priya

Former Member
0 Kudos

Hello,

What is the valuation method you are using and is the g/l account determination by warehouse.  When a item is received and GRPO / AP Inv is made then system generates it's item cost for that warehouse mentioned in the GRPO or AP Inv only.  So if you are making a credit memo in a warehouse which never received this item, then item cost will be zero.  For this you can use the Item Revaluation or the 'Return Cost' depending upon the sap patch level to set the item cost for the concern warehouse.

Hope that helps.

Thanks,

Priya

Former Member
0 Kudos

Hi priya

am using FIFO method and g/l account determination is Item Level

"So if you are making a credit memo in a warehouse which never received this item, then item cost will be zero."

Priya, i didn't get what u mention as per the above stated sentance

pls could u explaine

Regards

Former Member
0 Kudos

Hello,

If you have a demo db at your end try the below..

create a new item

make a grpo / ap inv.  In this document you will select the warehouse.

open the inventory revaluation form and select this item and this warehouse

you will see the item cost

now in this same form select this item with a different warehouse

do you see the item cost ? it will be 0.

now when you make a stand alone ar credit memo with this item and the first warehouse, document will not ask for the item cost and will use which is already generated thr grpo but if you select the second warehouse then the document will ask for the cost.

Hope that helps.

Thanks,

Priya

Former Member
0 Kudos

Hi priya

i understand u detail, but when i created the open credit memo, where the item cost i showing '0' , the document is not asking for Item cost,

regards

Former Member
0 Kudos

Hello,

I am sorry...it won't ask for item cost but will give msg saying that 'there is no cost for item...due you want to continue ?  If you continue..it will take '0' and save the document.  Also have u checked the item revaluation window.

Thanks,

Priya

Former Member
0 Kudos

Hi Satheesh,

Did you create a manual AR Credit Memo?

If you create it based on AR Invoice, system will return Item cost which in AR Invoice.

If you create manual, system will return current Item cost of this Item in whs.

GBU

Former Member
0 Kudos

Hi toan

Thanks for the replay

Yes i had created as a manual. But for the same item in differ whse it is not showing "Item Cost"

Regards