Applies to these Dynamics 365 apps:
Commerce, Finance, Supply Chain Management
Also available: Office 365 Nonprofit E1, Office 365 Nonprofit E5, Microsoft 365 Business Basic, Microsoft 365 Business Standard, and Microsoft 365 Apps for enterprise. Prices are for information purposes only. In case of any discrepancy between prices stated and the pricing source defined by the Pricing and Payment Terms in the. Understand that conferences will still be in First Class until the owners transition them to Office 365. Understand that when someone outside of OPS (parents, community members, etc.) emails you it will appear in Outlook so you need to make sure you check your Outlook inbox and reply to them in Outlook. Microsoft has added a new program that provides a free version of Office for enrolled students. It includes applications like Word, PowerPoint, Excel, and OneNote. The program allows currently enrolled students to install Microsoft Office 365 ProPlus on up to five devices, including PCs, Macs, phones or tablets. 5141 F Street, Omaha, NE. Main Office Phone: (531) 299-2260. Main Office FAX: (531) 299-2278. Nurse Fax: (531) 299-2279.
This topic reviews Microsoft Office integration concepts and features. The integration depends on several technologies:
- Working in Microsoft Azure
- Working with Azure Active Directory (Azure AD)
- Running a web client in multiple browsers
The Microsoft Office integration capabilities provide users with a productive environment that helps them get the job done by using Office products.
Excel Data Connector add-in
Microsoft Excel can change and quickly analyze data. The Excel Data Connector app interacts with Excel workbooks and OData services that are created for publicly exposed data entities. The Excel Data Connector add-in enables Excel to become a seamless part of the user experience. The Excel Data Connector add-in is built by using the Office Web add-ins framework. The add-in runs in a task pane. Office Web Add-ins are web applications that run inside an embedded Internet Explorer browser window.
Dynamics AX 2012 architecture vs. Finance and Operations architecture
There are several differences between versions. For both, we built lightweight add-ins that run in Excel and use services to connect to the application.
Dynamics AX 2012
Excel > VSTO (.NET) Add-in > Windows Communication foundation (WCF) > Authentication through Active Directory (AD) > AIF SOAP services on the AOS > AX Services and Tables > AX query engine > Database
Finance and Operations
Excel > Office Web Add-in (JS + HTML) > JavaScript OData API (Olingo) > Authentication through Azure Active Directory (AAD) > AX OData services on the AOS > AX Entities > AX LINQ provider > AX Database
Office Add-in explained
The Excel Data Connector app is located in a task pane on the right side of a workbook. The following table describes the parts of the add-in. The numbers correspond to the numbers in the preceding screen shot.
| Number | Name | Description |
|---|---|---|
| 1 | Add-in primary title | The title of the add-in that is provided to the Office Web Add-ins framework. |
| 2 | Add-in secondary title | The title of the add-in that is provided by the add-in. |
| 3 | Source name | The label of the entity that provides data for the selected data table. You can hover over the label to see the corresponding name. |
| 4 | Field name | The label of the field that provides data for the selected data table column. You can hover over the label to see the corresponding name and type. |
| 5 | Refresh button | Refresh the data in the workbook. |
| 6 | Publish button | Publish the data changes in the workbook. |
| 7 | Design button | Open the design-time experience. |
| 8 | Status bar | The status bar provides brief temporary information alerts. Information that is appears in the status bar also appears in the Messages dialog box. |
| 9 | Options button | Open the Options dialog box. |
| 10 | Messages button | Open the Messages dialog box, which displays the information messages, warnings, and errors that the program provides to the user. A number sometimes appears next to the Messages button to provide a count of the warnings or errors that the user might be interested in. |
| 11 | Excel data table containing data | The filter and sort controls in the columns headers can be used on this data. The filters must be removed before data changes are published. |
| 12 | Office Web Add-ins menu | The Office Web Add-ins menu button provides several standard links. The most important of the links is used to reload the add-in. When the add-in is reloaded, it updates all the data for the workbook that is contained in tables that are associated with the add-in. |
Authentication
OData sits on the same authentication stack as the server. The add-in uses OAuth to facilitate authentication.
Lookups and drop-down lists
When you click in a table cell, any lookup, enumeration drop-down list, or date picker that is associated with that cell will be shown inside the add-in, underneath the source and field information. Any value that you select inside the add-in is put into the currently selected table cell.
Adding and deleting records
To add a record, either start typing in a row directly below a table, or use the Tab key to tab away from the last cell of the last row in the table. To delete a record, select the row by clicking the row label (1, 2, 3, and so on), and delete all the cells in that row. To publish the changes, click Publish. The Messages dialog box shows how many records were added, edited, and deleted.
Workbook Designer
You can use the Workbook Designer page to design an editable custom export workbook that contains an entity and a set of fields. To open the Workbook Designer (ExportToExcelWorkbookDesigner) page, click Common > Common > Office Integration > Excel workbook designer. Before you can publish data edits, all the key fields of the entity must be in the Excel table. Key fields have a key symbol next to them. To successfully create or update a record, it must have all the mandatory fields in the Excel table. Mandatory fields have an asterisk (*) next to them.
To retrieve the resulting workbook, click Create workbook in the app bar.
Click View related form to see the data that the entity exposes. This button is only enabled for entities that have a FormRef property value.
Document management
Document management supports saving record attachments in Azure Blob storage and SharePoint Online. Database storage is deprecated. Azure Blob storage is equivalent to storage in the database since documents can only be accessed through the application and it provides the added benefit of providing storage that doesn't negatively affect the performance of the database. Azure blob storage is the default and works immediately. SharePoint storage will work immediately if you have an O365 license since we auto-discover the SharePoint tenant e.g. a user on the TenantA.onmicrosoft.com O365/AAD tenant gets TenantA.sharepoint.com as the SharePoint site. If document management has been turned off by the user, turn it on by clicking Options > General > Miscellaneous and setting Document handling active to Yes.
On any page that has data, an Attach button will be available in the upper-right corner.
The Attachments page provides a view of the attachments (documents) that are associated with the record that was selected on the previous page. You can add new attachments to the record by clicking the New button (+) in the app bar. For the File and Image document types, you will be prompted to provide the associated file.
Document preview
A preview for supported file types is provided on the Preview FastTab. Basic document types, such as PNG images and text files, are supported by default. Office document types, such as Microsoft Word, Excel, and PowerPoint files, must use a production Office Web Apps Server, which might not be available in a OneBox configuration.
Frequently asked questions
Office 365 Ops Student Login
Office Licensing
What Microsoft 365 licenses are available?
There are lots of Microsoft 365 license options. You should select the license that makes sense for your organization.
After purchasing a Microsoft 365 license, what needs to be done to set up SharePoint storage for attachments?
Office 365 Opslag
Open the Document Parameters form and ensure that the SharePoint server has been automatically discovered and set. Now open or create a Document Type, set the Document Type's location to 'SharePoint' and select the folder that the files should be stored in.
Additional resources
Note
Can you tell us about your documentation language preferences? Take a short survey.
The survey will take about seven minutes. No personal data is collected (privacy statement).
Microsoft Office 365 is a modern collaboration platform that provides a full-featured email system with web access, integrated calendaring, a campus contacts directory, support for mobile device access, and 50 gigabytes of email storage and 5 terabytes of document storage per account.
Features
- Convenient web and desktop access to your email and integrated calendar. Full-featured web interface for accessing email and calendar (Outlook Web App), as well as email and integrated calendar compatibility with desktop email clients such as Microsoft Outlook and Apple Mail.
- Large message storage capacity. 50 gigabytes of email storage for each user.
- Access from portable devices, including iOS and Android-based phones and tablets. Access to your email, calendar entries, and contacts from your mobile device.
- Built-in anti-spam message filtering. Integrated anti-spam tools for smoother control of email filtering and identification.
- OneDrive for Business, an online document storage and sharing tool that faculty and staff can access through the Outlook Web App (OWA). 5 terabytes of document storage for each user.
NOTE: Visit itservices.usc.edu/officefacstaff for information on how to download free Microsoft Office software.
Eligibility
All USC faculty and staff.
System Requirements
For information on the web browser requirements for accessing Office 365, see the Microsoft Office 365 System Requirements page.
Getting Started
Accessing the Outlook Web App for Office 365
The Outlook Web App (OWA) is the web-based email client for Office 365. In order to access OWA, open a supported web browser and go to www.usc.edu/office365. If you haven’t already signed into any USC single sign-on services from your web browser for the day, you will be taken to the red USC NetID sign-in screen where you will log in using your USC NetID and password.
Office 365 Ops Email
Signing Out of OWA
When you are finished using the Outlook Web App, you should exit your web browser by closing all open tabs to ensure you have properly signed out of your Office 365 account.
Learn More
Office 365 Documentation
The documentation in this section will provide information on how to access your email and calendar through the Outlook Web App, configure an email client to access mail through Office 365, set up your mobile device to access your Office 365 email, configure settings such as forwarding and automatic replies (vacation messages) using OWA, store and collaborate on documents using OneDrive for Business and connect with USC and non-USC colleagues using Skype for Business.
Video Tutorials
There are video tutorials available from Lynda.com, Apple.com, and Microsoft.com on a variety of Office 365 topics. You will find links to these video tutorials on pages throughout the Office 365 documentation and from the Office 365 Video Tutorials page.
Data Security
OneDrive for Business is approved for storing some restricted data, including Health Insurance Portability and Accountability Act (HIPAA)- and Family Educational Rights and Privacy Act (FERPA)-related information. Please note that additional controls may be required, depending on the type of data and relevant regulations. (Contact usc-ciso@usc.edu for additional information.)
Support
If you have any questions or concerns regarding your Microsoft Office 365 account, please contact the ITS Customer Support Center.