Skip to Content
author's profile photo Former Member
Former Member

Sales-wise customer figures required

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Dec 12, 2011 at 08:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.