Skip to Content

Downpayment not reflected in CJI3 report

We have an issue with downpayment request to be reflected in cost reports. User has done automatic payment run for downpayments against a PO assigned to Network Activity. This payment also has a cancellation but none of them is reflected in CJI3 report though Value Type 12 is chosen for the run. We have also tried the STD PS report for reflecting downpayments S_ALR_87013536. I dont find any configuration issues as there are seven old entries in system which had downpayment posted and it is rightly reflected in CJI3 as well as the other standard reportsd. May I know what else may be the issue?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

12 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2014 at 11:19 AM

    Hi,

    Have run CJEN? If not then run and check again in CJI3 with VT=12.

    Regards

    Shishir

    Add a comment
    10|10000 characters needed characters exceeded

    • Sorry for the delay in my response I would like to go through all your suggestions one by one. I ran CJEN for this Network code in test mode and found that there are almost 9 cost elements for which value category could not be determined. Can this create a problem for the downpayment not to be reflected in report CJI3? Further I am doing some more testing in our pre-prod system and let you know my findings.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2014 at 12:01 PM

    Hello Suman

    Check for the Account assignment data in the line item of Downpayment.

    Let us know if that is the case.

    Regards

    Praveen B.K


    WBS.jpg (52.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 16, 2014 at 12:05 PM

    Check first RPSCO table like down payment is being storeor not?

    refine with value type 12 for down payment

    Regards,
    Sanjeev

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 16, 2014 at 03:29 PM

    Hi Suman,

    Run the Reconstruction Program once followed by CJEN, CJBN.

    Also check the settings in OAYB for transaction type 15.

    Regards

    Gaurav Ahuja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2014 at 03:42 PM

    Hi,

    One more thing, is your corresponding PO line-item is showing in CJI3? Check that.

    May be Problem with cost element. That is why it commitment/actual haven't generated.

    Regards

    Shishir

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2014 at 05:39 PM

    Hi,

    Downpayment, these are special G/L accounts set up in system.


    Try in FBL1N and check against Special G/L account check box.

    Thanks,

    Sudhakar

    Message was edited by: Sudhakar Pappu

    Message was edited by: Sudhakar Pappu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Suman Misra

      Hi Suman,

      Check the COFP table either with the PO number as input or the activity OBJNR as input.

      You should see both the actual posting for the downpayment, clearing of the downpayment and even the cancellation. In your case, since you are saying that downpayment is cleared you should not see any value against value type 61. However, you are also saying that there is a reversal posted for this downpayment.

      Could you tell us how the reversal was done? Assuming that you have still not done F-49, and used F-54 to do the clearing, could you tell us if this clearing was reversed/reset using FBRA?

      If yes, you should see the down payment value in COFP table against value type 61.

      Let me know if this helps.

      Regards,

      Gokul

  • Posted on May 13, 2014 at 08:49 AM

    Hi,

    I think if you want to display down payments CJI3 report you need to check few things.

    1) Is the project cash management is activated in the project .if the PCM is not activate the payments will not reflect in the project.

    2) check WBS is maintained in the specified down payment request or not

    Thanks

    R.B.Rao

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 13, 2014 at 09:17 AM

    Hi Suman,

    In CJI3 initial selection screen, Extras--> Select Value Type --> Select Downpayment as operating expense.

    This will include downpayment values in report as expense if required.

    Allocate points if found useful.

    Regards,

    Gangappa

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2014 at 03:53 PM

    Hi Gokul, As you mentioned I checked the table COFP with both the PO number and the OBJNR of the Network Activity and I could not find any entries. So the very first point you suggested is not matching here. As I told you before I have also tried to run CJEN in production and got the warning messages regarding cost elements assignment to value category missing. Further there are no entries even in table RPSCO.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 21, 2014 at 08:58 AM

    Hi, Can you please help me here. I did the teating as suggested. Regards, Suman

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.