Post reply

Pricing EDI Feed Processing System

  • May 19, 2010 at 7:51 am

    #221265

    Hey All - I've just been assigned the task of reading in an EDI 811 feed from one of our clients, and this is something we/I have never done before. Basically, the process that will handle these feeds from start to finish (reading them in to creating the invoices and reporting), is being created from scratch. I have a few options I've come up with so far on the route I believe I'll be taking to accomplish this task, but I was just curious if anyone else has been assigned something similar and/or if anyone has heard of any pricing estimates for a system like this?

    A little background on the EDI 811 format:

    1) File contains three main parts - Heading Area, Detail Area, Summary Area

    2) Each of these segments can contain various information from multiple tables

    3) Simply put, it is a bunch of relational database tables extracted into a flat file

    I'm mainly going to be utilizing SSIS, T-SQL, UDF's and SProcs, and a little VB and PowerShell scripting to complete the lifecycle of this EDI reading process. Does anyone know what a fair price would be for implementing a Bill Reader system such as this from the ground up (i.e. reading in file, normalizing to standard format, consolidating invoices for auditing, reporting on invoices)?

    Thanks in advance!

    Danny Sheridan
    Comtekh, Inc.

  • May 19, 2010 at 8:44 am

    #1169479

    I currently maintain a system that does EDI 864 records;(?? didn't really notice they are numbered)

    if you have the schema and sample EDI file, I could look to see if you could use a .NET version sample of my code to do it yourself.

    do you only need to import, or do you need to output files in that format as well?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 19, 2010 at 8:55 am

    #1169488

    Thanks Lowell. The 811 after EDI refers to the format of the feed (e.g. EDI 810 and EDI 811 are invoicing EDI feeds in X12). There are others such as 850 which refers to ORDERS feeds, among many others.

    Unfortunately, due to data privacy, I cannot offer a sample feed or the schema of the feed. I was looking more to see if anyone else has implemented this type of system and the costs and efforts associated with it.

    I also just need to import the file to our system (SQL Server 2008) and parse out and normalize the data, where I will then run logic to match the invoices up to our asset inventory to produce the bills. There will also be a reporting system embedded for auditing purposes for finance folks.

    I'm still curious as to the method you approached with your .NET code - as I plan on parsing the data out with string functions (CHARINDEX to find the occurences of segment delimitters), then send each unique segment to its appropriate table. I understand if you don't want to, or are unable to provide some of that information.

    I've searched around and it's not easy finding information on methodologies used to import/process EDI feeds, so I'm open to suggestions if you think my first course of action I'm going to attempt has holes. Thanks again!!

    (Typo - Edited EDI 8100 to EDI 811 in first line and changed some wording)

    Danny Sheridan
    Comtekh, Inc.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply