on 06-02-2011 3:04 PM
Hi Experts
Would it be possible to create a query which would show me the stock value per item group in SAP? I know this can be done through Stock Audit report etc, but as we have over 300 item groups I would like to see a report which show me only the group name and the stock value within that group.
Thanks
Geoff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Geoff......
What is your valuation method?
because mostly the value of the Item as per group depends on Valuation Method......
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gordon,
The 2% will be because in almost all cases the query is using Last Purchase Price to calculate the value, but the stock balance on 130000 account in Financials is being generated from the FIFO values of stock. It is a problem we come up against a lot in calculating stock values - we probably wouldnt have gone down the FIFO route originally had we known!
Regards
Geoff
User | Count |
---|---|
91 | |
8 | |
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.