RE-FX Error in accrual [RERAALCN]

[Former Member]

Dear All;

i need help when posting the periodic Accrual run of the automatic accruals;

i transfer the revenue of a rental contract using the transaction RERAALCN. I obtain only this error

........................................................................................................................................................................................

Account determination could not derive field 'Target Account' for RSRE / AR150 / I / 0010 / 31.01.2010 (No Data Available) (No Data Available)

Message no. ACE104

Diagnosis

The Accrual Engine account determination could not derive the field Target Account.

System Response

The following data was transferred to the account determination:

Accounting principle/accrual type/transaction/chart of accounts/date:

RSRE / AR150 / I / 0010 / 31.01.2010

The following data was also transferred:

(No Data Available)

This data has the format defined in a specific DDIC structure. The name of this DDIC structure is in Customizing for the Accrual Engine in the activity "Make Settings for Components" (view V_TACECOMP): This is the content of the field "Source Fields".

(No Data Available)

This data is also in the format of a DDIC structure. The name of this DDIC structure is also in Customizing for the Accrual Engine in the activity "Define Customer Settings for Components" (view V_TACECOMPC): This is the content of the field Source "Fields".

.............................................................................................................................................................................................

For the component RE of accrual deferral I use in the IMG activity Customer Settings for Application Components I use source field REEX_PAYMENT_FI_S because I need to use the field Account determination key.

the derivation rules that I configured are:

1. Document determination

Source field:

Accrual Type

Target field:

Document Type

2. Account determination

Source Fields:

Accounting Principle

Transaction in Accrual Engine

Accrual Type

Account Determination Value <-- customer field

Target Fields:

Start Account

Target account

I know that it is necessary to use entry contained in the PARAM_NAME field of ACEDSOP but in my case is empty.

How can I do?

Regards

Sarah

[CPalzenberger · Accepted solution]

Hello together,

the account determination value of RE-FX is not known in the ACE and that's why you have to use a BAdI (BAdI ACEPS_BAPIPREDOC_MOD of the ACE) to achieve it before posting the accrual/deferral. Here's an appropriate example coding that can be used to do so:

METHOD if_ex_aceps_bapipredoc_mod~bapipredoc_modify.

TYPE-POOLS: retm1.

• is_acedocitem

• cs_BAPI_PREDOC

DATA: ls_items TYPE aceps_bapi_prelineitem,

lt_term_payment TYPE bapi_re_t_term_py_int,

ls_term_payment TYPE bapi_re_term_py_int,

ls_ace_ex_objkey TYPE ace_ex_objkey,

ld_objnr TYPE recaobjnr.

• get ACE data

CALL FUNCTION 'ACE_READ_ACCRUALS_ALLDATE'

EXPORTING

id_comp = 'RE'

id_bukrs = is_acedocitem-bukrs

id_objid = is_acedocitem-objid

id_subid = is_acedocitem-subid

IMPORTING

es_ace_ex_objkey = ls_ace_ex_objkey

EXCEPTIONS

not_found = 1

system_error = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4

RAISING error_occurred.

ENDIF.

• accrual object (RE object)

ld_objnr = ls_ace_ex_objkey-ref_key.

• get contract data

CLEAR lt_term_payment.

CALL FUNCTION 'API_RE_CN_GET_DETAIL'

EXPORTING

id_objnr = ld_objnr

id_detail_data_from = is_acedocitem-effdate

id_detail_data_to = is_acedocitem-effdate

IMPORTING

et_term_payment = lt_term_payment

EXCEPTIONS

error = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4

RAISING error_occurred.

ENDIF.

CLEAR ls_term_payment.

LOOP AT lt_term_payment INTO ls_term_payment

WHERE termno = retm1_termno_default.

EXIT. " from loop

ENDLOOP.

IF ls_term_payment-accdetkey IS INITIAL.

• no account determination value found

RETURN.

ENDIF.

• change field GL_ACCOUNT in lines of table CS_BAPI_PREDOC-LINEITEMS[]

• according to account determination value...

• ...

ENDMETHOD.

This example coding for the method BAPIPREDOC_MODIFY of the BAdI that determines the account determination value of the contract by using the acrrual/deferral data. You could then determine the account from the former account GL_ACCOUNT and the account det. value and overwrite it afterwards.

Hope this helps!

Regards,

Christian

P.S. The format of the coding is not taken over correctly in this forum. Sorry for that

[Former Member]

Did you get an answer to your problem. I am having the same problem. Please share.

the derivation rules that I configured are:

1. Document determination

Source field:

Transaction in Accrual Engine

Target field:

Document Type

2. Account determination

Source Fields:

Accrual Type

Accrual Object Category

Transaction in Accrual Engine

Target Fields:

Start Account

Target account

Thank

Prakash