Hi, We are trying to implement EBS module, could some can send us an example of the definitions in sessions 5104 and 5105. Because when we run the session 5202 the system displays “file not present or not in good format”

Thanks

Hi,

This message occurs if there is no file present for conversion or the file is present in the wrong directory. The file for a particular bank relation should be present in the directory given in session tfcmg0110m000 (maintain bank relations). In the form 2 of this session u should specify the path for the ebs files and also the archival of ebs files. U should put the conversion file in the path given for ebs files.

Hope it helps

Sai Krishna

Hi Sai,

We defined for the Bank relation boths paths.
For the File is \\lxpro\baanf\exchange1\file\
and for the archive \\lxpro\baanf\exchange1\archive\

and we create a test file (stat01.txt) in the first path. but the system is sending the same error message. Could be another think or parameter to check.

These paths we use for the exhange module Import and Export.

Regards

IM getting the same error as jzgv01. MY path is \\server\D$\EBS, but it keeps popping up directory not present. What do you mean put the conversion file in the given path for EBS files?

OK I found that I need to simply use the local drive rather than a server, C:/EBS for example. I have created a test .prn (flat file) and I have loaded into the EBS directory Path that I created. when going to Convert EBS (tfcmg5202m000) I can now choose BNK for the Bank relation and the Pathname EBS files (C:/EBS) but it I still see nothing in the Display Batchs for EBS or the (tfcmg5500s000). What do you think I could be doing wrong here? My .prn file should match my maintain Conversion for EBS, shouldnt my prn file show up in the Display Batchs for EBS??

If you can share the test file you used to convert and the conversion data screen shot, we can suggest you better.

Thanks.

Regards,
Madan

Hello Madan. Here is my Test file:

TEST File (http://www.geekzee.com/Baan/test.prn)

See my screenshots of EBS and Baan here. (http://www.geekzee.com/Baan/EBSEXAMPLE.docx)

I think I have everything right here. When I place the prn file into the D:/EBS directory, i put in the batch number (prn file name) and it says batch not found. Am I missing a step??

Does a batch = a flat file in the directory?

Hello,

I have seen your conversion data setup. First position is used for incoming receipt. We already reserved that position for record type. Date format should be setup properly. In your file as there "/" symbols we need to setup properly. Like Year 1 to 4, Month 6 to 7 etc (5th position is "/", exclude this). for the incoming receipt/outgoing payment you need to enter some text like "i" for incoming receipt and "o" for outgoing payment in conversion data setup. As per my knowledge date, amount and incoming receipt/outgoing payment are mandatory fields for one record. Yes, you are correct one batch will be created for one file we convert.

Regards,
Madan

Thanks Madan,

Yes you are correct that those 3 fields are mandtory. I've changed the way fields are laid out in my Matain Conversion Data for EBS to now match the file much better. I now see what you mean by the setup position, also for the first position, since Ive already used it in Maintain record Types. Do you happen to know when in the Convert EBS module, when you click on EBS Batch, it should read all the text or prn/flat files in that directory, yes?? Thats where my hold up is with, Ive got my file path listed in there correctly but EBS Batch # defaults to the #1 and always says "File not present of in good condition". When I take my text file and rename it as some generic like 123456 for example, the error simply says "Batch not found". See the attachment.

EBS SCREENSHOTS OF CONVERT EBS (http://www.geekzee.com/Baan/EBSSAMPLE2.docx)


GOOD NOTE: Batch number should be next available batch number. As there are no batches already converted, system will default 1.

I have been able to successfully take a test file in import it into Baan. Heres a document I put together that helps better explain what to to. I hope this will help out as others try to use this feature and figure it out.

GabrielVA

PDF of getting EBS to work in BaaN with a test file (http://www.geekzee.com/Baan/EBSinBaaN.pdf)