Auto clearing AR line items from the bank statement on amount

[Former Member]

HI All,

Our customers often pay for multiple invoices in one payment document, and the reference they put on the payment is their customer number.  Current configuration posts the amount directly to the customer account, and request that the users select the line items to clear. 

Is it possible to automatically sort the open items on the customer account by oldest first and match them off based on the amount, so for example, if a customer pays their oldest 5 invoices in one payment, SAP will automatically match them all off?

thanks

Phil

[Marssel700 · Accepted solution]

Hi,

Do you want select older customers invoices and clear against bank clearing account automatically? This isn't a standard procedure. You can only do that by new development or user exit.

regards

[Former Member · Accepted solution]

Hi,

many thanks for your quick response.

yes we want to select the open items by oldest first and clear automatically

Would this be a customer specific "interpretation algorithm" to be applied in the config step "make global settings for Electronic Bank Statement"?

Many thanks

Phil

[Marssel700 · Accepted solution]

Hi,

May be the number 29 can work.

please check the algorithms list

http://help.sap.com/saphelp_46c/helpdata/en/43/0bd56743de11d1896f0000e8322d00/content.htm

Anyway you will need a Exit because you must define a order number according EBS selection data.

Unfortunately there isn't standard tool for get it done.

Regards

[former_member188063]

Hi Philip, you can achieve this through an User Exit talk to your Abaper he should be able to help you out.

Regards,

Sudhakar*

[Former Member]

Hi Sudhakar,

Would this be a customer specific "interpretation algorithm" to be applied in the config step "make global settings for Electronic Bank Statement"?

thanks

Phil

[Former Member]

Hello Philip,

I dont think the Custom Specific Interpretation Algorithm will solve your requirement. I think the ABAP development needs to come at the place where FB05 transaction is called internally, so ideally here we need to write the ABAP code for passing the required open items based on the oldest date.

Check the attached screen shot for FB05 selection of open items.

Regards

Srikanth

[former_member190652]

Hi Philip,

May I know how did you satisfy this requirement.  Because now I too have same requirement from business.  It would be great if you could share your solution.

Thanks and Regards,

Sridhar

[Former Member]

I never did resolve this one!  I no longer work at that client so will mark this question as closed.

At my current role, the client uses an external piece of software called Alloc8 which has some complex algorithms and can allocate payments to open line items quite well.

best of luck!