Skip to Content
0
Former Member
Apr 25, 2008 at 06:33 AM

TCode - FF67 - Manual Bank Reco - No open items were found

805 Views

Hi all,

We are getting the above error message on executing TCode - FF67 with the following steps made for the customisation of " Manual Bank Reco " :

1. Create Account Symbol

2. Assign Accounts to Account Symbol

3. Create Keys to Posting Rule

4. Define Posting Rules

There is no Bank Statement available with me since I am doing the testing in " Development Server ". Hence I have posted one entry on 30.03.2008

Elect. Acct...........Dr......Rs.2000/-

To Vendor Acct.... Cr...................Rs. 2000/-

Assuming that Cheque Payment for the above amount has been cleared in UBI (Bank),I have now started executing TCode - FF67

Bank Key - UBI

Bank Account - 17782

Currency - INR

Statement Number - 1

Statement Date : 01.04.2008

Opening Balance : Rs. -22869/- (negative as per system since Bank GL created under liability)

Closing Balance : Rs. - 24869/- (After deducting further Rs. 2000/-)

Posting Date : 31.03.2008

Bank Postings Only - > Selected

Press Enter -> Next Page of TCode FF67

Tran - Value Date - Amount - Allocation (assgn) - Bank Ref

CHOU - 31.03.2008 - Rs. -2000 - Blank - 111

-> Save the data

When I go in TCode - FEBA

I have selected - Posting Area as " G/L Accounting "

and click on Overview, system has shown me “ Red Cancellation Sign “with error message " To be posted " for Transaction " Y101 "

Further in same screen I have selected - Line Items -> Post. I got a window "Post with Clearing : Header Data", I went on entering for further steps till I received a message " No appropriate line item is contained in this document "

Giving details of Posting Rules – Y101 for reference :

Posting Rule - Y101

Posting Area - 1 (Bank Acctg)

Debit :

Posting Key - <Blank>

Acct Symbol - CHECKOUT

Credit :

Posting Key - 50

Acct Symbol - MAINBANK

Document Type - KZ

Posting Type - 4 (Clear debit G/L acct)

Also giving Business Transaction setting for “CHOU” which is as follows –

Tran +- Post Rule Acct Mod Int Algthm Text

CHOU – Y101 Blank 11 Check issued out

Giving specification details used in Tcode - FF67

Import Advices -> Selected

Start Variant -> ZGSML – created separated

Cust. Matchcode ID -> D

Vendor Matchcode ID -> K

Processing Type -> 4

Transfer Value Date -> Selected

If anybody has a solution on this that will be highly appreciated.

Points will be assigned to proper answer.

Regards,

Shridhar Sawant

FICO

Edited by: Shridhar Sawant on Apr 25, 2008 4:16 PM