vendor wise sales report

[Former Member]

Hi Expert,

Client requirement is like this

Client procure "materialABC" from different vendors like Vendor 1, vendor 2, Vendor 3

and client do the sale to his customers

now client want to know how much "materialABC" sold from with respect to vendor1, and vendor 2 , vendor 3

Note:-

1) client raise @ 50 PO everyday to different different vendor

2) and each PO contain minimum 300 to 500 different- different materials

if we generate the batch for each material w.r.t vendor then @ 25000 batches will be generate everyday

please suggest

[jignesh_mehta3 · Accepted solution]

Dear Friend,

To generate a Vendor-wise Sales Report, we need some link between Purchase & Sales systems.

Now the best link would be Batch Management, which you too have mentioned.

I guess you should go ahead with Batch Management & SAP system is quite capable to handle 25000+ batches in a day...

Hope this helps...

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Hi,

As others suggested ,I also stongly suggest Batch Management .You can create relevant characteristics like vendor,shelf life etc..

Thanks

Umesh

[Former Member]

closed

[Former Member]

closed

[Former Member]

Hi,

I dont think this eport is possible as you've got only one master data for that material and more than one vendor. More over u have to make combination for material and vendor which u can do with batch management,

You have mentioned the number of batches, but its possible for SAP to handle. So go with Batch Management

Thanks,

Raja