Distribution channel-wise customer sales and outstanding report.

[Former Member]

Hi

In our scenario, one customer is direct factory sales as well consignment sales customer also. We created two distribution channel. But customer master record is one.

Now my client requires customer report:

Total sales value and quantity - distribution channel wise

Outstanding customer balance - distribution channel wise

Please let me know if this report is possible.

I tried with some reports: S_ALR_87012171 and S_ALR_87012186. But its showing total sales.

I tried with VF05N. It shows billed amount and does not quantity.

Please help.

[Lakshmipathi]

If the Recon account is different in the above scenario, then you can try with FS10N

G. Lakshmipathi

[Former Member]

Since my customer master is one, we cannot assign separate reconciliation account. Hence i am asking this report.

[jignesh_mehta3]

Distribution Channel-Wise Sales can be made avaialble thru Standard Reports or LIS / SIS.

But, I believe you cannot get the Distribution Channel-wise Outstanding Report from SAP Standard. You will have to go for Z-Report Development.

Speak to your ABAPer & get a new Report developed.

Hope this helps,

Thanks,

Jignesh.