CJIA report and project cash management

[Former Member]

Dear all,

please help on the following issue.

i activate FM for project cash managment.

i assign material to the internal activity, release the project, run project MRP and convert the PR to PO.

then i run CJIA report, i can see the PO with value type 51, PO amount 40000.

below is the line item

2009.11.11 WBS I-0001 51 4,000.00-RMB 4,000.00-RMB

i do MIGO for the PO. and check the CJIA report, no change.

i do MIRO for the PO and then check the report, i see the PO (value type 41)value is reduced to 0.

another line with value type 54 appears with the amount 40000.

2009.11.11 WBS I-0001 51 0RMB 0RMB

2009.11.11 WBS I-0001 54 4,000.00-RMB 4,000.00-RMB

i think that is correct, because i do the MIRO for the PO.

next, i use F-53 to post the payment for PO. i check the report, no change.

then, i run CJFN to transfer the payment. i check the report again, the line with value type 54 was changed to value type 57.

2009.11.11 WBS I-0001 51 0RMB 0RMB

2009.11.11 WBS I-0001 57 4,000.00-RMB 4,000.00-RMB

i am not sure whether it is correct or not. in the report, it seems the balance is not zero. though the value type is changed.

the report looks akward.

can you give me some ideas or suggestions?

thanks a lot

Judy

[Former Member · Accepted solution]

Hi Judy,

What you have done is correct.

The total of all lines need not be zero as the report lists down the debit/credit side payments viz what we are supposed to pay due to a PR, or a PO or what are the actual payments that we have made. This helps us in planning for cashflows by showing projected or actual payments made/received

You can get a clear insight at following help page:

http://help.sap.com/saphelp_erp60/helpdata/en/c9/9c853478616434e10000009b38f83b/frameset.htm

with regards

[Former Member · Accepted solution]

when i do CJFN and check the report.

the value type is 57 that means payment, but the document no. in the next colum is the MIRO document.

i think the document should be the clear payment document.

so i think maybe there is something wrong.

can someone give me any advice?

thanks a lot.

Judy

[Former Member · Accepted solution]

Dear Judy,

table COFP, which is the basis of transaction CJIA, has two fields concerning the related documents from the FI. These are BELNR1 and BELNR2.

Generally BELNR1 contains the document number of the clearing document and BELNR2 contains the source FI document number which refers to the Project Cash Management document.

In CJIA both are named as 'Document Number'. So you should ensure that both are selected, then you should see the document number of the clearing document as well in case of a paid invoice with value type '57'.

Best regards,

Dirk

[Former Member · Accepted solution]

thank you very much, Dirk.

i find the document no. for MIRO and the document NO.for payment clearance as well.

i think it is correct, though it looks wierd.

thank you for your help and explanation.

Judy

[Former Member · Accepted solution]

just one more question.

how can i get to know the table. i know little about it.

if next time, i meet some other problem, how i can know the table.

thanks alot

Judy

[Former Member · Accepted solution]

Dear Judy,

note 495088 contains an overview which database table is used for the relevant line item report.

Best regards,

Dirk