LIS Sales Reports

[former_member653171]

Dear Friends

When I am using stand Sales Reports in LIS (MCA,MC(A, MCA, MC+2 ) I am getting report when I have entered only Date but not with customer or Article.

I am getting Error that "No data exists for chosen selection"

I have maintained Customer statics group as well as Material statics group in customer & material Master respectively

Even I have assignments in OVRP and OVRO what need to check to get the report.

Regards

sudha

[Former Member]

hi Sudha,

Firstly check the Fiscal Year Variant maintained ie. whether it is K4 or V3.

Then go to Transaction code OB29, then select maintained variant and go to periods, then there you will see how the periods are maintained.

For E.g if it V3, Then period will be as follows:

Month Period

Jan 10

Feb 11

March 12..... and so on.

Now go to any Transaction code of Sales report and if you want March Month Report, then put period 12 and execute and report will be generated.

Hope it helps.

Regards,

Jaiprakash.P.T

[former_member653171]

Hi Jaiprakash

The Fiscal Year Variant maintained is V6 i.e July - June ( assigned in OB37 )

T- code: MC+Q, Period is 01.2009 to 03.2009, error is " No data exists for chosen select"

Hello Ever one

May I know the steps to execute T-codes OL17, OL17, OL19 in detail

Regards

sudha

[former_member653171]

help plz

Updation of SO, Delivery, Invoice

process to using transaction OL17

Regards

sudha

[former_member653171]

Hi

Thank you very much for your reply

I am getting report but if Period is 06.2008 to 12.2008

If my period is more then 06.2008 ( i.e. 08.2008 to 12.2008) its showing "No data exists for chosen selection"

Even I have today's updated document with updated statistics group.

and need to know all reports purpose.

Regds

sudha

[former_member217082]

Hi sudha

Check in OMO1 wheather any factory calendar has been assigned or not .Also check what is the factory calendar assigned to the sales orgn , company code

Regards

Srinath

[former_member653171]

Hi All

I am not getting any report form July 2008,

If Period is before July am getting report.

did I miss any more settings

Hi Srinath

In didn't get any thing form OMO1 , here one check box RP area active is there it is giving message MRP area is not defined.

Kindly help me out.

Regards

Sudha

[former_member217082]

Hi sudha

You might have not assigned Cust statistics grp or material statistics grp. in the past and now you might have assigned those things to CMR and MMR thats why you are not able to generate the past data .So just run the following reports to get the past data

OLI7 - Update sales orders

OLI8 - Update delivery documents

OLI9 - Update Billing documents

Regards

Srinath

[former_member653171]

Hi Srinath

when I am running OL17 I am getting error "select again"

Regd

sudha

[former_member653171]

Hi

can any one share list of LIS sales reports and their usage

regs

sudha

[Former Member]

Sudha,

Hope this helps you.

Transaction Codes for Standard Reports used in SD Module.

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

[former_member653171]

Hi Srinath

May I know the steps what to do in OL17, OL17, OL19

OLI7 - Update sales orders

OLI8 - Update delivery documents

OLI9 - Update Billing documents

Regards

sudha

[Lakshmipathi]

Dear Sudha

- Go to material master :Sales: sales org.2" view and ensure that you have maintained "1" for the field "Matl statistics grp"

- Go to customer master Sales Area Data and sub tab "Sales" and ensure that you have maintained "1" for the field "Cust.Stats.Grp"

thanks

G. Lakshmipathi

[former_member217082]

Hi sudha

Check in CMR and MMR wheather you have maintained cust. statistics grp in CMR and in MMR in sales orgn2 tab check wheather you have maintained Material statistics grp

Firstly , If the documents are in past then update those documents using OLI7,OLI8

Secondly check wheather the combination is correct or not in OVRP & OVRQ

Regards

Srinath

[Former Member]

Hi Sudha,

You can check whether the infostructure table is having any values for the particular customer.

If the value is not there then there is some problem in the updation.

Than you can check your customizations.

You can try to simulate the update for the transaction using SPRO-Logistics - General-Logistics Information System (LIS)-Updating-Updating Control-Update Check-Simulate Update

Also you can refer the other thread were our friends have shared lot of information ()

Regards

Mani