vendor wise sales report

[Former Member]

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

[hnmuralidhara]

Dear Hanumant,

You have to use Consulting Skills here; Vendor identify looses as soon as GRN done.

Option No. 1 : Since you are using SAP IS Retail, you can use Vendor Consignment to track Vendor wise sales

Option No. 2: You can develop customized report using following (suggested) logic;

(a) Vendor A - Article A - EAN Code 1

(b) Vendor B - Article A - EAN Code 2

(c) Vendor C - Article A - EAN Code 3

Since, Sales are happening through POS using EAN Code, you can extract all relevant information including EAN Code from POS System.

I hope this will suffice.

Regards - Muralidhara

[Former Member]

Dear Muralidhara

Thanks for reply

a) Vendor A - Article A - EAN Code 1

(b) Vendor B - Article A - EAN Code 2

(c) Vendor C - Article A - EAN Code 3

As u mention here EAN Code 1,2,3 for same material ,which is not possible with my client because here EAN Code is same for one Article and it is unique i can't put different (e.g. any book has unique ISBN no )

so please suggest how to proceed

I am trying to map thr Batch Management but it is difficult to generate Batch w.r.t. vendor wise

like i have to create batch for one article w.r.t. vendor then only i think it is possible

please guide

thanks in advance

[hnmuralidhara]

Hi,

I know...EAN code is unique for a Article and Manufacturer. But, you can generate your own EAN Codes to cater your report requirements.

Bye,

Muralidhara