Knowledge Management

Question:
Hi all, due to an increasing drop of our local currency against the US Dollar, we need the MAP to show the LAST GR/Invoice verification value (cost), this is because the average price will not show my true margins agains sale price.
thanx
Answer:
Hi,
It is true to say that your specific requirement can not be met since in regard to MAP, the price will be updated subject to the stock movement and payment postings. What I can recommend, therefore, to you is to use standard cost instead of MAP.
Cheers,
HT
Answer:
But when using standard price, how will it be updated, i did some testing, and with new GR postings the standard price did not change, it was not updated to my new cost.
Answer:
Hi,
Of course, for the case of standard cost, it is not possible that your price will be updated since all price difference will be posted to price adjustement account.
Besides, since the price difference is purely due to the exchange rate variance which will be obviously charged to KDM Transaction/Event Key account, I would not think that it will much concern you in terms of BSX stock account. Of course, the customizing can enable to set how you would like to post the exchange rate which you can freely set in SAP.
Cheers,
HT
Answer:
THANK YOU ha tran, but what i need is that my standard price gets updated with my last GR value. Can this be done?
Answer:
Hi,
No this can not be done as you expect.
Cheers,
HT
Answer:
Then how is the Standard Price (price control S) updated??
I need a way of valuating my inventory with the last GR value.
Thnx
Answer:
It looks like your question relates ( correct me if i misunderstood) to how to valuate inventory keeping in view of the fluctuating cost. This topic
is covered in SAP under material valuation where you can either use LIFO or FIFO or lowest value approach to valuate inventory for balance sheet reporting so that revenue and tax factor in the cost fluctuation.
If this is your real need, then what you are asking may be addressed by FIFO method, which requries a lot of set up in mat.master and elsewhere.
FIFO valuation is a method that enables you to valuate the stocks of a material as realistically as possible. FIFO (first in, first out) stands for the assumption that the first stocks of a material to be received are the first to be consumed. The value of the stock is therefore calculated based on the last stocks received.
nmysore
Answer:
Can't use lifo/fifo in valuation, our R/3 is a retail system.
All i need is that the average cost (V) or the standard cost (S) to take the cost of the last GR/IR from vendor.