Skip to Content
avatar image
Former Member

Bank Reconciliation and Customer Invoice Clearing

Hi Experts,

I have a requirement in Electronic Bank Reconciliation, when statement has customer incoming payment then system should post payment entry as well as an entry to Main Bank Account.

In Assign External Transaction OT83 how can we built a logic where if Customer Account is appearing in Line86 of Bank Statment, payment entry should be posted to the respective customer since Customer Account appears as blank while posting/clearing while if I get document number in Line 86 the same gets cleared automatically in FF_5 if we enter BELNR in Algorithms section.

Thanks,

Rahul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 04, 2015 at 08:24 AM

    Hi,

    Do you mean below:

    Invoice posted

    Debit Customer (1)

    Credit Revenue

    Bank statement comes in

    Credit customer (clear against (1) automatically )

    Debit Main bank

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Using the customer code to search is not supported by the standard interpretation algorithm.

      For us, we use the invoice number to search the customer invoice for the second entry.

      In the OT83 posting rule, please indicate the algorithm as '20', in the posting rule area 2 config,

      please enter

      Debit, the bank clearing and leave the credit side as blank.

      Indicate posting type as 8. (clear the credit side sub-ledger).

      Please note when you run the FF_5, please indicate the range of document number

  • Nov 04, 2015 at 10:21 AM

    Hi,

    Please use search string functionality (target field: BDC) and get the customer number.

    You may please search the search string WIKIs for more information on how to use the BDC target fields.

    Regards

    Shanid

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2015 at 01:51 PM

    HI All,

    In my notes field I only have Customer Account number and no Accounting document number, so is there any solution or is it possible to derive by maintaining some logic in algorithm .

    Thanks,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded