BoberFett
Lifer
I have to interface with Great Plains for a variety of projects. This is a major companies accounting package, now run by Microsoft, and the architecture is nutty. All the tables are random named things like UPR00010, RM000101, AF10000. Luckily they do have nonvarchar columns like date columns, but a NULL date is actually stored in the database as 1/1/1900.
GP is notoriously awful to integrate with. EConnect has helped somewhat.