vendor wise sales report

Hi Expert,

Client requirement is like this

Client procure "Article-ABC"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 "Article-ABC" 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 Articles

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

please suggest

Edited by: Hanumant Nimbalkar on Jun 23, 2009 2:16 PM