Sales Information System

[Former Member]

Hi All,

I am trying to take Sales report from Transaction code MCTE. I could able to get the report till October'2008 after that if I select Nov'2008 i.e 11/2008, system is giving the error" No data exists for chosen selection" . Let me know u r valuable reply in this regard.

[Former Member · Accepted solution]

Dear Jaiprakash,

As far as Transactions: OVRO & OVRP (LIS Updates) are concerned, I think, those will be fine; as you are getting Report Data till Oct 2008.

Regarding Transaction: OMO1, Mr. Srinath has suggested some way-out. Just check and update accordingly.

If your issue gets resolved, well and good, but if not, Please update your Post with following informations:

1. What is your Period Unit for Info Structure: S003, in Transaction OMO1? Is it Day, Week, Month or Posting Period?

2. What Update Type is being activated? Is it V1 or V2 or V3 or No Updating?

3. What is Fiscal Year Variant for Info Struct. S003? Is it K4 or V3?

Best Regards,

Amit

[Former Member · Accepted solution]

Hi Amit,

Thanx for u r reply. In S003, the Period maintained is Posting Peroid and in updating it is i.e Asynchronous updating(2) and Fiscal year used is V3.

But I am using as it is and hv not changed anything.

Kindly let me know valuable inputs.

Regards

Jaiprakash.P.T

[former_member217082 · Accepted solution]

Hi jaiprakash

As S003 has the Fiscal year V3 check the opening and closing period of that factory calendar . check what factory calendar year you maintained for your sales orgn if you have maintained another factory calendar then change it to V3 only .Also change the factory calendar in Plant and credit control area . Then generate the report

To update the past data run the reports

OLI7 - To update past sales orders

OLI8 - To update Past delivery documents

OLI9- To update past Billing documents

Regards

Srinath

[Former Member · Accepted solution]

Dear Jaiprakash,

Some business organizations, maintain records from April to March, some January to December or some in other way. The period from which the financial records are maintained is called Fiscal year. Hence we need to define Fiscal year as per the need of our business organization.

A Fiscal year is divided into posting periods. Each posting period is defined by a start and a finish date. Before you can post documents, you must define posting periods, which in turn define fiscal year.

Posting period is a period with in a fiscal year for which the transactions figures are updated.

Maintain Fiscal Year Variant u2013 OB29

Check whether Financial Year Variant is Year-Dependent. If So, make it Year-Independent.

Also, Don't maintain Calendar Year.

Best Regards,

Amit

Note: You may also give a try by changing Fiscal Year Variant to K4.

Also, referring one document, which will brief about Fiscal Year Variant/ Posting Period Settings.

[DEFINING FISCAL YEAR VARIANT, POSTING PERIOD VARIANT, OPEN AND CLOSE POSTING PERIOD|http://www.hareshpradhan.com/SAP/SAP%20Notes6.htm]

.

[former_member217082]

Hi

Check in the infostructure in OMO1 wheather you have assigned any factory calendar or not . If you have assigned then remove that factory calendar and then run the report

Secondly check wheather you have done the following assignments or not in OVRP , OVRQ

Regards

Srinath

[Lakshmipathi]

Is the data for the period Nov'08 flowing in VF05 or VF05N ??

thanks

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi,

I could able to generate the report till October 2008 but after that from November onwards, the system is throwing the error. I am using all standard T/codes to generate the reports.

Let me know u r comments. Also if any setting where-in, I can change the periods.

Regards,

Jaiprakash

[former_member217082]

Hi Jaiprakash

As you are generating the MCTE which is related to infostructure S003.So go to OMO1 and check the infostructure S003 wheather factory calendar has been assigned or not to infostructure S003. If assigned then remove it and then run the report of the October month also you can get it

Regards

Srinath

[former_member188076]

Hi

My earlier message was not meant for you.

Sorry it was wrongly [posted.

Regards

AA

[former_member188076]

Hi

Go to VF02 and execute the invoice no. which you wish to post. Then GO TO --> Header --> Header, and their change the billing date as per your requirement, and save.

Now if you will release the Invoice for FI posting the document will be posted for the new billing date. However ensure that all the data is proper as per new billing date.

Regards

AA

[Former Member]

Thanks for u r reply. I want to know the settings where in I can create the report from 11/2008 month. There are sales pertaining to these months i.e Nov/Dec/Jan. Upto October Month there is no problem in creating the report.