AUTOMATIC matching _ AR/fico

[Former Member]

Hi All,

I am working for Client - A global Consumer Durable Company spanning all the 7 continents, I need some inputs from SAP gurus like you, for automatic matching of remittances advices .

Customers send the details of Debit Notes, Remittances details, credit Notes details in a single form by email and also on paper (hard copy posted to the client) in different formats:

• Excel sheets

• PDF Forms

• Html pages

• Paper form (Customer Specific debit note format that is sent by post to the company)

The requirement is do an

1) Automatic matching for clearing of open items and credit notes … sent electronically not necessarily be by an EDI file ( as mentioned in the above formats ,and these formats differ from each customer ) and

2) POST the debit notes into system which triggers workflow and clears the debit note( after approval) and charge back to customer if not approved

My questions are

1) How to convert this different forms of remittances advices sent by customer into a readable format in SAP( any other software can do that ?)?

2) OK, if it is in readable format by sap how to differentiate the Debit notes issued by the customer and credit notes issued by the company, cos both these documents have negative sign( - Minus)?

Suggestions and Advices are highly appreciated.

Thanks

Sashi Kanth K

[Former Member]

answered

[Former Member]

You need to look at payment advices and the use of IDOC's.

However a single Remittance advice can only have 950 line items to clear.

[Former Member]

Hi Mark,

thanks for the reply, can you explain in detail.. yes i am aware of the fact that single Remittance advice can only have 950 line items to clear. ..

Can you explain

1) How to convert this different forms of remittances advices sent by customer into a readable format in SAP( any other software can do that ?)? one customer sending in excel, one in pdf one in text and that too not in particular Templet and Moreover if it is received in as an IDOC, how can a debit note no sent (customer generated no) differentiated and cleared automatically ..

Your help is higly appreciated

thanks

[Former Member]

OK

I think you will need to convert all of your other source data to a common format.

The remittance advice can create the debit note.

I have done something like this for a very large Company, where we did not use Payment Advices, and just used F.13 to clear. All of the docs that were being cleared we added a common value to a certain field and then we created the debit note for them as a journal to the customer, i.e. 100 DR &CR with the DR value having the customer's number in a different field to the common clearing field.

[Former Member]

Hi Mark,

I have worked for 4 years in SAP FI in Production support/ Application maintenance environment , I am new to implementation process and facing these challenges, I would be great full if you can some links or documentation / information which I can refer to and work on.....

In the mentioned scenario, challenge is how to convert the other source data into common format... is this can be achieved through intelligent scanning (just a stupid idea), kindly suggest.

Your help is highly appreciated!!

Thanks once again!

BR

[Former Member]

You will need to look at each customer's remittance and create a rule set to convert the data into the common format.

However before you embark on this, I would suggest that you analyise your customers and their remittances.

Where I did this before, it was only done for 80 customers out of 20,000.

The 80 customers have monthly remittances that were between 500 and 25,000 lines.

If you are considering implementing this for ad hoc customers or remittances that are not that great the effort wont outweight the benefit in reduction of manual effort.

Also consider, what they pay, does a customer pay all open items every month, if that is the case, you can select those invoices easily in F-32.

OCR is a useful tool, however it will be expensive to implement, and you will probably need a minimum of 20 customers to use this every month for it to pay back.

Hope this is of some help, please award points if this has been useful so far

[JozsefSzikszai]

"spanning all the 7 continents"

according to studies there are only 6 continents, of course you can count America as two, but do they really operate on Antarctyca as well?

[Former Member]

Hi,

Spanning across the world may be … an over statement……