Incorporating cash availability from bank statement load to Cash Management

[former_member293658]

Hello Friends,

We are receiving daily bank statements in BAI file format from our bank. The BAI statements include 'S' records and 'Z' in the detail line 16 row. The 'S' records show the availability of a cash balance amount: for example a cash balance of 100K is shown with same day availability 70K, 1 day availability 20K and 2+ days availability of 10K.

That means 70K of the cash is available today, 20K is available from tomorrow, and the remaining 10K is available the day after tomorrow.

We need to be able to show this cash availability on SAP in the Cash Position Worksheet in order to give a true view of out cash position.

We load the statements via transaction FF_5. We have seen that program RFEKA700 contains code which handles these S records regarding cash distribution availability. However, when the records are loaded and posted via FF_5 the resulting document posted in FI does not have a breakout of the cash balance by available date. Instead the 100K is posted with a value date equal to fiel load date. There is no further breakout of the cash balance based on the actual cash availability.

Is there a way on SAP to have the system show the cash balance availability shown in our Cash Position Worksheet (FF7A)?

Can you please advise what steps we need to follow to enable this functionality?

Thanks and regards

Mike

[fernando_evangelista]

Hi Mike,

In an Intraday statement, you can use codes such as 070 (0 day float),072 (1 day float), 074 (2 day float), and 075 (3 day float) to present and summarise your float breakdown and create memo records out of these "balances". You may want to adjust the value dates of these summary balances instead of each detail line item.

You can create memo records out of record 3 "07X" balances by setting up the necessary configuration. Here are some of the configuration tables you need: T028B, T028G, and T028L, in addition to planning type, number range for memo record, bank, etc... For this you must have the necessary customizing set up in OT51, OT55 & OT82.

In you BAI file, you should have the the 07X at record 3

Please review your bai file it should look like:

03,1011552091,USD,030,982730,,,060,52130,,,072,883600,,,074,47000,,/

88,100,982730,2,,110,982730,2,,312,+52130,,/

16,115,42000,S,42000,000,000,,00000642165/

16,115,940730,S,10130,883600,47000,,00000642165/

