Skip to Content
0
Aug 21, 2023 at 01:32 PM

replicating clearing information to CFIN - 3rd party solution

117 Views

Hi Experts,

we have the 3rd Party solution for a customer in which we upload FI data through SLT to CFIN.

I am having issue with replicating the clearing item though.

we are using the attached Excel Template.

I filled the CLEARING DATE and INVOICE REFERENCE (BKPF-AWKEY)= AWKEY of the original Document to be cleared.

I also filled the CF_E_CLRITM Segment as well. The clearing items get posted with the AIF Info message:

"Reference key CF3P, QA3CLNT350, 2788/4060000514/ already exists, clearing process restarted."

but the original FI Item doesnt get cleared.

lets look a concrete example:

I have an Creditor Invoice with 2 lines:

Source Doc. Number:

4060000514

FISCAL YEAR = 2022

AWKEY = 2788/4060000514/

I now have the clearing with exampel same lines but opposite D/C sign.

CF_E_HEADER:

CLEARING DATE = 18.08.2023

AWKEY = 2788/4060000514/

CF_E_CLRITEM: 2 lines

OPEN_ITEM_DOC_NO = 4060000514

OPEN_ITEM_FISCAL_YEAR = 2022

CF_E_CLRITM - OPEN_ITEM_ITEMNO_ACC = 001 & 0002

CF_E_CLRITM- OPEN_ITEM_DOC_LINE_NO = 001 & 002.

question is why it doesnt clear the posted FI item (2788/4060000514) in CFIN