D365 Finance & Operations and Dynamics AX Forum

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
------------------------------

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
------------------------------

Original Message:
Sent: Nov 26, 2019 12:13 PM
From: Eddie Smith
Subject: Vendor Created by and Created date/timestamp

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
------------------------------

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
------------------------------

Original Message:
Sent: Nov 26, 2019 03:04 PM
From: Andrew Xu
Subject: Vendor Created by and Created date/timestamp

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

Original Message:
Sent: Nov 26, 2019 12:13 PM
From: Eddie Smith
Subject: Vendor Created by and Created date/timestamp

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
------------------------------

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
------------------------------

Original Message:
Sent: Nov 26, 2019 12:13 PM
From: Eddie Smith
Subject: Vendor Created by and Created date/timestamp

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
------------------------------

​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
------------------------------

Original Message:
Sent: Nov 29, 2019 12:49 PM
From: George Zhao
Subject: Vendor Created by and Created date/timestamp

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

Original Message:
Sent: Nov 26, 2019 12:13 PM
From: Eddie Smith
Subject: Vendor Created by and Created date/timestamp

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
------------------------------