Automatic Clearing of Customer Open Item not happening on EBS file upload

[Former Member]

Hi Experts,

When I am trying to upload an EBS file, Automatic clearing of customer open item is not happening.

The file contains the invoice number in tag :86:.

The requirement says that the open item should be matched

based on this invoice number in the Tag 86.

But this is not happening.

I have checked the Global settings for EBS.

The interpretation algorithm maintained for External Transaction Type NTRF is "19 Reference Number : DME Management."

My understanding says, issue is with the Algorithm. (Don't know if I am correct)

Please help me on this.

Regards,

Nilesh Sinha 

[gaurav_agarwal01]

Hi Nilesh,

I see that you want to clear the open line based on Invoice number, so is this the FI document number? If so, please use algorithm '001' or '020'.

Regards,

Gaurav

[Former Member]

Hi Experts,

When I am trying to process the customer open Item by F-28 tcode

getting the following error:

Profitability segment being derived again

Message no. KI350

Diagnosis

You have assigned an profitability segment with the auxiliary account assignment  PrCtr 7XXX. The profitability segment, however, contains the characteristics  PrCtr 1XXX.

Could you please advise, where to check and how to rectify this error ?

Regards,

Nilesh Sinha 

[former_member193513]

Hi Nilesh

What is the base for clearing the customer line items using your EBS files

You use this algorithm 19  to import those account statement line items that relate to a previous payment run. All the items for a payment medium generated by the payment program are summarized by means of a DME (data medium exchange) reference number. Your house bank confirms the overall total for the line items, together with the DME reference number. The algorithm finds the DME reference number in the note to payee lines in the account statement. The reference number is used to find and clear all the line items in the system

Genrally we will keep algorithm 01 or 020 or 021 to identify the document numbers or reference document numbers in the note to payee filed to clear the invoices using EBS upload

If you are getting either document number or reference  document number in the 86 record, then I would suggest you to use the 01 or 020 or 021

Hope this helps you

Regrads

Prasad

[Former Member]

Hi Prasad,

I tried using algo 21, but still the line items are not getting cleared automatically

on uploading the EBS file.

I tried using ALgo 26 also , but everythime the same error is coming.

PFA the error screen shot.

Please help regarding this.

Regards,

Nilesh Sinha

[Former Member]

HI Nilesh ,

There are lost of document on this please below some of them .

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d2f203-4959-2e10-239f-bce48eef8...

Electronic Bank Statement - ERP Financials - SCN Wiki

Many Thanks

Regards