EBS configration doubt

[Former Member]

Hi Experts,

I am doing Electronic Bank Statement upload by using BAI File format. I have 3 main accounts. 1st main account contains 6 Sub accounts ,2nd main account contains 8 sub accounts and 3rd main account contains 5 sub accounts.

This is my sample file Format. 1 main account has 5 sub accounts.

01,032000060, T_USER,080730,1629,276,,,2/

02,T_USER,CHOPCTTXXX,1,080729,1629,,2/

03,0130023526,JPY,010,0,,,015,0,,,040,0,,,045,0,,,050,0,,,055,0,,,072,0,,/

88,074,0,,,075,0,,,100,107242800,7,,400,107242800,2,/

16,195,62836097,S,62836097,0,0,T14LCIC047121,/

88,BENEFICIARY2=0005150,B|O CUSTOMER=ASUMO(KA,PAY METHOD=INCOMING MONEY,BENEFIC

88,IARY= KAISHA,REC FROM=0005150,BENE ACCOUNT=000130023526,PAY

88,DET=00X7847175000000C181TEXT:1 0 5 HUA BE1 0 HUA

16,206,42389119,S,42389119,0,0,T14LCIC047120,/

88,BENEFICIARY2=0005150,B/O CUSTOMER=ASUMO(KA,PAY METHOD=INCOMING MONEY,BENEFIC

88,IARY= KAISHA,REC FROM=0005150,BENE ACCOUNT=000130023526,PAY

88,DET=00X7846967000000B167

16,495,1260000,S,1260000,0,0,T14LCIC047134,/

88,BENEFICIARY2=0161241,B/O CUSTOMER=O-SERAKA,PAY METHOD=INCOMIN

88,G MONEY,BENEFICIARY= KAISHA,REC FROM=0161241,BENE ACCOUNT=0

88,00130023526

16,575,429570,S,429570,0,0,T14LCIC047122,/

88,BENEFICIARY2=0005150,B/O CUSTOMER=YOKU(KA,PAY METHOD=INCOMING MO

88,NEY,BENEFICIARY=KAISHA,REC FROM=0005150,BENE ACCOUNT=00013

88,0023526,PAYDET=4437

16,206 ,210000,S,210000,0,0,T14LCIC047146,/

88,BENEFICIARY2=0005150,B/O CUSTOMER=KA) DENSO,PAY METHOD=INCOMING MONEY,BENEFI

88,CIARY= KAISHA,REC FROM=0005150,BENE ACCOUNT=000130023526,PA

88,YDET=00X5580305000000B357

99,507467195597,6,821/

For this I did the configuration like following

1. I have created one house bank (3000) for this main account 0130023526 and created 5 sub accounts (195,206,495,575,206) under main account 0130023526 like following with different GL account number.

Housebnk Acc.ID Bank Account short id

3000 1111 0130023526 Global fund transfer credit

3000 2222 0130023526 Foreign Bank Transfer Credit

3000 3333 0130023526 Global fund transfer Debit

3000 4444 0130023526 ZBA account debit

3000 5555 0130023526 Foreign Bank Transfer Credit

_____ _____ __________________ __________________________________________________

_____ _____ __________________ __________________________________________________

Please refer the BAI file content & my configuration .Can you please tell me whether is configuration is correct or not. After created the house bank directly I started to do the following configuration

Configure Global Settings for EBS (IMG)

- Create Account Symbols

- Assign Accounts to Account Symbols

- Create Keys for Posting Rules

- Define Posting Rules

- Create Transaction Types

- Assign External Transaction Types to Posting Rules

- Assign Bank Accounts to Transaction Types

Can you please tell me whether is configuration is correct or not to proceed further. Please help me

Thanks

Kelvin

[Former Member]

This message was moderated.

[Former Member]

hi

plz refer at

http://srilogix.com/casesWhitepapers/Electronic%20Bank%20Statement.pdf

thanks

Srilaskhmi

[Former Member]

Hi Sri,

I refered the link which you have mention. That example contains one main account has one sub account..So i can understand the configuration part.

But for my requirement One main account has 5 sub accounts..Thats what i want to the configuration part..Please help me

Thanks

kelvin