[masraum]

Originally Posted by flipper35

Ted, it is supposed to be all automated with no human intervention unless there is a data mismatch between the two invoices.

Ayles, can it deliver a file based message for the response?

What is frightening is the developer not understanding the questions asked to see where things are going wrong.

If it were me, I would fire that team and start over. I can't imagine something that simple wouldn't be further along inside 6 weeks, let alone 16 months.

Right now, they don't know how to check the file, they don't know why it rejects some and not others, they don't know what development tools they are using other than they do have SQL Studio with an Access database. Yes, Access that is accessed through SQL Studio.

I was thinking the same thing. You don't seem to be talking to developers. Hell, I'm not a developer but even I've got ideas about how it would be done. I would think it could probably be done within bash or something like that (not that I'm a developer or suggesting that).