Here we will see how to get the default Dimension from the table GeneralJournalAccountEntryEntity.
1. Add DimensionCombinationEntity as DS
2. Add a relation with LedgerDimension and Recid as shown below.
3. Add the field Display value from DimensionCombination DS. This will give you the Default Dimension for GeneralJournalAccountEntryEntity.
Use the standard flexibility of the queries
The standard queries already support a level of flexibility with predefined functions. You can read more about that in this blog post:
http://daxmusings.codecrib.com/2013/07/custom-query-range-functions-using.html
The class “SysQueryRangeUtil” contains several predefined methods which can be used to make your query more dynamic. The format is plain and simple: ( some code ), you only need the parentheses around the method.
Just to explain how this can be used, here are some samples:
Many other scenarios are possible. This second option gives you the ultimate flexibility to create dynamic queries.
Change Tracking Query error in D365 Finance and Operations Data Export
Recently there was an issue with Change Tracking for BYOD. We keep getting the following error even after Change Tracking is enabled for the data entity.
Solution :
After debugging I found that the system will check if the record exists in the table "AifSqlCdcEnabledTables" with the field TableName and return int (1/0).
Run the below query in SQL to find if the list contains your table.
select RecId, * from AifSqlCdcEnabledTables where AifSqlCdcEnabledTables.TableName = 'XXXXX'
In my case, the Primary table was missing and causing the issue, whereas the secondary tables are present in the list. So I have changed the Entity to make the Primary Data source as secondary and secondary as Primary and the issue is fixed.
Below are the commands used to enable/disable change tracking in the SQL.
1. Enable change tracking on the database
ALTER DATABASE AXDBNAME
SET CHANGE_TRACKING = ON
(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)
2. Enable Change Tracking for a Table
ALTER TABLE TableName
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON)
3. Disable Change Tracking for a Database
ALTER DATABASE AdventureWorks2012
SET CHANGE_TRACKING = OFF
4. Disable Change Tracking for a Table
ALTER TABLE TableName
DISABLE CHANGE_TRACKING;
//How to create a new customer address using x++ code
static void MK_createCustomerAddress(Args _args)
{
LogisticsPostalAddress address;
LogisticsLocation location;
LogisticsAddressCountryRegion conuntry;
LogisticsAddressState state;
DirPartyPostalAddressView addressView;
DirPartyLocation partylocation;
DirParty dirParty;
DirPartyTable dirPartyTable;
CustTable custTable;
container roles;
LogisticsPostalAddressEntity postalAddressEntity;
LogisticsPostalAddressView paddressView;
date dVF,dvt;
select custTable
join dirPartyTable where custtable.Party == dirPartyTable.RecId
//join location where dirPartyTable.PrimaryAddressLocation == location.RecId
//&& location. == "Mrs Carol Davis"
//join address where address.Location == location.RecId
&& custtable.AccountNum == "C012436877";
if (dirPartytable.RecId)
{
conuntry = LogisticsAddressCountryRegion::findByISOCode('GB');
//state = LogisticsAddressState::find(conuntry
location.Description = 'Mr paddressView';
location.IsPostalAddress = true;
location.insert();
address.Street = "Mr paddressView 909 Market St 3";
address.ZipCode = "LE65 1AH";
address.City = "Ashby";
//address.State =
address.CountryRegionId = "GBR";
address.Location = location.RecId;
dvf = str2Date("08/9/2022", 213);
dvt = str2Date("08/9/2029", 213);
address.ValidFrom = DateTimeUtil::newDateTime(dvf,0);
address.ValidTo = DateTimeUtil::newDateTime(dateMax(),0);
//partylocation.Party = CustTable.Party;
addressView.initFromPostalAddress(address);
addressView.Location = address.Location;
addressView.State = 'Derbyshire';
//addressView.LocationName = logisticsLocation.Description;
addressView.IsPrimary = true;
addressView.LocationName = location.Description;
addressView.Party = CustTable.Party;
// addressview.initFromPostalAddress(address);
paddressView.initFromPartyPostalAddressView(addressView);
//paddressView.insert();
postalAddressEntity = LogisticsPostalAddressEntity::construct();
postalAddressEntity.createPostalAddress(paddressView);
DirParty = DirParty::constructFromPartyRecId(CustTable.Party);
roles = [LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Business).RecId];
DirParty.createOrUpdatePostalAddress(addressView,roles);
//
info(strFmt("Customer %1 Description %2 Address %3",custtable.AccountNum,addressView.LocationName,address.Street));
}
info("done");
}
[Form]
public class MKCustomLookupForm extends FormRun
{
[DataSource]
class MKCustomDSTable
{
[DataField]
class FieldIdCust
{
/// <summary>
/// </summary>
/// <param name = "_formControl">Form control</param>
/// <param name = "_filterStr">Fileter condition, if any</param>
public void lookup(FormControl _formControl, str _filterStr)
{
CustTable custTable;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(MKTable), _formControl);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
queryBuildDataSource = query.addDataSource(tablenum(MKTable));
queryBuildDataSource.addSortField(fieldNum(MKTable, FieldId), SortOrder::Ascending);
sysTableLookup.addLookupfield(fieldnum(MKTable, FieldId), true);
sysTableLookup.addLookupfield(fieldnum(MKTable, FieldName));
sysTableLookup.parmQuery(query);
//logic
sysTableLookup.parmTmpBuffer(fieldList);
sysTableLookup.performFormLookup();
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
[FormDataFieldEventHandler(formDataFieldStr(VendTable, VendTable, ProcessToProphet), FormDataFieldEventType::Validated)]
public static void ProcessToProphet_OnValidated(FormDataObject sender, FormDataFieldEventArgs e)
{
var dataObject = sender as FormDataObject;
var args = e as FormDataFieldCancelEventArgs;
DirPartyBaseType dirPartyBaseTypeOrg;
FormDataSource dataSource = sender.datasource();
FormRun element = dataSource.formRun();
FormControl dirtype = element.design(0).controlName("type");
str dirPartyBaseTypestr = dirtype.valueStr();
dirPartyBaseTypeOrg = str2Enum(dirPartyBaseTypeOrg , dirPartyBaseTypestr);
// info (strFmt ("%1 ", dirtype.valueStr()) ) ;
// DirPartyBaseType selected = any2Enum(dirtype.valueStr());
if (args != null && dataObject != null)
{
var vendTable_ds = dataObject.datasource() as FormDataSource;
if (vendTable_ds != null)
{
VendTable vendRec = vendTable_ds.cursor() as VendTable;
if (vendRec.RecId > 0)
{
if (dirPartyBaseTypeOrg != DirPartyBaseType::Organization)
{
boolean doCancel = !checkFailed("Not Organization");
args.cancel(doCancel);
}
}
}
}
}
