Currently we use an access database that was written in house years ago (not by me) that creates flat files from an access report. These flat files then get imported into our EDI software which is: GXS Desktop EDI to send the flat files (invoices) we also receive orders via EDI from various customers.
The problem is one of our customers is now requesting that we send them a weekly price file via EDI (in version 8 price file format), and we dont have this setup in access. Ive tried to find a template that I could use in access but I havent found one that would work easily in access without having to do a lot of testing, and lots of manual manipulation which is likely to take quite some time to do. The customer is requesting we send them price file information via EDI urgently asap.
I would really like some help on what would be the best solution to this?, should we try to setup a price file report within access? or look at an alternative solution such as changing to some other EDI software that might allow us to extract the required data from our backend ERP system more easily?.
Does anyone have a price file template that could be used in access?.
An EDI system that allows easy migration with external data sources such as Oracle or SQL tables could be useful. Is there some EDI software that you would recommend?
More detailed information:
The EDI access database is linked to one oracle table (this table is used by our ERP system) and some other linked access tables, within these tables contains information about customers, invoice information, and product information.
A report in access has a template setup with the required valid fields needed in a flat file. A macro runs every night which exports the report into a text file. The text file has a list of all the latest EDI invoice information.
The maco then runs some VBA which splits out the text file into separate flat files for each customer. Each morning these flat files get imported into the GXS desktop EDI software so that they can be sent.
Please see attached screenshots of the access tables and the report