D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Vendor Created by and Created date/timestamp

  • 1.  Vendor Created by and Created date/timestamp

    Posted Nov 26, 2019 12:13 PM
    Does anyone know where the Vendor fields 'created by' and ​​'created date and time' are kept in Dynamics (i.e. entity)? Able to bring them back into an ALL VENDORS grid and it appears to be coming from the Vendors table, however, when I query the Vendors entity in DMF and Atlas, the fields are not present. Could it be a security issue or are they kept in a different table/entity?

    ------------------------------
    Eddie Smith
    Universal Leaf Tobacco Company, Inc.
    Richmond VA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Vendor Created by and Created date/timestamp

    Posted Nov 26, 2019 03:04 PM
    Hi Eddie,
    In out of box D365, neither the deprecated vendVendorEntity nor vendVendorV2Entity has CreatedBy and CreatedDateTime included. So you'll need to exptend the entity to add those fields.

    ------------------------------
    Andrew Xu
    Application Architect
    The Jackson Laboratory
    Bar Harbor ME
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Vendor Created by and Created date/timestamp

    Posted Nov 27, 2019 11:13 AM
    Hmmm. I'm using D365 and see both Created By and Created Date/Time as well as Modified By and Modified Date/Time. Maybe we made an extension, but I don't recall doing that.

    ------------------------------
    Gayla Shulhan
    MEC (Mountain Equipment Co-op)
    Vancouver BC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Vendor Created by and Created date/timestamp

    GOLD CONTRIBUTOR
    Posted Nov 29, 2019 12:50 PM
    The fields are definitely from VendTable. However the data entity may omit some fields. So follow Andrew's suggestion and add the fields to the data entity. Also if you only need them on the "All vendors" list page, you probably don't need to customize the data entity. You can add the fields through personalization for individual user(s).

    ------------------------------
    George Zhao
    PAR Technology
    New Hartford NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Vendor Created by and Created date/timestamp

    Posted Nov 30, 2019 08:05 PM
    ​Thanks everyone. I know I can add the fields on the ALL VENDORS grid, that's how I found the fields. Issue is I would like to use Atlas to bring this back in Excel as I have 4 companies to query and as you know the grid option is company by company. Having to customize the data entity to bring back fields that exist in the table seems strange to me, but I come from a relational ERP system and not used to MS "cloud" technology.

    ------------------------------
    Eddie Smith
    Universal Leaf Tobacco Company, Inc.
    Richmond VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


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