Expense Reporting module with American Express .dat file

hwilson

Member
We have a requirement to take an American Express .dat file (with card transactions...TRANSACTION TYPE, AMOUNT, VENDOR NAME, etc...) and convert it to a Z file for processing in JDE. The JDE table in which data should be inserted is F09E150. Do you have advice on other customers using this or a similar process? We need a way to convert the .dat file into a 'file' for the JDE Z file. Is there a best practice being used? Or a custom program being used by other customers, written in VB? (Or other language.) I hope there must be some easy way, outside JDE, to directly convert the .dat file to an Oracle table. And, if there is such way, we can just directly convert the .dat file to the Z file.

Thank you for any advice!
 
Back
Top