How query based develop vendor rating report

[Former Member]

Hai,

I'm trying to develop, vendor rating report.

Please help me to developing report.

Parameter : Vendor Name wise

Fields :

S.no                Period                  GRPO QTY         Accepted QTY            No. of delay          Quality             

Period : 01/04/2015 to 30/06/2015

Example : GRPO QTY : 100

Accepted QTY : 50

Delay : Posting Date due date - GRPO Posting Date

Please provide query

[kothandaraman_nagarajan]

Hi,

How do you capture accepted quantity?

Thank you.

[Former Member]

Hai,

In Inventory transfer, Using bounded warehouse for QC Process.

SAP QTY Field as : GRN QTY

U_ACCQTY : Accepted Qty

U_RJQTY As Rejected QTY

[kothandaraman_nagarajan]

So your process is, receive item through GRPO , check quality of the product and if OK, then you transfer to another warehouse?

[Former Member]

Hai,

Yes you are correct