Hello Everyone,

I am planning to set up EBS in CMG, the only confusion is about making the master set up.
I think I am commiting some mistake in the set up, because When I am trying to run the session "tfcmg5202m000 - Convert Electronic Bank Statements" system is giving error "File is not in Good Format" and "No Proper data found for Conversion"

My Query is how we are defining the master in session "Record types for electronic bank Statements" What is the exact meaning of "Record type Value" in this session.

Thanking you in Advance
Jagdish

The EBS in Baan is looking for a space delimited file, with specific records. You need to make sure that you have defined the records and that they are in the correct format. Look at the attachment and see if it helps.

Thanks for the input. I am already having the same documnet but my problem is that how system will understand the row and the column in the csv file..


Thanks

Jagdis S

Jagdish,
The EBS does not work on a CSV file. It works on a space delimited prn file. Each record in the file must be a specific number of characters. Every field must be in the exact same place. I create the file we use in Excel. Each column is a specific width equal to the characters in the field. All numeric fields must be left filled with zeros. When I save the file I save it as a space delimited prn, which saves it exactly as formated.
Hope this helps.

Hi,

As record delimiter.. you might have specified in first column something like 'x' and in last column 'y'. Between these two columns your data will be there.
Hence, with this biferacation system knows a new record.

Saritha