New LN User Question - Please be patient :)
Baan: ERP LN 6.1 FP6
I was recently hired by a company which uses Infor LN ERP (v6, I believe). At my previous employer, I self taught myself and became the "local" expert in developing queries / data extracts from our ERP system (JDE) using Microsoft Access and an ODBC driver. I was disappointed to learn that I'm unable (to my limited knowledge) to apply this same approach (Access and ODBC). I was provided this program called "Eclipse" which does offer query writing but not the ability to link local tables/data and incorporate into queries.
To get to the point, I'm asking the experts here if it's possible to use Microsoft Access to connect to Infor LN and create queries / extract data? What information about my company's setup do I need to provide in order for someone to help? I have the support of our IT group, if needed, to help implement changes.
For example, I frequently analyze finalized GL transactions (tfgld106) and would like to create queries linking fields to other LN tables like sales orders (tdsls401, etc).
Can anyone help?