normal bank statement format to multicast format

[former_member191564]

Dear all

how to convert a normal bank statement format to multicast format

thank S IN ADVANCE

[former_member191564]

thanks for all

Am Closing this issu

[Former Member]

Hi,

Use Tcode FEBC for generating Multicash format for the bank statement.

Select the appropiate program for processing your bank statement.

Regards

Arun

[former_member209616]

Hello

The online version of a bank statement is not the format that you would be interested in as it appears in an user friendly way. The bank uploads files in particular formats. Now there are various formats and banks are capable of providing then. There could be MT940 formats FINSTA formats or many others.

So you need to talk to the bank as to what format they can offer you with.

Rgds

[former_member191564]

Dear expert

Book Date Description Ledger Balance Credit Debit Value Date Reference No Transaction Branch

01/10/2011 Opening Balance 16345213.47

01/10/2011 CMS-METROPOLIS-111001000001/BOD 1639257.92 01/10/2011 0 CHANDIVALI

01/10/2011 Chq Pd-MICR Inw-S R S COURIER SERVICE (200,523.00) 01/10/2011 28182 MUMBAI CLE

01/10/2011 Chq Pd-MICR Inw-C S PRAJAPATI (12,025.00) 01/10/2011 27706 MUMBAI CLE

01/10/2011 Chq Pd-MICR Inw-SHRI SAI PLASTIC (28,100.00) 01/10/2011 26828 MUMBAI CLE

DO U KNOW WHAT IS THIS FORMAT

[former_member318765]

Hi Ajeeshsudevan,

This looks like Bank's own format. Please check with them as they are the right people to provide you information on the exact format in which they are sending the file.

Please review note 13283 which may be helpful to you..the mentioned tool, BCS Software (Bank Communication Standard), in the attached note 13283 is not a tool which is standard provided by SAP.

You can create a program which creates a files in the Multi Cash format (see note 36833 for Mutli Cash format).

Also beginning with release R/3 Enterprise there is the additional possibility, to read incoming files in the DME engine (transaction DMEE, tree type MCSH). Using this the customer can map other formats for bank statements to MULTICASH format and has the possibility to clear his accounts using a standard report.

Hence for any additional format, you can use the transaction DMEE, using the tree type MCSH you can convert the own format to a multicash format. You should define this format as per your requirement. Please see SAP help for further information on this.

Hope the above information helps

Kind Regards,

Soumya

[Former Member]

Hi

Go to FF_5

There select Multicash format - AUSZUG.TXT(Header Info) and UMSATZ.TXT(Line Item)

Regards

Sridhara Rao D

Edited by: Sridhara Rao.D on Oct 20, 2011 8:44 AM

[former_member191564]

This message was moderated.

[Former Member]

Hi

AUSZUG.TXT is for Header information of the statement like Customer ID, Customer Name, Account No., Account Category (SB) etc.

UMSATZ.TXT is for line item information like date, transaction partiuclars, amount etc.

The above 2 are available with Electronic bank statement format : Multicash format (AUSZUG.TXT and UMSATZ.TXT)

Go and check T code - FF_5

Regards

Sridhara Rao D

[Former Member]

Hi

Pls elaborate.

Regards

Sridhara Rao D

[former_member191564]

hiihi

here am going to implement EBS.our bank is HDFC bank .i checked there bank statement it is not in the format of multicash.its something other format which is not recommended by sap.