AUTOMATIC matching _ AR/fico

122 Views

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