Electronic Bank statement - Error in Batch input log for session

[Former Member]

Hi Everyone,

The Bankstatement was read from a Job which exectues daily. Then from the tcode FEBP, the bank statement was updated. In the transaction FEBA the document numbers are displayed as '*'. After refererring to the thread http://scn.sap.com/thread/1951835  and looking into the note 549277. I have assumed that they have accidently created Batch input sessions instead of posting immediately. There were sessions(each session for each account and then each for General ledger and sub ledger ) created in transaction SM35 with that username. When I have processed the sessions, for all the accounts the document numbers are generated and can be looked in FBL3N tcode. But for one session which was created for subledger accounting, the sessions is going into errors and the error log says "" The difference is too large for clearing"".

Please help me further by guiding me how to process the session of this particular subledger accounting?

Thanks and Regards,

Lakshmi.

[Former Member · Accepted solution]

Hi Lakshmi,

One quick question.

Are you also using sub ledger posting area(02) for EBS?

Check your posting rule via OT83 and let me know.

Regards

Kalim

[Former Member · Accepted solution]

Hi Kalim,

Thanks for your quick reply. Yes I have checked  in tcode OT83 and found that posting area 02 was used in Posting rules. Please find the screenshot of the same.

Lakshmi.

[Former Member · Accepted solution]

Hello Lakshmi,

This is standard behavior of the system, if you are using posting area 2(Sub ledger) then system is started to search open invoices of customers/vendors to clear this sub ledger(once you execute the transaction in background) if system don't find any open item then create a batch session in SM35 with error.

Steps to follow

Check external transaction code for sub ledger account with respective posting area in OT83.

Check same external transaction code in your EBS file( same Ext code is there or not on that day).

If that code is not in the EBS file then delete or leave that batch input session, it will not impact any transaction.

Feel free to inform me if you have any question.

Regards,

Kalim

[Former Member · Accepted solution]

Hi Kalim,

Thanks a ton for your quick replies.

I am quite new to FI, I have the following questions.

1. Why are batch inputs created only for that particular day. Is it because that they have accidently selected generate batch inputs in FEBP, or any other reason behind it?

2. Check external transaction code for sub ledger account with respective posting area in OT83.- Can you please elobarate a little more on it. I have selected Create Transaction Type- There all the transaction types are avilable. How do I need to opt for subledger account?

3. If that code is not in the EBS file then delete or leave that batch input session, it will not impact any transaction.- Actually now in production we have sessions created for General ledger and subledger. Then a similar scenario is recreated in Quality by selecting Generate Batch Input(assuming that end users have done so..) and processed the sessions in Quality. The Subledger of this account went into error. But if I leave the session how does the books gets effected. What about the postings?. In FBL3N there is no successful posting for Subledger accounting? How can this be corrected or processed.

4. In the Subledger accounting, Inorder to verify the incoming and outgoing payments will it be okay, if i generate an open invoice for vendor and do payment run and create a test bank statements. Similarly create an open invoice for customer and clear with bank statement by creating a payment lot?

Thanks in advance!

[Former Member · Accepted solution]

Hi Lakshmi,

Please find requested points.

1. Why are batch inputs created only for that particular day. Is it because that they have accidently selected generate batch inputs in FEBP, or any other reason behind it?

                  Yes, it is due to selection of batch input in FEBP.

2. Check external transaction code for sub ledger account with respective posting area in OT83.- Can you please elaborate a little more on it. I have selected Create Transaction Type- There all the transaction types are available. How do I need to opt for sub ledger account?

       As per your above screenshot posting rules 0001 and 0003 belong to sub ledger posting.

      Check your posting rules(0001 and 0003) with which External codes have been mapped in OT83.

3. If that code is not in the EBS file then delete or leave that batch input session, it will not impact any transaction.- Actually now in production we have sessions created for General ledger and subledger. Then a similar scenario is recreated in Quality by selecting Generate Batch Input(assuming that end users have done so..) and processed the sessions in Quality. The Subledger of this account went into error. But if I leave the session how does the books gets effected. What about the postings?. In FBL3N there is no successful posting for Subledger accounting? How can this be corrected or processed.

Check same codes are available or not in your EBS file for that day.

This is BAI format. Your file format might be different.

If they are not in the file then no posting will happen for sub ledger account.

4. In the Subledger accounting, Inorder to verify the incoming and outgoing payments will it be okay, if i generate an open invoice for vendor and do payment run and create a test bank statements. Similarly create an open invoice for customer and clear with bank statement by creating a payment lot?

No need to clear an open invoice to bank clearing account in sub ledger posting, system will clear that open invoices once you import EBS file in the system.

Hope it is clear.

Kind Regards,

Kalim

[Former Member · Accepted solution]

Thanks Kalim not just for ur solution ut for ur kind explanation:-). Worked perfect.