MC+A Report

[Former Member]

Hi All,

Return Qty is not updating in MC+A Report(Customer Analysis Return), though I have maintained the settings in OVRO,OVRP.

Remaining values like Billing qty, Open order value n it's qty are updating.

Could u plz help me in this?

Regards,

Ramu

[Former Member · Accepted solution]

Dear Ramu,

Check again for the entry (T. Code: OVRO):

Sales Org.+ Dist. Chanl + Div + Customer Statisc Group (as"+") + SIS: Retorns, Credit Memo (as"2")

And (T. Code: OVRP)

SOrg + Dict chnl + Div + CtlCust (as"+") + CtlMaterial (as "1") + CtlDocmt (as "2") + CtlItm (as "2")

Apart from these Settings:

T. Code: VOV7

Item category: REN - Standard Item

Tab: Transaction flow --> Field: Item Cat.Stats.Group

maintain entry as "2".

Also, maintain Customer Statistic Group for Material (MM02) and Customer (XD02)

I hope, your issue will get resolved.

Best Regards,

Amit

[Former Member · Accepted solution]

Dear Amit,

Thank u for ur reply.

In customer & Material I have already maintained the statistic groups as 1.

For item cat REN I have already maintained as "2"

In OVRO & OVRP, I have maintained for all the sales areas as below

BP01 01 01 1 1 SIS: Sales Document, Delivery, and Billing Document

{Only I have maintained with 1 (customer statistics group) and1 for statistics group for sales document type}.

Apart from these settings did I need to do any further settings?

Plz guide me.

Thanks & Regards,

Ramu

[Former Member · Accepted solution]

Hi Amit,

And in OVRP, I have maintained for all my sales areas as below:

BP01 01 01 1 1 1 1 SIS: Sales Document, Delivery, Billing Document.

But I have not maintained with any other values which u have mentioned in answer.

Plz suggest me.

Regards,

Ramu

[Former Member · Accepted solution]

Dear ARmu,

Note: Check whether in Customer Master (XD02)

Key-in Customer-Code along with Sales Area BP01 01 01 and go to

Tab: Sales Area --> Sub-Tab: Sales --> Sub-Sub-Tab: --> Field: Cust.Stats.Grp

Check with entry. Is it "1" or "+"?

If its "1", then your entry in T. Code: OVRP

BP01 01 01 1 1 1 1 SIS: Sales Document, Delivery, Billing Document

is OK. Now, Add another entry as:

BP01 01 01 1 1 2 2 SIS: SIS: Returns, Returns Delivery, Credit Memo

But, if its "+" then maintain entries as

BP01 01 01 + 1 1 1 SIS: Sales Document, Delivery, Billing Document

BP01 01 01 + 1 2 2 SIS: SIS: Returns, Returns Delivery, Credit Memo

Similarly, in T.code: OVRO

Check for entries (if, Cust.Stats.Grp is "1" in Customer Master) :

BP01 01 01 1 1 SIS: Sales Document, Delivery, Billing Document

BP01 01 01 1 2 SIS: Returns, Returns Delivery, Credit Memo

Else, maintain entry as (if, Cust.Stats.Grp is "+" in Customer Master):

BP01 01 01 + 1 SIS: Sales Document, Delivery, Billing Document

BP01 01 01 + 2 SIS: Returns, Returns Delivery, Credit Memo

Also, Check Material Master (MM02):

Key-in Material-Code along with Org Levels "Plant BP01 01"

and go to View: Sales:Sales Org.2

Here, in Tab: Grouping Terms --> Field: Matl statistics grp, maintain entry as "1" (if, not maintained)

Best Regards,

Amit

Note: Once above-said entries will be maintained, System will update LIS, fom today's onwards-entries, and no for Past-Data. To update LIS with Past Data, run transactions: OLI7, OLI8 and OLI9 (though, I've not tried).

[Former Member · Accepted solution]

Dear Amit,

Thanks a lot for ur reply.

I have made the settings as per u, but still system is not up dating the "Return qty" in Report (MC+A).

After making the settings I have runned the sales cycle and the sales return cycle.

What cud b d reason?

[former_member217082 · Accepted solution]

Hi ramu

Our friend Amit has given the inputs apart from that kindly check the following . also

In OVRO & OVRP Check what is the assignment you have maintained. Is that assignment of statistics in OVRP as per the RE document type and RE item category only .

Secondly check what is the doc. statatics grp for document type RE and item category statatics grp for REN at sales order level and delivery level.

If the returns data are in past then run the reports OLI7, OLI8, OLI9

Regards

Srinath

Edited by: sri nath on Dec 18, 2008 7:44 PM

[Former Member · Accepted solution]

Hi,

I have cross checked every thing, all the setting are correct, then I have done the return process but still it's not updating the return qty in MC+A report.

Is there any other report for customer returns?

Can any one through some light on this issue.

Thanks & Regards,

Ramu

[Former Member · Accepted solution]

Dear Ramu,

What parameters, are you maintaining in Report: MC+A; while executing it?

Just try to remove all parameters, from all the fields, and then Execute (F8) the Report: MC+A

Best Regards,

Amit

Note: when you execute the report (keeping all fields as blank), either System will show some result OR throw some error at System-Status (down, at screen). Just read that deailed Error-log and also paste the same for our understanding.

[Former Member · Accepted solution]

Dear Amit,

I tried that too i.e with out giving any values, but system is not giving any message, but return qty is not updating and other values are updating.

[Former Member · Accepted solution]

Hi All,

Solved, Thank u all.