Differentiate Normal Sales vs 3rd Party Sales

[Former Member]

Hi all,

The standard system would allow the creation of normal sales and 3rd Party sales under the same Order Type and same Billing Type. It is controlled using the item categories.

As such, I would like to understand how I can use the standard Sales or Billing Report to differentiate the normal Sales and/or Billing document against the 3rd Party Sales.

Please assist.

Thanks.

Rgds.

[jpfriends079 · Accepted solution]

Either develop Z report for the same based on I Cat/Mat Grp/ Mat Type.

Or in va05/vf05, select material based on Material Group/type, individually for 3rd Party and normal sales.

Thanks & Regards

JP

[Former Member]

Thanks, I will develop a query for that matter.

[Lakshmipathi]

Two options are there

a) If you want to utilize the standard reports like VF05N, go for a different billing type where based on billing type, system will generate a report

b) If you dont want to go for a new document type, then you have to develop a zee report.

thanks

G. Lakshmipathi

[Former Member]

Hi,

The item category will be different for normal sales and third party sales.( TAN & TAS).

To differentiate the sales for normal & third party.

Create a query using VBAK ,VBAP, VBRK,VBRP and give input selection field as item category.

REgards,

KRishna O: