Excel Integration in the New AX (AX 7)

The New Microsoft Dynamics AX (formerly referred to as AX 7) has a better integration with Microsoft Excel. It allows you to export to Excel, as with previous versions, but it also lets you write back changes from Excel to  Dynamics AX much easier than in the past.  The New AX has also expanded the use of entities to make it easier to import and export data.

In any list page in AX, when you click on the Office icon it will give you two options. The option in RED, will export to Excel so you send to another person.  The option in Green, to open in Excel, will allow you to edit the data in excel and push it back to AX.  Those that have used Dynamics AX 2012 know about the excel add-in, that was supposed to give you this functionality as well, but was very finicky to use.  The integration with the New AX has been improved significantly.

The New Dynamics AX

 

 

 

 

 

 

Once you click the open in excel button, a screen pops up to let you save locally, or to SharePoint or OneDrive for business.

After downloading or saving the file, open it and enable edit mode. It will then prompt you sign in, simply use your AX login credentials.  Once the credentials are provided it will load the data into Excel.  From here you can edit any of the data, that is not read only.  Read only fields are noted in red. A key symbol is used to identify key fields.  Finally, an asterisk is used to identify required fields for new records.  Once you’ve made the necessary changes, simply hit publish and the changes are written back to excel.  You can even use Excel to create new records.

NEW Dynamics AX

 

 

 

 

 

 

In addition to the open in excel function from all to the list view pages, you can also access the Excel workbook designer. This is located in the Common module, under Common>Common>Office Integration>Excel Workbook Designer.  The workbook designer gives you access to over 1600 entities that come standard in the New AX.  If you can’t find an entity that meets your needs, you can build your own by using visual studios.  The use of the workbook designer does require you to have Excel 2016.

Using the workbook designer, you can add all the fields you want from the entity, you can view the related form in AX, and you can get a count of all the records associated with the data entity.

NEW Dynamics AX

 

 

 

 

 

Once you’ve selected the fields you want for the workbook, click “create workbook” and it will prompt you to save the workbook. Then you can open, and start editing data or creating new records.

This post was written by Jason Federspiel, AX Functional Consultant at Tridea Partners. Tridea is a leading Microsoft Dynamics provider.

2016 Dynamics Customer Event

Tridea Partners had a successful Dynamics Customer Event at Ballast Point Brewery last week. We wanted to thank our sponsors Avalara, Concur, Solver and everyone who came out to our event! We wanted to share some pictures from our successful event! We will see everyone at the next event!

Microsoft Dynamics CRM and ERP – The Winning Integration Webinar

MICROSOFT DYNAMICS CRM & ERP INTEGRATION

DRIVING PRODUCTIVITY & CUSTOMER SATISFACTION

Join Tridea Partners xRM³ as we host this webinar on why Dynamics CRM and ERP is the Winning Integration!

MICROSOFT DYNAMICS CRM & ERP INTEGRATION

Does your company engage in a highly transactional business with new or repeat customers? Imagine how much better your sales, service and finance teams could operate sharing critical customer data. No more data silos.

Learn how in our 30-minute webinar:

  • Hear how companies are benefiting today from integration of Microsoft Dynamics CRM and Microsoft Dynamics ERP.
  • See what type of data is being shared between departments to increase sales and customer satisfaction.
  • Gain a basic understanding of how sales and finance can automatically share data on orders, shipments and invoices.

Event Details: Wednesday  May 25, 2016 10:00 AM – 10:30 AM (PST) Presenters:  Ken Farmer –  xRM³ &  Andy Collins – Tridea Partners

register here

The NEW Dynamics AX Webinar

The official release of the New Microsoft Dynamics AX (formerly known as Dynamics AX 7) is available.  Join Tridea as we host this webinar on an overview of the NEW Microsoft Dynamics AX release!

Join us for this webinar, Topics include:

  • Dynamics AX moving to the cloud
  • License changes
  • Deprecated features
  • A demo of the new web based Microsoft Dynamics AX

Date: Tuesday, May 31, 2016  at  10:00 AM to 11:00 PM (PT)

register here

Dynamics AX 2012 : Quick Way to Copy or Reverse a Journal

There are a couple of ways to reverse a journal in Microsoft Dynamics AX. One is to use the “Reverse transaction” option from the GL inquiry screens.  This is a quick and easy way to reverse entries, but there are many entries which cannot be reversed, and when transactions are reversed, they are automatically posted without being processed by a workflow or an approval group which is a problem for many organizations.

The other option is to use the “Load ledger balances” functionality in the journal screen to load a journal that has already been posted. This is really a copy function that can be used to copy a prior journal with reversed transactions which can then be routed through an approval process.

To copy a journal:
  1. Create a general journal as you normally would and click Linesax 2012
  2. In the lines form, click on Functions and then select Load ledger balances.ax 2012
  3. On the Load ledger transactions form:
    • Verify the voucher is set to New voucher number per voucher.
    • Click the Invert sign check box if you would like to reverse the journal.
    • Click Selectax 2012
  4. On the Select screen, enter the Journal number that you would like to reverse or copy and click OKax 2012
  5. You are now back on the Load ledger transactions screen, click OK.ax 2012
  6. Upon clicking OK, AX will load a copy or reversal of the journal you selected in the current journal form. Notice in the case of a reversal, AX inserts the description of Void and the voucher number.ax 2012
  7. You can now submit your journal through the review and approval process and post!

This post was written by Matthew Caffrey, AX Application Consultant at Tridea Partners. Tridea is a leading Microsoft Dynamics provider.