Planned Revenue not flowing to projects

[Former Member]

Dear All

This is a T&M project scenario. Billing based on manhours

Here my planned revenue (Sales order price) from sales order is not updating in project. Actual cost is updating from project to sales.

Can anybody help me to solve this

Regards

Deepu Pillai

[Former Member · Accepted solution]

Hi

Check the setting in planning profile you are using. T code OPSB, Automatic revenue planning tab. "From sales order " check box should be ticked.

Regards

[Former Member · Accepted solution]

Dear,

I m also having same probleb ,i've checked the setting in planning profile and its ticked as automatic revenue planning from sales order.

If the revenue element which i've inserted in profile is effecting the revenue report.

And also the after down payment the payment value also not showing in CN41.

Regards.

[gerald_vilimovsky]

Hi,

I would recommend to check this in debugging.

Set a breakpoint in function module K_PROJECT_SD_PLANVALUES at the following line:

...

• Fill internal tables from interface table

perform tcoeri_fill_from_acctsd tables t_acctsd. <<<<

Make a change to the sales order (changing PO number) and save it.

In table T_ACCTSD you will see, what is transferred from SD to PS. Please check fields SAKNR and FKDAT.

Often the problem is, that the cost element is not valid at the posting date (FKDAT).

The relevant checks are done in include LKAOVF01 (subroutine COERI_FILL_FROM_ACCTSD). Only the data, that is transferred to table T_COERI can be posted as planned revenues on PS side.

If there is no useful data in T_ACCTSD at all, this is a SD topic. There might be a problem in account determination or other.

Please read notes no. 96404 and 647261.

Best regards,

Gerald.

[Former Member]

Hi,

I do think it is related value category customization (OPI1 & OPI2) . Pl check whether value categories are assigned to the correct cost element range / group as well as whether revenue / cost categorization in OPI1 is proper.

Murali

[Former Member]

Hi

Pl see if the values are gettinbg updated in revenue planning transaction CJ42, version:00, under column heading "sales order value". If the values are getting updated here, then the issue could be juest a reporting issue.

Pl revert

regards

Murali

[Former Member]

Dear Sir,

Its not getting updated in CJ42.

if this is releted to cjvc revenue element.

Its traffic light is red in CO area.

Regards.

Sukhveer.

[Former Member]

dear,

Problem is still there Sales order value is not showing under revenue planning in WBSE.

So please do't close these thred

Need help from experts.

Regards.

Sukhveer.

[Former Member]

Hi,

Most likely account determination is not happening in sales order on account of wrong / inadequate G/L account assignment. You can check this in sales order as below:

VA02->Environment->Analysis->Account Determination.

Pl see whether G/L accounts are detrmined properly.

If there is a problem here (most likely, yes), assign proper G/L accounts in SPRO transaction as below:

SPRO->Sales & Distribution->Basic Functions->Account Assignment/ Costing->Revenue Account Determination->Assign G/L accounts.

If you are not familiar with customization of this, you may like to take the help of a SD/FI consultant.

Murali

[Former Member]

Dear Sir,

Yes we've assigned properly .

Texes are going to correctG/L.

Revenue is going to correct revenue element.

Something elese is missing.

regards.

[Former Member]

Sir,

My revenue planing by sales order is not comming but if i create dilevery its cost is showing against actual cost of WBSE in CN41.

regards.

Sukhveer.

[Former Member]

hi sukhveer,

check wether integrated planning indicator and WBS as revenue element is ticket in project profile ...

regards

pushpa

[Former Member]

Dear,

Billing WBSE is ticked .

Intregrate Planning i think is not needed for that revenue planning updation from sales order.

Regards.

[Former Member]

Dear Sukhveer

First of all thankyou for carrying the thread. I was outof office last day. I will check all the settings in the threads..

Will ward points for correct answers, & ward you specially

Regards

Deepu Pillai

[Former Member]

Hi,

Have you release that bill in a/c. I've experienced it. before releasing to a/c, revenue doesnt update in Project.

Regards

Dinesh Chauhan

[Former Member]

Dear,

Can't get explain in full.

Regards.

[Former Member]

HI

IF all settings told by venket r correct , then check accounting document generated by sales order.

check g/l account and sd integration is correct .

shashank

[Former Member]

Hi,

Make sure following settings

1-go to OPSB and tick FROM SALES ORDER indicator in

automatic revenue planning tab.

2-go to OKKP and choose component active for order management.

and tick SALES ORDERS indicator.

Regards,

Vivek tripathi

[Former Member]

Dear,

I've done the both of the setting as told by you .

But still value is not comming .

What else should be done?

Regards.

[Former Member]

Check following settings.....

1. Cost element Category of Revenue element specified in the Planning Profile (OPSB), should be 11.

2. Valid Date of the above revenue Cost Element

3. WBS assignment in the Sales Order account assignment tab

4. Run CJEN once

5. Check S_ALR_87013564 report also.

6. Finally u need to check the value category customization in CJVC

Venkat

Edited by: VenkatSrinvas Konda on Oct 13, 2008 2:43 PM

[former_member582392]

Pl check whether you have assigned the RElem.f.billing plan

Regards,

Arun.An

[virendra_pal]

Relem for billing plan is not required as the revenue is required to come from sales order

Follow Venkat's post - that is correct

[Former Member]

Dear,

Sorry i've not able to check your mail.

This report is not created in my company

S_ALR_87013564 i'll send to SAP and get NOTE or Patch.

In CJVC status of CO Area is RED Status but the

Revenue element is status green .

Is there any problem for that status.

Cost element is of catagory 11.

assignment to WBSE is correct.

Do't know the use of cjvc.

Regards.