Vendor wise Sales & Stock Report in SAP Retail

[Former Member]

Hi,

My requirement is:

I need to develop a report for suppliers, showing them the sales and stock in each sales office. The report will be able to show the quantity in sales and stock for each sales office and a total for each one, in a determinated period for the given supplier.

Can anyone please suggest a step by step process to extract the data, I will get vendor number/s from selection screen and the date range based on which I need to extract the data?

Is it posible to determine the vendor of a material from the sales order, I have multiple vendors for a material? Can anyone please explain me how to determine the vendor of a sold material?

Thanks in advance

Kumar..

[eduardo_hinojosa]

Hi,

If you populate batches, try to populate an infostructure (LIS) for movements 101 (for purchase orders) where you have the article (material in IS-R), plant and vendor code. Other question is the STO from distributions center to shops. Of course, you need that the batch will be different for different vendors. It's an idea.

I hope this helps you

Regards,

Eduardo