on 08-12-2014 11:06 AM
Hi ,
We are presently facing an issue with negative costs in cji3 report (Actual Cost Line Item Report). How to get rid of these negative balances? What should be done to ensure that there are actuals posted against the project?
Regards
Varun
Hi..
could you give us more details concerning the 2 issues you mentioned:
1.what is the reason of negative balances? (co,fi etc postings?)...You are actually looking at postings with value type 4?
2.when you mention about ensuring actuals in project...you mean that you have some other form of postings? (statistical etc...and which kind..please refer to value type and let us know)
Cheers
Panagiotis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Panagiotis,
1) Yes the reason behind the negative postings are FI Postings. We are actually looking at postings with value type 4 and 11.
2) Yes, we have statistical actual postings with value type 11. (Project to Plant Stock movements). The problem we are currently facing is with the value type 4. The value in the controlling area currency and the value present in reporting currency appears to be different and these values are exchange rate differences which are posted during IR.
Regards
Varun
Hi Varun,
Let me add more in that.
Cji3 is dynamic report which contains all transaction that will happen project.(+ve and -ve both)
However, generally, It contains negative due to following.
1. If actual revenue has been booked in Project, then it will occur as negative in CJi3 report
2.If some fi posting has been reversed that new line item with negative value will occur.
3.If Settlement has been run ,,in that case also negative line item will show.
You can check COEP and COSP table for same with value type 4
Also . you can mark filter in CJI3 report in business transaction and value type 4 and 11 or go for z report.
I hope, It will help
Thanks & Regards
Rahul Bansal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
You are right as far as finding out the non-negative values in the column. However the problem we are facing is we are finding negative values in the actual cost line item report. This was because there was a huge variation in the value being shown in transaction currency (Even though the value in the controlling area currency remains the same). For Eg: for one of the entries being displayed in the actual cost line item report if I have a value of 11036.84 GBP presently being shown under the controlling area currency, the value in transaction currency is 17775.55 USD (Considering the exchange rate) which I agree.
However the other entry being displayed in the report shows a value of 11036.84- GBP in both controlling area currency and the transaction currency columns. The transaction currency should always have been USD, however some of the entries which are getting displayed right now do have the transaction currency similar to the controlling area currency.(which is GBP).
Kindly advise,
Regards
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Varun,
If some value is showing in negative value (which has its counterpart positive value) then may be it's a reversal document.
Moreover, your CO area currency is GBP and it remains same in your report (it is ok). But the transactions may happen in any currency (USD or GBP) , and every report shows the value of transaction with its specific transaction currency . And it looks fine for me.
May be I did not understand your issue.
Regards
Saurabh
Hi Varun,
Simplest thing you can do is to put the filter 'greater than or equal to 0 or Greater than 0' for currency value column, In this way you will get all non-negative values in that column.
Regards
Saurabh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.