D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Purchase Request line in Excel Add in

  • 1.  Purchase Request line in Excel Add in

    Posted Feb 21, 2020 12:28 PM
    One of our users tried open a purchase requistion and lines into Excel using the D365 addin. We are using D365 for Finance and Operations. When he opened the file, the add in displayed the message " An error occurred while reading the data cache. Details: The specified coercion type is not supported." I tried Googling this error, but so far have had no luck. I tried the same operation on my PC and had the same results. I tried pulling up some other data like vendors and GL journal batches. They worked without any problem.
    Has anyone encountered this problem and know of a resolution?

    ------------------------------
    Thomas Laza
    South Texas Electric Cooperative Inc
    Nursery TX
    ------------------------------


  • 2.  RE: Purchase Request line in Excel Add in

    Posted Feb 21, 2020 01:19 PM
    Hi Thomas,

    Are you using Microsoft Office 2016?  My clients ran into several errors until they upgraded their version of excel.


    ------------------------------
    Missy Martoncik
    Senior Finance Consultant
    AXIA Consulting, Inc.
    Columbus
    ------------------------------



  • 3.  RE: Purchase Request line in Excel Add in

    Posted Feb 21, 2020 01:36 PM
    Yes, it is Office 2016.I am able to open many other entities with the Excel Add in and publish changes back to D365.. It is just the Purchase Request lines that give the error.

    ------------------------------
    Thomas Laza
    South Texas Electric Cooperative Inc
    Nursery TX
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role