Manual Bank Statement Automatic Clearing
I am facing problem at the time of automatic clearing of Bank Accounts.
Let me explain the scenario.
FB60 - Posted invoice
Expenses A/c Dr 100
Vendor A/c Cr 100
F-58 - Payment and Cheque assignment
Here the payment document picked up the assignment as 20080923 (Sort key is posting date for bank sub account)
Vendor A/c Dr 100
Bank Sub A/c Cr 100 (Assignment is 20080923)
FF67 - Enter bank statement, but the assignment picking up is 0000014800001 (combination of FEBKO-KUKEY Sort Key and Statement Number)
Bank Sub A/c Dr 100 (Assignment is 0000014800001)
Bank Main A/c Cr 100 (Assignment is 0000014800001)
When I run F.13, not able to clear the line items in the Bank Sub Account, as the Assignments for debits and credits differ.
It force me to clear the accounts manually through F-03. If there is a single bank account then I can use F-03, but my bank statement contains number of bank account numbers for each house bank.
My configuration for automatic clearing for GL Accounts is based on ZUONR (Assignment).
Please let me know how can clear the bank sub account postings based by running F.13
Your valid inputs will be highly appreciated.
Thanks in advance,
Edited by: Ravi Sankar Venna on Oct 1, 2008 9:39 PM