dennisr
Member
Hello Folks,
A while back I posted a question concerning receiving monthly electronic bank statements and getting that data into the appropriate tables in OneWorld for account reconciliation. My question now is has anyone done this that is familiar with the Bank Administration Institutes (BAI) Version 2 format for flat files? That is the standard format in which we receive the EBS and I'm curious if anyone has experience with that file format and getting data from a flat file in BAI Version 2 format into OneWorld tables. I've had some input earlier from folks who have done similar type things (without reference to the file format) who gone directly into the F0916/F0917 tables using a table converter. The same people have said that on hind sight they probably would have gone to a custom z table first, then use a UBE to edit and write the data to the F0916/F0917 tables.
I guess my concern is should I handle the parsing of a flat file in BAI Version 2 format outside of JDE and push to custom z table or can JDE handle the format. If anyone has done anything like this I would appreciate your input.
Thanks,
Randy
Randy Dennis
A while back I posted a question concerning receiving monthly electronic bank statements and getting that data into the appropriate tables in OneWorld for account reconciliation. My question now is has anyone done this that is familiar with the Bank Administration Institutes (BAI) Version 2 format for flat files? That is the standard format in which we receive the EBS and I'm curious if anyone has experience with that file format and getting data from a flat file in BAI Version 2 format into OneWorld tables. I've had some input earlier from folks who have done similar type things (without reference to the file format) who gone directly into the F0916/F0917 tables using a table converter. The same people have said that on hind sight they probably would have gone to a custom z table first, then use a UBE to edit and write the data to the F0916/F0917 tables.
I guess my concern is should I handle the parsing of a flat file in BAI Version 2 format outside of JDE and push to custom z table or can JDE handle the format. If anyone has done anything like this I would appreciate your input.
Thanks,
Randy
Randy Dennis