SQL script to get table name with with highest number of records
SELECT
[TableName] = so.name,[RowCount] = MAX(si.rows)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U'
AND
si.id = OBJECT_ID(so.name)
GROUP BY
so.name
ORDER BY
2 DESC
D365/Ax7 Data Entity error : Results. Field 'Invoice account' must be filled in. Results. validateWrite() failed on data source "Tablename"
Many times while importing data through Entity will get below error message : Results. Field 'Invoice account' must be filled in. Results. validateWrite() failed on data source "Tablename" Root Cause : Allow edit and Allow Edit on create property is NO on table field level SO same property carry forwarded to Entity data source as well Solution : both steps are necessary to resolve above error 1. Set "Allow edit" and "Allow Edit on create" property to Yes on Entity field level 2. Overide method mapEntityToDataSource() at Entity level and call skipDataSourceValidateField() with true as parameter as shown in below example public void mapEntityToDataSource(DataEntityRuntimeContext _entityCtx, ...
Comments
Post a Comment