Article

From the Microsoft Dynamics AX Blogs: Quick Excel Reports in AX 2009; Table Relation Properties in AX 2012; Preallocated Number Sequences

by Jared Berezin
,

How to Create a Quick Excel Report: Casperkamal's Dynamics Ax blog provides the necessary steps and offers a helpful demo video that explains how to create an ad hoc excel sheet to show data changes, compile information from different tables, etc: "Excel is the most convenient software to examine changes in data. Specially when you have made them code and wanted it to be tracked. That's one of the many reasons why excel tops to be the most used software in the world."

Tutorial on Table Relation Properties in AX 2012: Dynamics AX Tools and Tutorials provides a trimmed Guideline Document from the AX team so that it contains the information relevant for partners and customers looking to extend the standard application: "As many of you already know, Microsoft has put in a lot of effort into normalizing the tables in AX 2012 and consolidating all the data modeling tools in one place - the table itself... The new properties you will find on a Table Relation in AX 2012 are:

  • Cardinality
  • RelatedTableCardinality
  • RelationshipType
  • Role
  • RelatedTableRole
  • UseDefaultRoleNames
  • CreateNavigationPropertyMethods
  • NavigationPropertyMethodNameOverride

How Preallocated Number Sequences are Cached in AX: Dynamics AX in the Field cautions that while in most cases, using preallocated number sequences is good practice and results in less trips to the ...

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access
AX 2012 BI and Reporting Dynamics AX ax 2009
About Jared Berezin
Jared Berezin serves as a contributing writer to MSDynamicsWorld.com. With combined interests in technology and science, Jared previously served as a writer for Dana-Farber Cancer Institute, drafting scientific narrative reports on the latest advancements in cancer research. Jared has also served as associate marketing specialist for International Data Corporation (IDC), a market research firm. In this position, he planned and executed strategic marketing initiatives for IDC's software and services research programs, and wrote outbound communications to the press, existing clients, and prospects. Jared also has experience working for several local newspapers in eastern Massachusetts. Jared graduated with honors from Colby College with a BA in English and creative writing.
More about Jared Berezin