Sales-wise customer figures required

[Former Member]

Hi

We have one customer. That customer is consignment customer and factory sales. Now customer master record is one and one reconciliation account.

However we have created separate distribution channel for consignment and factory sales.

My requirement is that client should be able to get quantity and value for factory sales and consignment sales separately. Not only this, client must be able to know how much is outstanding from above sales (separately for factory sales and consignment sales).

I tried with report VF05N. But it shows total value on the basis of distribution channel-wise. So it means its catering only one of three requirements.

How to satisfy following two requirements:

1. Outstanding amount - distribution channel wise

2. Sales Quantity for every customer - distribution channel wise

[narasimhulu_konnipati · Accepted solution]

Try the below.

Sales org analysis - MCTE

Customer Analysis- Cr. Memo - MC+I

Deliveries-Due list - VL04

Billing due list - VF04

Sales org analysis-Invoiced sales - MC+2

Material Analysis-Incoming orders - MC(E

General- List of Outbound deliveries - VL06f

Material Returns-Analysis - MC+M

Material Analysis- Invoiced Sales - MC+Q

Variant configuration Analysis - MC(B

Sales org analysis-Incoming orders - MC(I

Sales org analysis-Returns - MC+Y

Sales office Analysis- Invoiced Sales - MC-E

Sales office Analysis- Returns - MC-A

Shipping point Analysis - MC(U

Shipping point Analysis-Returns - MC-O

Blocked orders - V.14

Order Within time period - SD01

Duplicate Sales orders in period - SDD1

Display Delivery Changes - VL22

Hope they helps

Thanks

[Former Member · Accepted solution]

Any other reports which may be useful from Finance point of view.

[narasimhulu_konnipati · Accepted solution]

try the below

S_ALR_87012186

S_ALR_87012171

Thanks

[Former Member · Accepted solution]

I tried with these TCodes. Its giving me total sales. It does not give distribution channel-wise.

[narasimhulu_konnipati · Accepted solution]

try the below tables

VD52 or VD59. tables MVKE, KNVV & VBAP

Thanks

[narasimhulu_konnipati · Accepted solution]

the below is the correct one it seems

T CODE - MCTG or MCTA

Thnaks