Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Looking for assistance on query for Office WORD Template used in AX 2012 R2 CU6

  • 1.  Looking for assistance on query for Office WORD Template used in AX 2012 R2 CU6

    SILVER CONTRIBUTOR
    Posted 17 days ago
    Hello -
    I have been successfully using a WORD template to assist our users in generating a Certificate of Origin.
    I was using a standard AOT query that was activated as a data source.

    Now our users are requesting some tweaks to the data - which I am not able to obtain using my original query.

    My first thought was to do the old "query --> view (with calculated columns) --> query.
    When I tried this, I realized that I had lost the primary table (SalesTable)  - which the template requires to "connect" to the primary table form.
    I modified the 2nd query to start with SalesTable and then use the view as its datasource.
    This is not working - as it is giving me an "invocation" error.

    I then thought maybe I could put some VBA coding in the WORD template, and once the WORD template
    was populated, the VBA could get executed.

    Has anyone run into something similar with a WORD template - and if so, what was your solution?

    Thanks...Tammy McNab

    ------------------------------
    Tamara McNab
    IT Manager
    Phoenix Products Co.
    Milwaukee WI
    ------------------------------


  • 2.  RE: Looking for assistance on query for Office WORD Template used in AX 2012 R2 CU6

    SILVER CONTRIBUTOR
    Posted 15 days ago
    Hi all -

    It appears that this resolved itself once our development server was power cycled.
    Not sure if it was a cache issue or something else.

    Once the server came back up, the error went away.

    This is no longer an issue for us.

    Thanks..Tammy

    ------------------------------
    Tamara McNab
    IT Manager
    Phoenix Products Co.
    Milwaukee WI
    ------------------------------