cancel
Showing results for 
Search instead for 
Did you mean: 

Manual Bank Statement: saved & posted without errors but no FI doc

Former Member
0 Kudos

Hi,

I entered details for manual bank statement to clear a vendor payment.

The transaction used was "003- Cashed Check", which has interpretation algorithm "021 Reference document number search". I've read in another Forum thread that this interpretation algorithm searches for the data stored in the Reference field of the payment document. So I entered the same data in the Bank Reference field in the manual bank statement.

The system did not throw any error, so I saved the bank statment and consequently posted. The status of the statement is "Manu. Posting complete".

As far as I understand, when the statement is "posted", an FI doc will be automatically posted with the following entry:

DR Bank Check outgoing

CR Main Bank Account GL

However, I cannot see this posting in both the Main Bank Account and Bank Check outgoing GLs.

Am I missing any step? Or is the config wrong?

Hoping for your guidance. Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

Just check your customization once in

IMG>Financial Accounting > Bank Accounting>Business Transaction>Payment Transaction>Manual Bank Statment.

Invoice

db-exp acc

cr-vend acc

Payment

db-vend acc

cr-outgoing payt

Clearing Sub bank Account.

db-out payt

cr -main bank acc

Hope this Will Be Helpfull

Regards

Former Member
0 Kudos

Yes, the entries are correct.

Below is the setup I did. Should I change the Posting Type?

Create & Assign Business Transactions

1) Transaction: 002+

Sign of the incoming amount: +/positive

Posting rule: 002+

Account modification: + (what does this do?)

Interpretation algorithm:

Text: Check credit memo through bank

2) Transaction: 003-

Sign of the incoming amount: -/negative

Posting rule: 003-

Account modification: + (what does this do?)

Interpretation algorithm: 021 Reference document number search

Text: Cashed check

Define Posting Keys & Posting Rules

Create Account Symbols

SCHECKAUSGANG Outgoing checks

SCHECKEINGANG Incoming checks

Assign Accounts to Account Symbol

1) Account Symbol: BANK

AcctMod: +

Currency: +

GL Acct: ++++++++++

Desc: Bank account

2) Account Symbol: SCHECKAUSGANG

AcctMod: +

Currency: +

GL Acct: +++++++++1

Desc: Outgoing checks

3) Account Symbol: SCHECKEINGANG

AcctMod: +

Currency: +

GL Acct: +++++++++6

Desc: Incoming checks

Create Keys for Posting Rules

1) Posting Rule: 003-

Text: Cashed check

2) Posting Rule: 002+

Text: Check deposit

Define Posting Rules

1) Posting Rule: 002+

Posting area: 1

Posting Key: 40

Account (Debit): BANK

Posting Key: 50

Account (Credit): SCHECKEINGANG

DocType: SA

Bank Statement-Posting Type: 1 Post to G/L account

2) Posting Rule: 003-

Posting area: 1

Posting Key: (blank)

Account (Debit): SCHECKAUSGANG

Posting Key: 50

Account (Credit): BANK

DocType: SA

Bank Statement-Posting Type: 4 Clear debit G/L acct

Former Member
0 Kudos

Problem solved.

I had to process the batch input session, and changed the Posting Type of 003- to 1 Post to GL.

Former Member
0 Kudos

Hi ,

I am facing same errror.

currently document was posted but no fi doc created automatically just showing doc no *.

when trying to posting using FEBP, no data selected.

Anyone has idea how to create fi doc for this ?

thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Please check you posting rules once again defined in customization.