Bank statement post processing - Vendor clearing with account type 'D'

[cline_jomard-ek]

For the manual bank statements (electronic also), we set a posting rule for manual vendor payment.

It was defined in two steps:

1          Transit bank account / Bank account, posting type 1

2          - / Transit account, posting type 7

The algorithm for determined the vendor is the standard algorithm. It works in the most cases fine.

When the post processing of the bank statement is needed (vendor or amounts not found for example), the second step is to be done manually. But when the transaction for the clearing of the vendor opens, in order to enable the user to enter the vendor number, the first screen is always open with account type 'D' (for customer) instead of 'K' for vendor.

Is it a way, that the default value is set to 'K' ?

Thanks in advance for your reply.

Céline

[Former Member]

Hi All,

I am having the same issue,when trying to update posting area 2 in FEBAN it defaults to Account type D and error Customer 1234 is not  defined in company code ab. where 1234 is a vendor no. and we are using posting key 25 to clear vendor.

Thanks

Gaurav

[Former Member]

Resolved the issue by following the below steps :

1) In search string definition leave the target field blank

2) In search string use provide Target field - Acc Type, Mapping Prefix K

3) Then create another search sting using the same name Target Field - Account number, Mapping Prefix Vendor no.

[cline_jomard-ek]

Thanks for your help.

the problem is my customer use the manual bank statement and I can not use the search string in this case.

[Former Member]

Hello Celine,

I am not sure if I understand your quesition correct.

As an instance you call function F-28 for posting incoming payments.

You will use account type = D for posting incoming payments for from your customers.

With function for outgoing payments (F-07) you will use account type = K for your vendors.

Is this what you mean?

Thank you for your answer.

All the best Erwin

[cline_jomard-ek]

Hi Erwin,

I did not run directly any transaction. The posting with clearing transaction is run automatically when you run the post-processing of the bank statement, the transaction FEBAN. When in FEBAN there is an item in error and not posted, you can rerun the posting by clicking on "Save". Then the system open directly on a windows for the account selection, but it is always with Account Type 'D', even if the bank statement rule for posting is defined for vendor (posting type 7).

Is it better clear now ?

Céline

[Former Member]

Hi Celine,

I think I have the same open question, have you found a solution to your question?

However, from my point of view there should be no default to any account type in case of posting type 7 or 8. I can not see where this default comes from.

As to my understanding:

- Posting type 7 clears an open Credit sub-ledger account position (AP or AR) and makes a Debit posting.

- Posting type 8 clears an open Debit sub-ledger account position (AP or AR) and makes a Credit posting.

I would have thought that for AR / AP the posting types should have been similar to the G/L - but for some reason is not.

Ideally we would have had

7a - Clear debit AR acct

7b - Clear credit AR acct

8a - Clear debit AP acct

8b - Clear credit AP acct

Kind regards,

Cristina

[cline_jomard-ek]

I did not find anything indeed and nobody give me oher tips, because as you said, the key are not done to define vandor/customer posting but debit/credit.

Thanks for your reply.

Céline

[cline_jomard-ek]

Any idea ????

[Former Member]

Hello Celine,

Can you provide more details on the issue. It seems like the issue with the posting key being used, however need further details before final conclusion can be made.

Regards

Amitash

[cline_jomard-ek]

Hi Amitash,

Please look at my reply to Erwin if it is enough for you.

Céline