Skip to Content
0
Former Member
Dec 12, 2011 at 08:47 AM

Sales-wise customer figures required

78 Views

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