How can we diferentiate the follow scenario

[Former Member]

hi friends can any one give me the solluation for the following scensrio

Our client sells industrial salt (material) in the following three ways

1, the client produce the material and sell it to the customer

2, the client buy it form vendor and store the material in the clint's storage location and sells to the customer

3, the third one is he buy form vendor and ask teh vendor to deliver it to the end customer

in these theree scenarios the client is doing business for the SAMEPRODUCT

here the client wants sales &revinue reports for the own produced products suparately and traded products (which vendor suplied to the customer + sales of which he purchased and stored in clients storage location) suparately.

how to get the reports for the two above scenarios

please give me the solluation it will be very helpfull for me

and i will five full points for the solluation

thanks

nitchel

[Former Member]

The scenarios can be mapped by the following ways for the same product

1) first one is normal sale just like sales order delivery billing

2) Second one is the Individual Purchase Order where the item is third party item. while raising the sales order if material is not available and want to procure the material from the vendor change the item categroy in the sales order as TAB instead of TAN. for this u have to do the settingin item category determination manual item category should be TAB after TAN

i mean ORNORMUSAGE+HIGHER LEVEL ITEMCATEGORY= TAN AND TAB IS IN MANUAL ITEM CATEGORY FIELD

3)follow the second process for third one as item category will be TAS .in item category determination mention the manual item category as TAS.

Reports u can see the customer wise, material wise see the follwoing list

Sales summary - VC/2

Display Customer Hierarchy - VDH2

Display Condition record report - V/I6

Pricing Report - V/LD

Create Net Price List - V_NL

List customer material info - VD59

List of sales order - VA05

List of Billing documents - VF05

Inquiries list - VA15

Quotation List - VA25

Incomplete Sales orders - V.02

Backorders - V.15

Outbound Delivery Monitor - VL06o

Incomplete delivery - V_UC

Customer Returns-Analysis - MC+A

Customer Analysis- Sales - MC+E

Customer Analysis- Cr. Memo - MC+I

Deliveries-Due list - VL04

Billing due list - VF04

Incomplete Billing documents - MCV9

Customer Analysis-Basic List - MCTA

Material Analysis(SIS) - MCTC

Sales org analysis - MCTE

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

dont forget to reward points if helpful

Thanks and Regards,

Rahul