in partnership with systems advisers group axapta overview microsoft business solutions - imran ali
TRANSCRIPT
![Page 1: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/1.jpg)
IN PARTNERSHIP WITH
Systems Advisers Group
Axapta Overview
Microsoft Business SolutionsMicrosoft Business Solutions
- Imran Ali
![Page 2: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/2.jpg)
IN PARTNERSHIP WITH
Development
• The AOT- Open source (apart from Kernel)
• IntelliMorph • The MorphX IDE • X++• The Layered Application Structure of
Axapta• Drag-and-Drop functionality
![Page 3: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/3.jpg)
IN PARTNERSHIP WITH
AOT
![Page 4: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/4.jpg)
IN PARTNERSHIP WITH
AOT
![Page 5: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/5.jpg)
IN PARTNERSHIP WITH
Intellimorph• Axapta user interface
• Ability to perform simple modifications.
• Reports & Forms
![Page 6: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/6.jpg)
IN PARTNERSHIP WITH
Morph X• Development Suite (IDE)
• Develop and Customise interface
• Windows and Web interface
• Allows designing, editing, compiling and debugging
![Page 7: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/7.jpg)
IN PARTNERSHIP WITH
Morph X• Any user of the Axapta application
can customize the Axapta application to suit their needs
• The standard application is never overwritten
• Deleting an object, deleted in the current layer only
![Page 8: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/8.jpg)
IN PARTNERSHIP WITH
X++• Object Oriented language
• Hybrid of Java and C++• Contains many familiar SQL
commands
![Page 9: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/9.jpg)
IN PARTNERSHIP WITH
X++void run(){ AssetTable assetTable; Counter progressTotal; Counter progressCounter;
startLengthyOperation(); ttsbegin;
progressTotal = SysQuery::countTotal(queryRun); this.progressInit("@SYS67571", progressTotal, #AviFindFile); queryRun.query().dataSourceTable(TableNum(AssetTable)).update(true);
while (queryRun.next()) { assetTable = queryRun.get(TableNum(AssetTable)); progressCounter++; progress.setCount(progressCounter); progress.setText(strFmt("@SYS67572",assetTable.assetId,assetTable.assetGroup)); assetTable.barcode = assetTable.assetId; assetTable.update(); } ttscommit;
endLengthyOperation();}
![Page 10: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/10.jpg)
IN PARTNERSHIP WITH
Interconnectivity
![Page 11: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/11.jpg)
IN PARTNERSHIP WITH
Interconnectivity
• Component Object Module– Microsoft Business Connector– DCOM
• ODBC• XML• ActiveX• .Net Web service• OLAP• SQL Reporting service
![Page 12: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/12.jpg)
IN PARTNERSHIP WITH
Component Object Model
• Own COM object– allows to external application to connect– Business Connector
• Connects to external applications– e.g: Word, Excel, Outlook
• DCOM• Axapta user required
– with appropriate security rights
![Page 13: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/13.jpg)
IN PARTNERSHIP WITH
COM
External Example –
void new(COM _com = new COM('{783CD4E4-9D54-11CF-B8EE-00608CC9A71F}'))
{
Object o = _com;
this = o;
self = _com;
}
![Page 14: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/14.jpg)
IN PARTNERSHIP WITH
Business Connector
• Microsoft Axapta Business Connector
• Allows other applications to connect– Enables external applications to run
Axapta code
• Must be registered where COM code will be executed
![Page 15: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/15.jpg)
IN PARTNERSHIP WITH
Business Connector
• Example – – Word– Excel– Outlook
![Page 16: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/16.jpg)
IN PARTNERSHIP WITH
XML
• Axapta has full support for XML• Uses MSXML standard classes• Wrapper for the COM object• Does not support native XML, must code.• Examples include:
– SOAP– WML– SVG
![Page 17: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/17.jpg)
IN PARTNERSHIP WITH
Commerce Gateway
• Delivery of Documents between entities
• Handles industry standard XML documents
• BizTalk– Calls a static method using COM
connector
![Page 18: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/18.jpg)
IN PARTNERSHIP WITH
SQL Database
Axapta Application (AOD)
Axapta Clients (ax32.exe)
Customers Suppliers
2 PC
1 Cloud
1 Firewall
1Database
server
1 Building
1 File server
1E-Commerce
server
1Government
building
1Application
server
Legend
Symbol Count Description
Axapta Commerce Gateway
BizTalk Axapta Commerce Gateway
Government
Application Object Server
![Page 19: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/19.jpg)
IN PARTNERSHIP WITH
MSMQ
• Reads from MSMQ folders• Sends to MSMQ folders• Triggers set up to login into Axapta, via
COM• Messages disappear when completed• Axapta only commits when finished
successfully
![Page 20: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/20.jpg)
IN PARTNERSHIP WITH
MSMQ
• Example –
queueInfo = new MSMQQueueInfo();queueInfo.queueName(".\\Private$\\AxToTestQueue");
queue = queueinfo.open(#MQ_PEEK_ACCESS, #MQ_DENY_RECEIVE_SHARE);transaction = dispenser.BeginTransaction();
message = queue.receive();message.sendInTransaction(queue, transaction);
![Page 21: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/21.jpg)
IN PARTNERSHIP WITH
ODBC
• Connection straight to any database– by ODBC connection
![Page 22: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/22.jpg)
IN PARTNERSHIP WITH
ODBC
• Example –
loginProperty = new loginproperty(); loginProperty.setDSN("MSACCESS");
ODBCConn = new odbcconnection(loginProperty);statement = oDBCConn.createStatement();resultSet = statement.executeQuery("SELECT * FROM CustomersTable");
while(resultSet.next()){
myVar = resultSet.getString(#CODE);}
![Page 23: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/23.jpg)
IN PARTNERSHIP WITH
Web service
• Web services is a new way of packaging functionality so that it may be used by anyone, across machine boundaries.
• XML is pivotal for this technology.• Part of Microsoft’s .NET platform.• Using web services from Axapta is trivially
simple.
![Page 24: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/24.jpg)
IN PARTNERSHIP WITH
Web Service
• Using Web services from Axapta is trivially simple:
WebService w = new WebService(http://somewhere/myservice.asp);
Print w.theMethod(1, ”Hello”);
![Page 25: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/25.jpg)
IN PARTNERSHIP WITH
Web Service
• Example – PDF Retrieval
– HTTP request to PDF server with Base64EncodingString in .aspx format
– Web Server validates String and Streams back PDF file
– ActiveX control in Axapta displays PDF document
![Page 26: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/26.jpg)
IN PARTNERSHIP WITH
ActiveX• Supports ActiveX controls
• Provides extra functionality
• Supports DLL– Example WinAPI
![Page 27: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/27.jpg)
IN PARTNERSHIP WITH
ActiveX
![Page 28: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/28.jpg)
IN PARTNERSHIP WITH
Advance Controls
![Page 29: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/29.jpg)
IN PARTNERSHIP WITH
OLAP
• Uses Microsoft Office PivotTable ActiveX control
• Cube data is available from the OLAP server through the PivotTable® Service
• The Microsoft Office PivotTable ActiveX is a part of the Office Web Components included in Microsoft Office 2000
![Page 30: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/30.jpg)
IN PARTNERSHIP WITH
MS Reporting Services
• HTTP requests
• ActiveX Controls
• Returns HTTP page
• Read from SharePoint portal
![Page 31: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/31.jpg)
IN PARTNERSHIP WITH
Payroll Integration
![Page 32: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/32.jpg)
IN PARTNERSHIP WITH
Payroll Module
• Payroll Module is an add-on– Created by third party
![Page 33: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/33.jpg)
IN PARTNERSHIP WITH
Payroll Interface
• Payroll system called ‘Earnie’– CSV interface– User inter-action– Exporting:
• Aggregation of Timesheet lines by Pay Elements
– Importing:• Payslip
– Axapta to calculate costs
• General Ledger Costs
![Page 34: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/34.jpg)
IN PARTNERSHIP WITH
Payroll Interface
• TRENT• Established Payroll system
– Clients: Virgin, Northern Rock, University of Bolton
• £1.7 million contract with one of our Axapta clients
• Created interface between TRENT and Axapta
![Page 35: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/35.jpg)
IN PARTNERSHIP WITH
Payroll Interface• Axapta Export:
– Contract Creation, Suspension, deletion at ‘Real Time’ (Projects module)
• Deletion & Suspension uses Web service interface
– Axapta expects Yes/No reply
– Exceptions• BizTalk emails error report to user
![Page 36: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/36.jpg)
IN PARTNERSHIP WITH
Payroll Interface
• Axapta Import:– Timesheets
• 10,000 Lines per month
– Payslip• Axapta to run calculation costings• Update timesheet lines with correct costs• Create General Ledger journal
– Employee data– Pay Elements (called categories in Axapta)
![Page 37: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/37.jpg)
IN PARTNERSHIP WITH
Payroll Interface
• XML• BizTalk
– Split XML files per company– Email errors to appropriate users
• Axapta Business Connector• User interaction
– Select period, automatically sends data
• No Commerce Gateway Module
![Page 38: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/38.jpg)
IN PARTNERSHIP WITH
Payroll Interface
• Projects Module• Human Resources Module• Axapta logs all communications between systems• All errors written to Windows Event Log• Exception handling when reading from MSMQ.
– Axapta does not commit until process is finished. – Message is never lost– BizTalk will send again
![Page 39: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/39.jpg)
IN PARTNERSHIP WITH
• Security between servers– WS-Security, WS-Policy– Kerberos tickets– Encrypted SOAP messages
Payroll Interface
![Page 40: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/40.jpg)
IN PARTNERSHIP WITH
Thank you
![Page 41: IN PARTNERSHIP WITH Systems Advisers Group Axapta Overview Microsoft Business Solutions - Imran Ali](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649e5d5503460f94b559ff/html5/thumbnails/41.jpg)
IN PARTNERSHIP WITH
Questions?