D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all


  • 1.  PurchLine.PNGxFactConfirmedPO

    Posted Apr 15, 2019 11:21 AM

    I have a customer who is trying to extract the column PNGXFACTCONFIRMEDPO as their XFACTORYDATE from the PURCHLINE table.

    The relationship in the AOT is setup on PurchId column on PURCHTABLE table and the PNGXFACTCONFIRMEDPO has data.

    When the document service is updated and the schemas refreshed, the resulting XML captured from the outbound purchase order mailbox doesnt contain any data for this XFACTORYDATE.

    Any methods in which to include or exclude columns in an AOT query?

    Rick Smith
    Integration Specialist I
    Seven Fields PA
    Academy - Online Interactive Learning from Experts

  • 2.  RE: PurchLine.PNGxFactConfirmedPO

    Posted Apr 17, 2019 03:24 AM
    Hi Rick,

    What exact version of Microsoft Dynamics are you using? If it is AX2012 or below, check if the related AXpurchline class has new methods for this custom field. If it is AX2012, perform also a CIL build. After the compilation, make sure the DB sync is complete and restart the AOS services of the environment. I do hope this will solve your issue.

    kind regards,

    André Arnaud de Calavon
    Solution Architect, Microsoft MVP - Microsoft Dynamics Business Solutions

    Academy - Online Interactive Learning from Experts

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