I have a number of solutions, working around the deficiencies of our accounting software-Microsoft Great Plains (v2010). I have been using a number of GP-SmartLists to extract data and upload to my Filemaker files. After a presentation at a local FMPUG, I got authorization to use ODBC to connect.
I did so, with the assistance of our Great Plains Administrator. He uses Crystal Reports to connect to the files. When we connected, we did not see the expected data tables. We saw "something" but they were not data tables. Has anyone else used FileMaker Pro to connect to Great Plains? I have the ODBC 64bit driver on the System Tab
The GP Admin inserted his User ID and Password for the connection. I am just sure where to go from here. My Great Plains VAR says "I don't know FileMaker".