cancel
Showing results for 
Search instead for 
Did you mean: 

-ve value is coming in actual column in S_ALR_87013533 report

Former Member
0 Kudos

Hi Experts,

When i am executing S_ALR_87013533 report , in Actual column system is showing negative value . I am explaining how negative value is appearing in Actual column

Suppose for Particular WBSE if;

Sales = 100 INR

Purchase(GRN) = 70 INR

Therefore,Net result= 30 INR.

This report is showing -30 in actual column against that particular WBSE and this is the case with all other WBSE also. Since this report gives the comparison of Plan Vs Actual Cost , therefore in Actual column only 70 INR should appear as an actual cost.

I am confused why in actual column it is showing the difference of sales and purchase . Cost element category for revenue cost element is 11.

Expecting early response

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Please check note 152571 / 178837. Please run transaction CJEN / CJBN and report RKANBU01 / RKACOR04 to remove possible inconsistancies in assigned feild.

Thanks,

Goutam

Former Member
0 Kudos

HI,

First check is there any credit to cost GLs. Second check that revenue reports are comming correct or not say 31 or 64.

Then try suppressing revenue GL value category but in this case your revenue reports must show values.

I have same problem and working on it. By value category my problem solved but some projects are not showing revenue so working on it.

Nilesh

Former Member
0 Kudos

Hi,

In my case After checking revenue GLS setting in VKOA, Rev GL groups and deleting Suppressed Revenue value category.

I have up dated data by CJEN and CJBN. Then std reports are working fine now.

Nilesh

pradeep_mahamuni
Contributor
0 Kudos

yes you are right whenever you are making any change in value category or report selection criteria it is mandatory that you have to execute CJEN to reconstruct the project info database because PS reports select the values from project info database which is logical database.

regards,

Former Member
0 Kudos

Hi,

I ran CJEN, by which S_ALR_87013533 is now showing current figures except in one WBSE, and revenue report 64 is still not showing correct figures in actual column. In our project we have not used value categories.

Please suggest.

waiting for your replies

Edited by: SAP PS on Nov 8, 2011 6:17 AM

former_member230675
Active Contributor
0 Kudos

Please run CJI3 and check all the actual costs are showing properly or not.

Since S_ALR_87013533 is an Hierarchical report the out put is depends on the value category settings. Please check your value category settings, may be the cost element grouping is not proper there.

Former Member
0 Kudos

I checked in CJI3 ...it is showing both actualrevenue and actual cost in respective cost elements, and net value(revenue -cost) .

pradeep_mahamuni
Contributor
0 Kudos

Hi,

Check if you have created seperate value categories for cost and recenue and proper cost elements are assigned to them.

Also check the following in CJE5 for the reports 12KST1C and 12KST1D

In actual column check Debit type type maintain only as 1 and not alongwith 2. If 2 is also there then remove it. Actulay as standard 2 is not there but might be someone changed it.

regards,