cancel
Showing results for 
Search instead for 
Did you mean: 

EBS -automatic clearing with single amount in BAI file against multiple vendor payment documents.

former_member605383
Discoverer
0 Kudos

Hi All,

we have a requirement for one our client that three diff taxes will be directly debited from bank account and we will receive BAI file from bank with consolidate amount.

as per the business need each tax is created as tax vendor in sap.

so we post open item in single document with 3 vendors, and we do payment run sap, which is a dummy run we will not send any payment instruction to bank because amount is directly debited from bank.

Now we have a issue for clearing bank accounts

as we posted to 3 different vendor accounts system is creating 3 separate payment documents in payment run and in BAI file we receive one consolidated with a reference number?

how we do clearing against 3 payment documents with one amount in BAI file.

Please provide your advice.

Regards,

sarala

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member605383
Discoverer
0 Kudos

Hi Sanil,

Thanks for your suggestion

I have checked the blog which you have shared

we will not send any payment information to bank either dme reference number also.

but we will receive one unique DI# number (declaration of imports) in bai file as reference number.

now our challenge is can we include that DI reference number in payment documents at the time of F110 run

so that we can do reconciliation?

Regards,

sarala.

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi

In your case, you can do the below steps:

1. Through EBS, make an "On Account Posting" without clearing, so that EBS does not fail. This will create the below accounting entry:

Outgoing Payment A/c Dr

To Main Bank A/c

2. Now when the On Account posting has been done, than in the payment run you will have the below entries:

Tax Vendor A/c 1 Dr

To Outgoing Payment A/c

To Outgoing Payment A/c

To outgoing payment a/c

3. Now in FBL3N, do a mass change and update the assignment field (ZUONR) with the reference no (DI No ) in your case.

4. Now maintain ZUONR as a clearing parameter for your GL Account for Main Bank A/c as shown

5. Now schedule a back ground job for T Code F.13 for this GL account. Based on ZUONR, the open items for EBS and Payment run should get cleared, if the ZUONR is identical

Thanks & Regards

Sanil

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi

The below blog should be able to help you coming up with a solution

https://blogs.sap.com/2013/12/11/ebs-autoclearing-process-for-multiple-ach-payments-in-sap/

Thanks & Regards

Sanil Bhandari