As per the specifications document by the BAI (http://www.bai.org)

Kind Regard,

Fernando Evangelista

[former_member293658]

Hi Fernando,

Thanks once again for your reply and help. If I follow your guidance it looks like our BAI fiile may not be correct:

Our BAI fiel looks like this. The 07X records are not on the 03 record level but instead that detail is only on the 88 record that follows it. An example looks like this:

01,INFORMCD,071923284,111212,0901,09,110,1,2/

02,071923284,071923284,1,111212,0901,,3/

03,8765501126,USD/

88,584,000000000000000,,/

88,585,000000000143568,,/

88,715,000000000000000,,/

88,716,000000000000000,,/

88,777,000000000000000,,/

88,778,000000000000000,,/

16,581,000000000039900,Z,000006392647935,0000171205,/

16,581,000000000081837,Z,000009392669422,0000171238,/

16,581,000000000009175,Z,000009592624863,0000171241,/

16,581,000000000012656,Z,000006492251626,0022171053,/

49,000000000287136,000012/

98,000000000287136,000001,000014/

02,071923284,121000358,1,111212,0901,,3/

03,1233427379,USD/

88,030,000002093638728,,/

88,040,000002063021639,,/

88,057,000000000000000,,/

88,060,000002092875718,,/

88,072,000000000763010,,/

88,073,000000000000000,,/

88,074,000000000000000,,/

As you can see the 07X records are contained in the 88 lines. While I think you are saying that these details should really be on the 03 record line as below:

03,1011552091,USD,030,982730,,,060,52130,,,072,883600,,,074,47000,,/

88,100,982730,2,,110,982730,2,,312,+52130,,/

16,115,42000,S,42000,000,000,,00000642165/

16,115,940730,S,10130,883600,47000,,00000642165/

If I am following you correctly then it looks like we need to check back with our bank in order to get the correct BAI format from them?

Thank you and kind regards

Mike

[former_member293658]

Hi Fernando,

I am coming back to you again in the hope that you may be able to provide us some further guidance. We conferred with our bank and they advised us that there are 2 formats that the BAI file can be delivered with: (1) where the 07x records are provided at 03 record level and (2) where the 07x records are provided at 88 record level. Our bank only provides the 07x records at 88 record level.

Do you know is it possible to setup configuration in SAP that would read the 07x data from the 88 record level?

If you think that is possible, is there any possibility you could send some sample screenprints please on how that might be done. If you could send these to my email address (if that is possible) it would be a huge help to us.

Any assistance or further advice you could offer us would be greatly appreciated. We have tried several routes with this but without any success.

Thanks again for your help.

Regards

Michael

[fernando_evangelista]

Hi Mike,

Please note that in an Intraday statement, you can use transaction codes

such as 070 (0 day float), 072 (1 day float), 074 (2 day float), and

075 (3 day float) to present and summarise your float breakdown, and

create memo records out of these "balances".

You should be able to create memo records for the 03 record if you have

the necessary customising set up in OT51, OT55 & OT82.

Here are some of the configuration tables you need: T028B, T028G, and

T028L, in addition to planning type, number range for memo record, and

bank...etc.

The transaction codes 07X can be mapped to the processing types BAI:...

in OT51. Memo records can then be automatically created according to

the configuration.

As per the specifications document by the BAI (http://www.bai.org) -

the "03" record line should from your

Intraday file should look like:

Example:

03,266028020,EUR,010,000<(><<)>(><(>,,<)><(><<)>)>,015,27079327<(><<)>(>

<(>,,<)><(><<)>)>,030,27079327<(><<)>(><(>,,<)>

<(><<)>)>/

with only 2 commas after "030, 27079327" before end of line delimiter.

Basically a line ends with a "forward slash" delimiter and you dont need

a "," delimiter for that field.

I hope this information helps,

Kind Regards,

Fernando Evangelista

[former_member293658]

Hi Fernando,

Thank you very much for the suggestions you made. We checked and varified that we have teh following configuration settings made:

OT51 - the 070, 072, and 074 transaction codes are mapped to posting rule and to a planning type. We have set the Processing Type here to BAI: Total Balance. This is table view V_T028G

Note: In here we also have mapped other transaction codes such as 164, 187, 357 etc etc with Processing Type 'Dummy Entry: Not Assignable'. As below these transaction codes do make postings for our Intraday statements. These transaction codes are hwoever found in the 16 record line of the BAI file.

OT55 - settings maintained here for the bank key/bank account combination to a Planning Type (same planning type as in OT51). We also maintained the company code and Cash Management Account Name here. This is table view V_T028B

OT82 - settings maintained for the Bank Key/Bank Account combination. We maintained the Planning Type (same PT as in OT51 and OT55) for PT Balance and PT Transaction. This is table view V_T028L.

Our BAI Intraday file looks like this. The information for the balance summary is contained in the 88 record lines not the 03 record lines. Do you know if that is the correct format?

03, 01234567,USD/

88,030,00002093638728,,/

88,040,00002063021639,,/

88,057,00000000000000,,/

88,060,00002092875718,,/

88,072,00000000763010,,/

88,073,00000000000000,,/

88,074,00000000000000,,/

When we load the BAI file via FF_5 we have the options 'CM Payment Advice' and 'Account Balance' selected and the planning type specified (same PT as in OT51, OT55, OT82).

However the system only creates records for the 16 detail lines of the Intraday Statement. It does not create any records for the 03 line record or for the 88 line record (which seems to store the 07X transaction codes as above).

Do you have an idae why the system won't post the 07X transaction codes? Is the BAI fiel format incorrect? Or is there other config settings we are missing?

Thank you for any other advice you can provide.

Kind regards

Mike