Less than 1 month –
10-30 hrs/week –
Create SQL scripts which will extract data from MS Dynamics AX 2012.
I will provide access to a SQL server with data from AX 2012 tables. The job is to create a number of views (joining tables and selecting relevant fields) which will provide the data.
Data: LedgerJournalTrans joined so we get account number, documentID, amount, quantity, text, department, company, creditor, debitor, customer, product, Projectid, Purpose, etc.
Project: project hours, project id, employee, etc.
Dimensions: Account names, groups, Demartment names ...