Through the vendor to check the stock
Dear all:
I want to know whether there is a report which it can through the vendor to check the stock. Because we want to know the detail situation stock for each vendor.
Please give me the best solution.
Thanks in advance.
Hi,
What kind of stock you would like to check through the vendor? Is it consignment stock? or the stock you have subcontracted to your subcontractor?
Cheers,
HT
Maybe you can create a query which include the info record and material stock. Before this you should sure one material is related to only one vendor.
Thanks
Hi Ha tran:
So long time not see. I know your meaning. I only want to know the normal stock. Can you give the standard function in SAP? Not the special stock. BTW, where and what are you doing during these days, It isn't display on MSN message. Keep in touch.
Hi Xway:
Thank you for your suggestion. Use query is the best solution. But can you tell me the detail table which I can use.
Thanks all.
BTW, I forget to tell you, I am paul_tck.
Thanks
Hi Paul,
Nice to hear from you. Since I were in another assignment, it was impossible for me to contact you.
In respect of your specific requirement, I am afraid that it is impossible since once GR was posted with reference to different vendor via POs, then they are all logically inventorized in the same storage location. The only thing that I can think of is if you are using Batch Management and a specific batch number will be assigned to one particular vendor, then the standard stock overview transaction (MMBE, for instance) can be used to see the outstanding stock for each and every batch number and since this batch number is corresponding to a certain vendor, you can easily find the linkage between vendor and current stock quantity.
Hope this helps.
Cheers,
HT