AX HELPER

Service class to get the selected record and deleted matching records and refresh the form data source in D365 F&O

2026-07-04T00:17:04.401+05:30

[DataContractAttribute]

class ABCUserProfilesBulkDeleteContract

{

UserId userId;

[DataMemberAttribute('UserId')]

public UserId parmUserId(UserId _userId = userId)

{

userId = _userId;

return userId;

}

==controller class================

internal final class ABCUserProfilesBulkDeleteController extends SysOperationServiceController

{

protected void new()

{

super(classStr(ABCUserProfilesBulkDeleteService),

methodStr(ABCUserProfilesBulkDeleteService, process),

SysOperationExecutionMode::Synchronous);

this.parmShowDialog(false);

this.parmLoadFromSysLastValue(false);

}

public static ABCUserProfilesBulkDeleteController construct()

{

return new ABCUserProfilesBulkDeleteController();

}

public static void main(Args _args)

{

ABCUserProfilesBulkDeleteController controller;

ABCUserProfilesBulkDeleteContract contract;

UserInfo userInfo;

userInfo = _args.record();

if (!userInfo || !userInfo.id)

{

throw error("@ABCFinanceLabel:SelectedUserInfoRecordIsNotValid");

}

controller = ABCUserProfilesBulkDeleteController::construct();

controller.parmArgs(_args);

contract = controller.getDataContractObject() as ABCUserProfilesBulkDeleteContract;

if (!contract)

{

throw error("@ABCFinanceLabel:UnableToInitializeContractClass");

}

contract.parmUserId(userInfo.id);

controller.startOperation();

}

/// <summary>

///

/// </summary>

/// <param name = "_executionMode"></param>

/// <param name = "_asyncResult"></param>

protected void afterOperation(SysOperationExecutionMode _executionMode, AifAsyncResult _asyncResult)

{

super(_executionMode, _asyncResult);

FormRun callerForm;

FormDataSource associationDs,userInfoDS;

callerForm = this.parmArgs().caller() as FormRun;

if (callerForm)

{

associationDs = callerForm.dataSource(formDataSourceStr(SysUserManagement, CARM_JobProfileSysUserAssociation));

userInfoDS = callerForm.dataSource(formDataSourceStr(SysUserManagement, UserInfo));

if (associationDs)

{

associationDs.research(true);

associationDs.refresh();

userInfoDS.research(true);

userInfoDS.refresh();

}

============service class======

[SysEntryPoint(true)]

class ABCUserProfilesBulkDeleteService

{

public void process(ABCUserProfilesBulkDeleteContract _contract)

{

UserId userId;

UserInfo userInfo;

CARM_JobProfileSysUserAssociation association;

int64 recordsToDelete;

userId = _contract.parmUserId();

if (!userId)

{

throw error("@ABCFinanceLabel:UserIDIsRequired");

}

select firstonly RecId

from userInfo

where userInfo.id == userId;

if (!userInfo.RecId)

{

throw error(strFmt("@ABCFinanceLabel:UserDoesNotExistInUserInfo", userId));

}

select count(RecId)

from association

where association.UserId == userId;

recordsToDelete = association.RecId;

if (recordsToDelete == 0)

{

info(strFmt("@ABCFinanceLabel:NoJobProfileAssociationRecordsFoundForUser", userId));

return;

}

ttsbegin;

delete_from association

where association.UserId == userId;

ttscommit;

info(strFmt("@ABCFinanceLabel:JobProfileAssociationRecordsDeletedForUser",recordsToDelete,userId));

}

Merge Dimensions (MainAccountId and LedgerDimensions) defaultDimension in D365 F&O and X++

2026-05-06T00:51:00.002+05:30

public DimensionDynamicAccount getLedgerDimension(container _conData, TransDate _transDate = today())

{

int hierarchyCount;

int hierarchyIdx;

DimensionDynamicAccount ledgerRecId;

MainAccountNum mainAccountId = conPeek(_conData, 1);

MainAccount mainAccount;

RefRecId recordvalue;

DimensionAttribute dimensionAttribute;

DimensionAttributeValue dimensionAttributeValue;

DimensionSetSegmentName DimensionSet;

DimensionStorage dimStorage;

LedgerAccountContract LedgerAccountContract = new LedgerAccountContract();

DimensionAttributeValueContract ValueContract;

List valueContracts = new List(Types::Class);

int currentYear;

Name PopDim;

str dimValue;

dimensionAttributeValueCombination dimensionAttributeValueCombination;

mainAccount = MainAccount::findByMainAccountId(mainAccountId);

recordvalue = DimensionHierarchy::getAccountStructure(mainAccount.RecId,Ledger::current());

hierarchyCount = DimensionHierarchy::getLevelCount(recordvalue);

DimensionSet = DimensionHierarchyLevel::getDimensionHierarchyLevelNames(recordvalue);

for(hierarchyIdx = 1;hierarchyIdx<=hierarchyCount;hierarchyIdx++)

{

if(hierarchyIdx == 1)

{

continue;

}

dimensionAttribute = DimensionAttribute::findByLocalizedName(DimensionSet[hierarchyIdx],false, CompanyInfo::find().LanguageId);

if(dimensionAttribute)

{

dimValue = conPeek(_conData,hierarchyIdx);

dimensionAttributeValue = DimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,dimValue);

if(dimensionAttributeValue)

{

ValueContract = new DimensionAttributeValueContract();

ValueContract.parmName(dimensionAttribute.Name) ;

ValueContract.parmValue(dimensionAttributeValue.CachedDisplayValue);

valueContracts.addEnd(ValueContract);

}

LedgerAccountContract.parmMainAccount(mainAccountId);

LedgerAccountContract.parmValues(valueContracts);

dimStorage = DimensionServiceProvider::buildDimensionStorageForLedgerAccount(LedgerAccountContract);

dimensionAttributeValueCombination = DimensionAttributeValueCombination::find(dimStorage.save());

ledgerRecId = dimensionAttributeValueCombination.RecId;

return ledgerRecId;

}

Customer inbound custom service in D365 F&O with X++

2025-12-21T00:22:00.004+05:30

[DataContractAttribute]

class GOD_CustomerCreateContract

{

str accountNum; // Optional; if blank, a number sequence will be used

str name; // Required

str custGroup; // Required

str currency; // Optional; will fall back to company defaults if you handle that logic

str email; // Optional (see note below)

str phone; // Optional (see note below)

str street; // Optional

str city; // Optional

str state; // Optional

str zipCode; // Optional

str country; // Optional but recommended if address is sent

str company; // Optional; if set, code runs under this company

// When true, creates a Person party; otherwise Organization

boolean isPerson;

[DataMemberAttribute("AccountNum"), AifCollectionTypeAttribute('NONE', Types::String)]

public str parmAccountNum(str _accountNum = accountNum)

{

accountNum = _accountNum;

return accountNum;

}

[DataMemberAttribute("Name")]

public str parmName(str _name = name)

{

name = _name;

return name;

}

[DataMemberAttribute("CustGroup")]

public str parmCustGroup(str _custGroup = custGroup)

{

custGroup = _custGroup;

return custGroup;

}

[DataMemberAttribute("Currency")]

public str parmCurrency(str _v = currency)

{

currency = _v;

return currency;

}

[DataMemberAttribute("Email")]

public str parmEmail(str _v = email)

{

email = _v;

return email;

}

[DataMemberAttribute("Phone")]

public str parmPhone(str _v = phone)

{

phone = _v;

return phone;

}

[DataMemberAttribute("Street")]

public str parmStreet(str _v = street)

{

street = _v;

return street;

}

[DataMemberAttribute("City")]

public str parmCity(str _v = city)

{

city = _v;

return city;

}

[DataMemberAttribute("State")]

public str parmState(str _v = state)

{

state = _v;

return state;

}

[DataMemberAttribute("ZipCode")]

public str parmZipCode(str _v = zipCode)

{

zipCode = _v;

return zipCode;

}

[DataMemberAttribute("Country")]

public str parmCountry(str _v = country)

{

country = _v;

return country;

}

[DataMemberAttribute("Company")]

public str parmCompany(str _v = company)

{

company = _v;

return company;

}

[DataMemberAttribute("IsPerson")]

public boolean parmIsPerson(boolean _v = isPerson)

{

isPerson = _v;

return isPerson;

}

[DataContractAttribute]

class GOD_CustomerCreateResponse

{

boolean success;

str message;

str accountNum;

str partyNumber;

RecId custRecId;

RecId partyRecId;

[DataMemberAttribute("Success")]

public boolean parmSuccess(boolean _v = success)

{

success = _v;

return success;

}

[DataMemberAttribute("Message")]

public str parmMessage(str _v = message)

{

message = _v;

return message;

}

[DataMemberAttribute("AccountNum")]

public str parmAccountNum(str _v = accountNum)

{

accountNum = _v;

return accountNum;

}

[DataMemberAttribute("PartyNumber")]

public str parmPartyNumber(str _v = partyNumber)

{

partyNumber = _v;

return partyNumber;

}

[DataMemberAttribute("CustRecId")]

public RecId parmCustRecId(RecId _v = custRecId)

{

custRecId = _v;

return custRecId;

}

[DataMemberAttribute("PartyRecId")]

public RecId parmPartyRecId(RecId _v = partyRecId)

{

partyRecId = _v;

return partyRecId;

}

class GOD_CustomerCreateService

{

private GOD_CustomerCreateResponse buildResponse(boolean _success, str _message, str _accountNum = '', RecId _custRecId = 0, RecId _partyRecId = 0)

{

GOD_CustomerCreateResponse resp = new GOD_CustomerCreateResponse();

DirPartyTable party;

resp.parmSuccess(_success);

resp.parmMessage(_message);

resp.parmAccountNum(_accountNum);

resp.parmCustRecId(_custRecId);

resp.parmPartyRecId(_partyRecId);

if (_partyRecId)

{

party = DirPartyTable::findRec(_partyRecId);

resp.parmPartyNumber(party.PartyNumber);

}

return resp;

}

/// <summary>

/// Creates a customer with party, and optionally a postal address.

/// </summary>

/// <param name="_cust">Data contract with customer details.</param>

/// <returns>Response contract with result info.</returns>

[SysEntryPointAttribute(true)]

public GOD_CustomerCreateResponse createCustomer(GOD_CustomerCreateContract _cust)

{

GOD_CustomerCreateResponse response;

str targetCompany = _cust.parmCompany();

// Simple validation

if (!_cust.parmName())

{

return this.buildResponse(false, "Name is required.");

}

if (!_cust.parmCustGroup())

{

return this.buildResponse(false, "CustGroup is required.");

}

// Validate customer group

if (!CustGroup::exist(_cust.parmCustGroup()))

{

return this.buildResponse(false, strFmt("CustGroup %1 does not exist.", _cust.parmCustGroup()));

}

// Run in the specified company, if any

if (targetCompany)

{

changecompany(targetCompany)

{

response = this.createCustomerInCurrentCompany(_cust);

}

else

{

response = this.createCustomerInCurrentCompany(_cust);

}

return response;

}

private GOD_CustomerCreateResponse createCustomerInCurrentCompany(GOD_CustomerCreateContract _cust)

{

CustTable custTable;

NumberSeq numSeq;

boolean generatedAccount = false;

str accountNum = _cust.parmAccountNum();

RecId partyRecId;

GOD_CustomerCreateResponse resp;

DirParty dirParty;

DirPartyPostalAddressView dirPartyPostalAddressView;

DirPartyContactInfoView dirPartyContactInfo;

try

{

ttsbegin;

// If caller supplied AccountNum and it already exists, return success (idempotent)

if (accountNum && CustTable::exist(accountNum))

{

custTable = CustTable::find(accountNum, true);

ttscommit;

return this.buildResponse(true, "Customer already exists; no action taken.", accountNum, custTable.RecId, custTable.Party);

}

// Generate account from number sequence if not provided

if (!accountNum)

{

NumberSequenceReference nsRef = CustParameters::numRefCustAccount();

if (!nsRef)

{

throw error("Customer account number sequence reference is not configured.");

}

numSeq = NumberSeq::newGetNum(nsRef);

accountNum = numSeq.num();

generatedAccount = true;

}

// Create Party (Organization or Person)

DirPartyType partyType = _cust.parmIsPerson() ? DirPartyType::Person : DirPartyType::Organization;

//partyRecId = DirParty::createParty(partyType, _cust.parmName());

// Create the customer

custTable.clear();

custTable.initValue(); // defaults

custTable.AccountNum = accountNum;

custTable.CustGroup = _cust.parmCustGroup();

custTable.PaymTermId = CustGroup::find(custTable.CustGroup).PaymTermId;

//custTable.Party = partyRecId;

if (_cust.parmCurrency())

{

custTable.Currency = _cust.parmCurrency();

}

custTable.insert(partyType,_cust.parmName());

// Mark number sequence as used if we generated it

if (generatedAccount && numSeq)

{

numSeq.used();

}

// Optional: create postal address if provided

dirParty = DirParty::constructFromCommon(custTable);

dirPartyPostalAddressView.city = _cust.parmCity();

dirPartyPostalAddressView.Street = _cust.parmStreet();

dirPartyPostalAddressView.State = _cust.parmState();

dirPartyPostalAddressView.County = _cust.parmCountry();

dirPartyPostalAddressView.IsPrimary = NoYes::Yes;

dirParty.createOrUpdatePostalAddress(dirPartyPostalAddressView);

//if (_cust.parmStreet() || _cust.parmCity() || _cust.parmZipCode() || _cust.parmCountry())

//{

// this.createPrimaryPostalAddress(partyRecId,

// _cust.parmStreet(),

// _cust.parmCity(),

// _cust.parmState(),

// _cust.parmZipCode(),

// _cust.parmCountry());

//}

dirPartyContactInfo.LocationName = "Email address";

dirPartyContactInfo.Locator = "abc@gmail.com";

dirPartyContactInfo.Type = LogisticsElectronicAddressMethodType::Email;

dirPartyContactInfo.IsPrimary = NoYes::Yes;

dirParty.createOrUpdateContactInfo(dirPartyContactInfo);

// Optional: add electronic addresses (email/phone)

// NOTE: There are multiple helper APIs; uncomment and adapt as per your standard.

if (_cust.parmEmail())

{

DirPartyContactInfo::addElectronicAddress(partyRecId,

LogisticsElectronicAddressMethodType::Email,

_cust.parmEmail(),

true, // isPrimary

"Primary email");

}

if (_cust.parmPhone())

{

DirPartyContactInfo::addElectronicAddress(partyRecId,

LogisticsElectronicAddressMethodType::Phone,

_cust.parmPhone(),

false, // isPrimary

"Main phone");

}

ttscommit;

resp = this.buildResponse(true, "Customer created successfully.", accountNum, custTable.RecId, partyRecId);

}

catch (Exception::Error)

{

// Rollback handled automatically by the runtime on exception

resp = this.buildResponse(false, infolog.text(), accountNum);

}

catch

{

resp = this.buildResponse(false, "Unknown error creating customer.", accountNum);

}

return resp;

}

/// <summary>

/// Creates a primary postal address for the specified party.

/// </summary>

private void createPrimaryPostalAddress(RecId _partyRecId, str _street, str _city, str _state, str _zip, str _country)

{

// Use logistics location framework

LogisticsLocation loc = LogisticsLocation::construct();

RecId locationRecId;

LogisticsPostalAddress postal = LogisticsPostalAddress::construct();

DirPartyLocation partyLocation = DirPartyLocation::construct();

// Create a location

locationRecId = loc.createLocation();

// Create postal address record

postal.parmLocation(locationRecId);

postal.parmIsPrimary(true);

postal.parmStreet(_street);

postal.parmCity(_city);

postal.parmState(_state);

postal.parmZipCode(_zip);

postal.parmCountryRegionId(_country);

postal.create();

// Link the location to the party

partyLocation.parmParty(_partyRecId);

partyLocation.parmLocation(locationRecId);

partyLocation.parmIsPostalAddress(true);

partyLocation.parmIsPrimary(true);

partyLocation.create();

}

internal final class GOD_CustomerCreateTestingJob

{

/// <summary>

/// Class entry point. The system will call this method when a designated menu

/// is selected or when execution starts and this class is set as the startup class.

/// </summary>

/// <param name = "_args">The specified arguments.</param>

public static void main(Args _args)

{

GOD_CustomerCreateContract contract = new GOD_CustomerCreateContract();

GOD_CustomerCreateService customerCreateService = new GOD_CustomerCreateService();

contract.parmAccountNum('US-104');

contract.parmCompany('USMF');

contract.parmName('TestCust');

contract.parmCustGroup('90');

contract.parmStreet('KPHB');

contract.parmCity('Chennai');

contract.parmStreet('Adayar');

contract.parmCountry('India');

contract.parmState('TamilNadu');

customerCreateService.createCustomer(contract);

}

{

"_cust": {

"Company": "USMF",

"Name": "Contoso Retail Pvt Ltd",

"CustGroup": "10",

"Currency": "USD",

"Street": "1 Microsoft Way",

"City": "Redmond",

"State": "WA",

"ZipCode": "98052",

"Country": "US",

"IsPerson": false

}

Post URL:

How to download the multiple document attchments in D365 F&O Using X++

2025-12-21T00:07:00.003+05:30

The below code is to download the attachments which are attached in Vendor Invoice journals

AP->Inquiries and reports->Invoice-> Invoice Journal

The above screen added new button to download the multiple selected records attachments.

[ExtensionOf(formControlStr(VendInvoiceJournal,ABCDownloadFile))]

final class ABC_VendInvoiceJournalButton_Extension

{

public void clicked()

{

FormButtonControl fbc = this as FormButtonControl;

VendInvoiceJour vendInvoiceJour;

DocuRef docuRef;

DocuValue docuValue;

str docURL;

next clicked();

FormRun formRun = fbc.formRun();

FormDataSource fds = formRun.dataSource();

vendInvoiceJour = fds.getFirst(true);

while(vendInvoiceJour.RecId!=0)

{

select firstOnly docuRef

where docuRef.RefTableId == vendInvoiceJour.TableId

&& docuRef.RefRecId == vendInvoiceJour.RecId

&& docuRef.RefCompanyId == vendInvoiceJour.DataAreaId;

if (docuRef.RecId)

{

docuValue = DocuValue::find(docuRef.ValueRecId);

if (docuValue.RecId)

{

docURL = File::SendFileToTempStore(DocumentManagement::getAttachmentStream(docuRef),docuValue.fileName+'.'+docuValue.FileType,classStr(FileUploadTemporaryStorageStrategy),true);

Browser browser = new Browser();

browser.navigate(docURL,true,false);

}

else

{

warning("No file attachment found for the selected record.");

}

else

{

warning("No document reference found for the selected record.");

}

vendInvoiceJour = fds.getNext();

}

DB restore production DB to DEV environment in D365 FO using Bacpac file

2025-11-21T12:27:00.002+05:30

https://www.linkedin.com/pulse/restore-production-database-dev-environment-d365fo-using-abbas-tfwbe

SQLPackage link : https://www.linkedin.com/redir/redirect?url=https%3A%2F%2Fgo%2Emicrosoft%2Ecom%2Ffwlink%2F%3Flinkid%3D2261576&urlhash=8Q0l&trk=article-ssr-frontend-pulse_little-text-block

Step1. Need to download SQL package

Stop all the required services

Rename the AXDB to AXDB Old

Run the command to connect to package extracted path

Then Run the below command. To import

SqlPackage.exe /a:import /sf:C:\SQLPackage\carlsbergbalkanchinabackup.bacpac /tsn:vm-WE-MD09-d-1 /tdn:AxDB /p:CommandTimeout=200000 /TargetEncryptConnection:False

tsn (target server name) – The name of the SQL Server to import into.

tdn (target database name) – The name of the database to import into. The database should not already exist.

sf (source file) – The path and name of the file to import from.

/p:CommandTimeout=200000 seconds approximately 55 hours timeout for command

/TargetEncryptConnectionLFalse this is the updated script which will keep us away from certificate errors

After DB import run the below script

CREATE USER axdeployuser FROM LOGIN axdeployuser

EXEC sp_addrolemember 'db_owner', 'axdeployuser'

CREATE USER axdbadmin FROM LOGIN axdbadmin

EXEC sp_addrolemember 'db_owner', 'axdbadmin'

CREATE USER axmrruntimeuser FROM LOGIN axmrruntimeuser

EXEC sp_addrolemember 'db_datareader', 'axmrruntimeuser'

EXEC sp_addrolemember 'db_datawriter', 'axmrruntimeuser'

CREATE USER axretaildatasyncuser FROM LOGIN axretaildatasyncuser

CREATE USER axretailruntimeuser FROM LOGIN axretailruntimeuser

CREATE USER axdeployextuser FROM LOGIN axdeployextuser

CREATE USER [NT AUTHORITY\NETWORK SERVICE] FROM LOGIN [NT AUTHORITY\NETWORK SERVICE]

EXEC sp_addrolemember 'db_owner', 'NT AUTHORITY\NETWORK SERVICE'

UPDATE T1

SET T1.storageproviderid = 0

, T1.accessinformation = ''

, T1.modifiedby = 'Admin'

, T1.modifieddatetime = getdate()

FROM docuvalue T1

WHERE T1.storageproviderid = 1 --Azure storage

DROP PROCEDURE IF EXISTS SP_ConfigureTablesForChangeTracking

DROP PROCEDURE IF EXISTS SP_ConfigureTablesForChangeTracking_V2

-- Begin Refresh Retail FullText Catalogs

DECLARE @RFTXNAME NVARCHAR(MAX);

DECLARE @RFTXSQL NVARCHAR(MAX);

DECLARE retail_ftx CURSOR FOR

SELECT OBJECT_SCHEMA_NAME(object_id) + '.' + OBJECT_NAME(object_id) fullname FROM SYS.FULLTEXT_INDEXES

WHERE FULLTEXT_CATALOG_ID = (SELECT TOP 1 FULLTEXT_CATALOG_ID FROM SYS.FULLTEXT_CATALOGS WHERE NAME = 'COMMERCEFULLTEXTCATALOG');

OPEN retail_ftx;

FETCH NEXT FROM retail_ftx INTO @RFTXNAME;

BEGIN TRY

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT 'Refreshing Full Text Index ' + @RFTXNAME;

EXEC SP_FULLTEXT_TABLE @RFTXNAME, 'activate';

SET @RFTXSQL = 'ALTER FULLTEXT INDEX ON ' + @RFTXNAME + ' START FULL POPULATION';

EXEC SP_EXECUTESQL @RFTXSQL;

FETCH NEXT FROM retail_ftx INTO @RFTXNAME;

END

END TRY

BEGIN CATCH

PRINT error_message()

END CATCH

CLOSE retail_ftx;

DEALLOCATE retail_ftx;

-- End Refresh Retail FullText Catalogs

--Begin create retail channel database record--

declare @ExpectedDatabaseName nvarchar(64) = 'Default';

declare @DefaultDataGroupRecId BIGINT;

declare @ExpectedDatabaseRecId BIGINT;

IF NOT EXISTS (select 1 from RETAILCONNDATABASEPROFILE where NAME = @ExpectedDatabaseName)

BEGIN

select @DefaultDataGroupRecId = RECID from RETAILCDXDATAGROUP where NAME = 'Default';

insert into RETAILCONNDATABASEPROFILE (DATAGROUP, NAME, CONNECTIONSTRING, DATASTORETYPE)

values (@DefaultDataGroupRecId, @ExpectedDatabaseName, NULL, 0);

select @ExpectedDatabaseRecId = RECID from RETAILCONNDATABASEPROFILE where NAME = @ExpectedDatabaseName;

insert into RETAILCDXDATASTORECHANNEL (CHANNEL, DATABASEPROFILE)

select RCT.RECID, @ExpectedDatabaseRecId from RETAILCHANNELTABLE RCT

inner join RETAILCHANNELTABLEEXT RCTEX on RCTEX.CHANNEL = RCT.RECID

update RETAILCHANNELTABLEEXT set LIVECHANNELDATABASE = @ExpectedDatabaseRecId where LIVECHANNELDATABASE = 0

END;

---------------

Restart the required services.
Refresh models and build the Models

How to add the Display method in the form level in D365 F&O

2025-08-24T00:49:00.001+05:30

The below examle is to add the form -Data source level adding display method and assigning to form design control.

AXmodel file import in D365 F&O

2025-04-25T19:47:00.002+05:30

ModelUtil.exe -import -metadatastorepath=k:\aosservice\packageslocaldirectory -file=C:\Temp\DEST.axmodel

X++ code to get the time and add and substract using the current date time in D365 F&O

2025-04-10T20:18:00.006+05:30

utcdatetime dateTime = DateTimeUtil::getSystemDateTime();//DateTimeUtil::utcNow();

utcdatetime newDateTime = DateTimeUtil::addMinutes(dateTime, -20);

Info(strFmt("Current time: %1 redueced Time: %2 ",dateTime,newDateTime));

X++ code to create new user in D365 F&O

2025-04-09T00:41:00.000+05:30

public void createUser(UserId _userId,Name _userName)

{

UserInfo userInfo;

SecurityUserRole userRole,userRoleToSave;

SecurityRole securityRole;

// Step 1: Create new User Info record

ttsBegin;

userInfo.id = _userId;

userInfo.Name = _userName;

userInfo.networkAlias = Xine_UserAcessTable.Email;

userInfo.networkDomain = Xine_UserAcessTable.NetworkDomain;

userInfo.ObjectId = Xine_UserAcessTable.TelemetryId;

userInfo.enable = Xine_UserAcessTable.Enabled;

userInfo.insert(); // Save the user info record

info(strFmt('User created: %1', userInfo.id));

select securityRole

where securityRole.Name == "System user";

select forupdate userRoleToSave

where userRoleToSave.User == _userId &&

userRoleToSave.SecurityRole == securityRole.recId;

if ( userRoleToSave.recId)

{

userRoleToSave.AssignmentMode = RoleAssignmentMode::Manual;

userRoleToSave.AssignmentStatus = RoleAssignmentStatus::Enabled;

userRoleToSave.update();

}

else

{

userRole.User = _userId;

userRole.SecurityRole = securityRole.recId; // Set the role of the user (System User role is used here as an example)

userRole.AssignmentMode = RoleAssignmentMode::Manual;

userRole.AssignmentStatus = RoleAssignmentStatus::Enabled;

userRole.insert(); // Save user role

info(strFmt('Role assigned to user: %1', userRole.SecurityRole));

}

// Commit the transaction

ttsCommit;

}

Ledger Voucher creation Framework and x++ code to create ledger voucher

2024-04-19T01:06:00.002+05:30

Please click her for MS reference file

Below is the out of the box example reference and code.

SalesInvoiceJournalPostSubBill_Extension->endPost()

this.postUnbilledRevenueAndRevenueOffset();

LedgerVoucher ledgerVoucher = this.ledgerVoucher;

LedgerVoucherObject ledgerVoucherObject = ledgerVoucher.findLedgerVoucherObject();

LedgerDimensionAccount unbilledRevenueAccount = LedgerDimensionFacade::serviceCreateLedgerDimension(unbilledRevenueTransactionLine.SubBillUnbilledRevenueAccount, salesLine.DefaultDimension);

LedgerDimensionAccount unbilledRevenueOffsetAccount = LedgerDimensionFacade::serviceCreateLedgerDimension(unbilledRevenueTransactionLine.SubBillUnbilledRevenueOffsetAccount, salesLine.DefaultDimension);

CurrencyExchangeHelper exchangeRateHelper = this.getExchangeRateHelper(ledgerVoucherObject, detailLine.SubBillSchedLineRecId);

Amount revenueOffsetAmt = abs(custInvoiceTrans.lineAmount) + custInvoiceTrans.SumLineDisc;

Amount revenueAmt = (revenueOffsetAmt * -1);

// Unbilled Revenue

LedgerVoucherTransObject ledgerVoucherTransObject = LedgerVoucherTransObject::newTransactionAmountDefault(

ledgerVoucherObject,

LedgerPostingType::SalesRevenue,

unbilledRevenueAccount,

custInvoiceTrans.CurrencyCode,

revenueAmt,

exchangeRateHelper);

ledgerVoucherTransObject.parmText("@SubBill:UnbilledRevenueAccount");

ledgerVoucher.addTrans(ledgerVoucherTransObject);

// Unbilled Revenue Offset

// Dr. Accounts Receivable + Dr. Unbilled discount offset = Cr. Unbilled Revenue offset

ledgerVoucherTransObject = LedgerVoucherTransObject::newTransactionAmountDefault(

ledgerVoucherObject,

LedgerPostingType::SalesRevenueOffset,

unbilledRevenueOffsetAccount,

custInvoiceTrans.CurrencyCode,

revenueOffsetAmt,

exchangeRateHelper);

ledgerVoucherTransObject.parmText("@SubBill:UnbilledRevenueOffsetAccount");

ledgerVoucher.addTrans(ledgerVoucherTransObject);

ledgerVoucherObject.lastTransTxt();

Trial balance export to Azure Blob Storage

2024-02-08T16:46:00.001+05:30

The file will be automatically generated from D365 using a batch job.

The trial balance file should include all dimensions. (Main-Dept-Cost center-Business unit-Value stream)

/// contract class to export file in azure blob storag

/// </summary>

[DataContractAttribute,

SysOperationContractProcessing(classStr(NPHFloQastExportUIBuilder))]

internal final class ExportContract extends SysOperationAttributedDataContractInfo

{

private FromDate fromDate;

private ToDate toDate;

private DateCode period;

private Name primaryDimensionFocus;

private DimensionSetName dimensionSetName;

[DataMemberAttribute("@SYS2168")]

public FromDate parmFromDate(FromDate _fromDate = fromDate)

{

fromDate = _fromDate;

return _fromDate;

}

[DataMemberAttribute("@SYS22882")]

public ToDate parmToDate(ToDate _toDate = toDate)

{

toDate = _toDate;

return _toDate;

}

[DataMemberAttribute("@SYS22717")]

public DateCode parmPeriod(DateCode _period = period)

{

period = _period;

return _period;

}

[DataMemberAttribute("@SYS83218")]

public DimensionSetName parmDimensionSetName(DimensionSetName _dimensionSetName = dimensionSetName)

{

dimensionSetName = _dimensionSetName;

return dimensionSetName;

}

Create Controller class

internal final class ExportController extends SysOperationServiceController

{

public static void main(Args args)

{

ExportController sysOperationController = ExportController::construct();

sysOperationController.parmClassName(classStr(ExportService));

sysOperationController.parmMethodName(methodStr(ExportService, operation));

sysOperationController.parmExecutionMode(SysOperationExecutionMode::Synchronous);

sysOperationController.startOperation();

}

private static ExportController construct()

{

ExportController controller = new ExportController();

controller.parmDialogCaption("Caption");

return controller;

}

public ClassDescription caption()

{

return "Caption";

}

protected boolean canRunInNewSession()

{

return true;

}

/// <summary>

///

/// </summary>

/// <param name = "_dialogCaption"></param>

/// <returns></returns>

public LabelType parmDialogCaption(LabelType _dialogCaption = dialogCaption)

{

return "Caption";

}

Crate UI builder class

internal final class ExportUIBuilder extends SysOperationAutomaticUIBuilder

{

DialogField dialogPeriodName;

DialogField dialogFromDate;

DialogField dialogToDate;

DialogField dialogDimset ;

private DateCode period;

private FromDate fromDate;

private ToDate toDate;

private DimensionSetName dimensionSetName;

ExportContract dataContract;

public void build()

{

Dialog dialogLocal = dialog as Dialog;

dataContract = this.getContract();

dialogPeriodName = this.addDialogField(methodstr(ExportContract,parmPeriod),dataContract);

dialogPeriodName.label("@SYS22717");

dialogPeriodName.lookupButton(2);

dialogFromDate = this.addDialogField(methodstr(ExportContract,parmFromDate),dataContract);

dialogToDate = this.addDialogField(methodstr(ExportContract,parmToDate),dataContract);

dialogDimset = this.addDialogField(methodstr(ExportContract,parmDimensionSetName),dataContract);

}

public boolean periodModified(FormStringControl _control)

{

DateCode dateCode ;

LedgerPeriodCode ledgerPeriodCode;

dialogPeriodName.value(_control.valueStr());

dateCode = dialogPeriodName.value();

ledgerPeriodCode = ledgerPeriodCode::find(dateCode);

dialogFromDate.value(ledgerPeriodCode.fromDate());

dialogToDate.value(ledgerPeriodCode.toDate());

return true;

}

[Hookable(false)]

public void postRun()

{

super();

dialogPeriodName.value(this.getContract().parmPeriod());

dialogPeriodName.fieldControl().mandatory(true);

dialogPeriodName.registerOverrideMethod(

methodStr(FormStringControl, modified),

methodStr(ExportUIBuilder, periodModified),

this);

dialogFromDate.value(this.getContract().parmFromDate());

dialogFromDate.allowEdit(false);

dialogToDate.value(this.getContract().parmToDate());

dialogToDate.allowEdit(false);

dialogDimset.value(this.getContract().parmDimensionSetName());

}

private ExportContract getContract()

{

if (dataContract == null)

{

dataContract = this.dataContractObject() as ExportContract;

}

return dataContract;

}

/// <summary>

/// 15933 - Flocast integration

/// exports file in azure blob storage

/// </summary>

using Microsoft.WindowsAzure.Storage;

using System.Text;

create service class

internal final class ExportService

{

int records ;

Filename currentFileName ;

date startDate ;

date endDate ;

PeriodName periodName ;

LedgerParameters ledgerParameters ;

DimensionSetName dimensionSetName ;

public void new()

{

LedgerPeriodCode ledgerPeriodCode ;

super();

ledgerPeriodCode = ledgerPeriodCode::find("CP");

startDate = ledgerPeriodCode.fromDate() ;

endDate = ledgerPeriodCode.toDate() ;

periodName = ledgerPeriodCode.Code ;

}

public void operation(ExportContract _dataContract)

{

System.Exception ex;

periodName = _dataContract.parmPeriod() ;

startDate = _dataContract.parmFromDate() ;

endDate = _dataContract.parmToDate() ;

dimensionSetName = _dataContract.parmDimensionSetName() ;

ledgerParameters = LedgerParameters::find();

Filename filename = ledgerParameters.FileName ? ledgerParameters.FileName : "GLAccounts";

str timestamp = strReplace(time2str(timeNow(),TimeSeparator::Colon, TimeSeparator::Colon),":","_");

currentFileName = strFmt("%1_%2_%3_%4.csv",filename,

date2str(startDate,321,2,DateSeparator::None,2,DateSeparator::None,4),

date2str(endDate,321,2,DateSeparator::None,2,DateSeparator::None,4),

timestamp);

//time2str(timeNow(),TimeSeparator::Colon, TimeSeparator::Colon));

try

{

this.runExport();

info(strFmt("@Newport:NPHFloQastRecords",records, currentFileName));

}

catch (Exception::CLRError)

{

ex = CLRInterop::getLastException();

if (ex != null)

{

error(ex.ToString());

}

catch (Exception::CodeAccessSecurity)

{

error("@Newport:NPHFloQastFileIssue");

}

TextStreamIo openFile()

{

FileIOPermission perm;

;

info("file: " + currentFileName);

perm = new FileIOPermission(currentFilename, "w");

if (perm == null)

{

return null;

}

perm.assert();

TextStreamIo fileOut = TextStreamIo::constructForWrite();

return fileOut;

}

void runExport()

{

DimensionHierarchy dimHier ;

LedgerTrialBalanceTmp ledgerTrialBalanceTmp ;

LedgerTrialBalanceListPageBalanceParms balanceParameters ;

List postingLayers = new List(Types::Enum);

postingLayers.addEnd(currentOperationsTax::Current);

dimHier = DimensionHierarchy::findByTypeAndName(DimensionHierarchyType::Focus, dimensionSetName);

balanceParameters = LedgerTrialBalanceListPageBalanceParms::construct();

balanceParameters.loadDefault();

balanceParameters.parmPostingLayers(postingLayers);

balanceParameters.parmStartDate(startDate);

balanceParameters.parmEndDate(endDate);

balanceParameters.parmDimensionSetHierarchy(dimHier);

//info(strFmt("@SYS2168" + "%1", startDate));

//info(strFmt("@SYS22882" + "%1", endDate));

select firstOnly RecId from LedgerTrialBalanceTmp;

LedgerTrialBalanceTmp::calculateBalances_V2(

ledgerTrialBalanceTmp,

dimHier.Name,

balanceParameters.getStartDate(),

balanceParameters.getEndDate(),

balanceParameters.getIncludeOpeningPeriods(),

balanceParameters.getIncludeClosingAdjustments(),

balanceParameters.getIncludeClosingTransactions(),

balanceParameters.getPostingLayers(),

true);

this.writeFile(ledgerTrialBalanceTmp);

}

// 15933_Flocast integration

private void writeFile(LedgerTrialBalanceTmp _ledgerTrialBalanceTmp)

{

str recordStr ;

MainAccount mainAccount ;

AccountCategory accountCategory ;

str hasActivity ;

container con;

recordStr = strFmt("CostCenter,MainAccount,BusinessUnit,ValueStrem,Department,Name,OpeningBalance,Debit,Credit,ClosingBalance");

con += recordStr;

while select _ledgerTrialBalanceTmp

//join mainAccount where mainAccount.MainAccountId == _ledgerTrialBalanceTmp.DimensionValues[0]

{

accountCategory = mainAccount.accountCategory(false,"");

if (this.isSuspended(mainAccount))

{

continue;

}

if (_ledgerTrialBalanceTmp.AmountCredit == 0 && _ledgerTrialBalanceTmp.AmountDebit == 0)

{

hasActivity = "FALSE";

}

else

{

hasActivity = "TRUE";

}

recordStr = strFmt("%1,%2,%3,%4,%5,%6,%7,%8,%9,%10",

_ledgerTrialBalanceTmp.DimensionValues[1],

_ledgerTrialBalanceTmp.DimensionValues[2],

_ledgerTrialBalanceTmp.DimensionValues[3],

_ledgerTrialBalanceTmp.DimensionValues[4],

_ledgerTrialBalanceTmp.DimensionValues[5],

_ledgerTrialBalanceTmp.PrimaryFocusDescription,

num2Str(_ledgerTrialBalanceTmp.OpeningBalance,16,2,DecimalSeparator::Dot, ThousandSeparator::None),

num2Str(_ledgerTrialBalanceTmp.AmountDebit,16,2,DecimalSeparator::Dot, ThousandSeparator::None),

num2Str(_ledgerTrialBalanceTmp.AmountCredit,16,2,DecimalSeparator::Dot, ThousandSeparator::None),

num2Str(_ledgerTrialBalanceTmp.EndingBalance,16,2,DecimalSeparator::Dot, ThousandSeparator::None)

);

con += recordStr;

records++;

recordStr = "";

}

//Info(strFmt("%1", con));

this.uploadFileToAzureBlob(con);

}

Suspended isSuspended(MainAccount _mainAccount)

{

DimensionAttributeValue dimAttrValue;

DimensionAttribute mainAccountDimAttribute;

Suspended isMainAccountSuspended;

mainAccountDimAttribute.RecId = DimensionAttribute::getWellKnownDimensionAttribute(DimensionAttributeType::MainAccount);

dimAttrValue = DimensionAttributeValue::findByDimensionAttributeAndEntityInst(mainAccountDimAttribute.RecId, _mainAccount.RecId, true);

isMainAccountSuspended = dimAttrValue.IsSuspended;

return isMainAccountSuspended;

}

public void uploadFileToAzureBlob(container _lineData)

{

var storageCredentials = new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(ledgerParameters.StorageAccountName, ledgerParameters.FloQastAzureStorageAccountKey);

CloudStorageAccount storageAccount = new Microsoft.WindowsAzure.Storage.CloudStorageAccount(storageCredentials, true);

Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();

Microsoft.WindowsAzure.Storage.Blob.CloudBlobContainer container1 = blobClient.GetContainerReference(ledgerParameters.FloQastBlobStorageEndpointContainerName);

Microsoft.WindowsAzure.Storage.Blob.CloudBlockBlob blockBlob = container1.GetBlockBlobReference(currentFileName);

StringBuilder csvData = new StringBuilder();

for(int j = 1; j<= conLen(_lineData); j++)

{

csvData.AppendLine(con2Str(conPeek(_lineData,j)));

}

str dataToUpload = csvData.ToString();

using (var ms = new System.IO.MemoryStream(System.Text.Encoding::get_UTF8().GetBytes(dataToUpload)))

{

blockBlob.UploadFromStream(ms,null,null,null);

}

Add parameters for Azure Account

How to extend the window server OS evaluation version or trail version

2024-01-05T16:12:00.005+05:30

Run the below command which extends the 180 days

slmgr -rearm

Filter the form by date range in Dynamics 365 F&O or AX 2012 X++ code

2024-01-03T17:39:00.005+05:30

Need to add range to the query.

Example: Need to add range in ExecuteQuery() method.

QueryBuildRange queryBuildDateRange = SysQuery::findOrCreate(this.queryBuildDataSource(),fieldNum(MyTable,Field));

queryBuildDateRange.value(SysQuery::range(fromDate.DateValue(),Todate.dateValue()));

D365 F&O OData get call in Postman which is getting empty records even when we filtered with company in endpoint

2023-09-22T01:41:00.001+05:30

The reason is: Default admin user company is "DAT"

Soluion:

Need to setup for the admin user default company should be USMF or any company.

Export data entity or composite data entity using X++ code in D365 F&O

2023-09-18T23:29:00.004+05:30

using System;

using System.Globalization;

using System.Net.Http.Headers;

using System.Threading.Tasks;

using Microsoft.WindowsAzure.Storage;

using Microsoft.WindowsAzure.Storage.Blob;

using System.Net.Http;

//using Windows.Web.Http;

internal final class TRGExportEntitySO

{

public static void main(Args _args)

{

TRGExportEntitySO entityExport = new TRGExportEntitySO();

entityExport.exportEntityData();

}

public void exportEntityData()

{

DMFDefinitionGroupEntity definitionGroupEntity,definitionGroupEnt;

DMFEntity dmfEntity,dmfEntityLoc;

CBBlobHelper helper = new CBBlobHelper();

#DMF

Query query;

DMFEntityName entityName = "Sales Orders Composite v3";

DMFDefinitionGroupName definitionGroupName = 'SO Export';//'Customer payment journal Exp';

SharedServiceUnitFileID fileId;

List xsltFileList = new List(Types::String);

boolean isGenerated = false;

select firstonly DefinitionGroup,Entity,Source from definitionGroupEnt

where definitionGroupEnt.DefinitionGroup == definitionGroupName

join TargetEntity from dmfEntityLoc

where dmfEntityLoc.EntityName == definitionGroupEnt.Entity

&& dmfEntityLoc.EntityType == DMFEntityTypes::CompositEntity;

//DMFEntity dmfEntityLoc = DMFEntity::find(definitionGroupEnt.Entity);

//entityName = DMFEntity::findFirstByTableId(tableNum(SalesOrderV3Entity)).EntityName;

// Update query

query = new query(dmfutil::getDefaultQueryForEntityV3(definitionGroupEnt.Entity,definitionGroupName));

//query = new query(this.getDefaultQueryForEntityV3(entityName));

querybuilddatasource qbds = query.datasourcetable(tablenum(SalesOrderHeaderV2Entity));

sysquery::findorcreaterange(qbds, fieldnum(SalesOrderHeaderV2Entity, SalesOrderNumber)).value("SOCN01-0000056"); // selected record value to be pass here

select firstonly RecId,Entity,DefinitionGroup from definitionGroupEntity

exists join dmfEntity

where definitionGroupEntity.DefinitionGroup == definitionGroupName

&& dmfEntity.entityName == definitionGroupEntity.entity

&& dmfEntity.TargetEntity == dmfEntityLoc.TargetEntity;//"SalesOrderV3Entity";

try

{

ttsbegin;

definitionGroupEntity.reread();

definitionGroupEntity.selectForUpdate(true);

definitionGroupEntity.QueryData = query.pack();

definitionGroupEntity.update();

ttscommit;

DMFEntityExporter exporter = new DMFEntityExporter();

fileId = exporter.exportToFile( definitionGroupEnt.Entity,

definitionGroupName,

"",

definitionGroupEnt.Source,//'CSV-Unicode',

#FieldGroupName_AllFields,

query.pack(),

curExt(),

null,

true,

false);

if (fileId != '')

{

//Get Azure blob url from guid

str downloadUrl = DMFDataPopulation::getAzureBlobReadUrl(str2Guid(fileId));

System.Uri uri = new System.Uri(downloadUrl);

str fileExt;

if (uri != null)

{

fileExt = System.IO.Path::GetExtension(uri.LocalPath);

}

Filename filename = strFmt('%1,%2',definitionGroupEnt.Entity,fileExt);

System.IO.Stream stream = File::UseFileFromURL(downloadUrl);

//Send the file to user

//File::SendFileToUser(stream, filename);

//filePath

//str connectStr = CBKeyVaultCertificateHelper::getManualSecretValue('https://smartcoredev-a9b3cnb8fph3hae2.z01.azurefd.net/d365?sv=2022-11-02&ss=b&srt=sco&sp=rwdlacyx&se=2024-04-01T18:49:49Z&st=2023-10-12T10:49:49Z&spr=https&sig=xvLiFCCg6JmHjJ1x6i2Eu%2BhEw1DWSetEKD6jZtRWgu4%3D');

str connenctionString = "https://smartcoredev-a9b3cnb8fph3hae2.z01.azurefd.net/d365/" + filename + "?sv=2022-11-02&ss=b&srt=sco&sp=rwdlacyx&se=2024-04-01T18:49:49Z&st=2023-10-12T10:49:49Z&spr=https&sig=xvLiFCCg6JmHjJ1x6i2Eu%2BhEw1DWSetEKD6jZtRWgu4%3D";

//str connectStr = "https://smartcoredev-a9b3cnb8fph3hae2.z01.azurefd.net/d365?sv=2022-11-02&ss=b&srt=sco&sp=rwdlacyx&se=2024-04-01T18:49:49Z&st=2023-10-12T10:49:49Z&spr=https&sig=xvLiFCCg6JmHjJ1x6i2Eu%2BhEw1DWSetEKD6jZtRWgu4%3D";

Uri blobUri = new Uri(connenctionString);

//try

//{

//using(System.Net.Http.HttpClient cl = new System.Net.Http.HttpClient())

// {

// System.Net.Http.HttpClient clien = new System.Net.Http.HttpClient();

// System.Net.Http.StreamContent content = new System.Net.Http.StreamContent(stream);

// //content.Headers.Add("x-ms-blob-type", "BlockBlob");

// //string mimeType = "text/plain";

// //content.Headers.Add("Content-Type", mimeType);

// var response = cl.PutAsync(blobUri, content).Result;

// if (!response.IsSuccessStatusCode)

// {

// throw new InvalidPluginExecutionException("Put request wasn't a success.");

// }

//}

//catch (Exception e)

//{

// throw new InvalidPluginExecutionException("Your file upload wasn't successful.");

//}

helper.createBlobContainer(connenctionString,'');

helper.uploadBlobFileByStream("filename", stream);

DMFDefinitionGroup::find(definitionGroupName, true).delete();

isGenerated = true;

}

else

{

//throw error("The file was not generated succefully. See execution log");

}

catch

{

//throw error("DMF execution failed and details were written to the execution log");

}

D365 F&O Data Management entity export for all companies data

2023-09-16T00:00:00.006+05:30

On the dataEntity properties "Primary company Context" property set to "DataAreaId" that means it will export the data on the current company.

To export all companies data:

DataEntity properties "Primary company Context" property set to Emply that means it will export the data on the current company

Query missing QueryBuildDataSource for FormDataSource PurchTable in PurchTable form in D365 F&O

2023-09-04T16:24:00.002+05:30

Query missing QueryBuildDataSource for FormDataSource PurchTable

when there is a new table PurchTableTAR in D365 F&O

AP-> Purchase Orders assigned to me

When I open this its getting the below error.

Query missing QueryBuildDataSource for FormDataSource PurchTableTAR

as newly added table in PurchTable Form.

As shown below is the query to be added new table which is added in the form as a DataSource.

New table added to the above query is composite query, inside there PurchTableListPage is the query to add the new table.

Using Filter Expressions in OData URIs in D365 F&O

2023-07-31T21:59:00.001+05:30

https://URL/data/CustomerGroups?$filter=CustomerGroupId eq '10'

https://URL/data/ResourceRequitionLines?filter=SFReqId eq '777787'

https://URL/data/ResourceRequitionLines?$filter=SFReqId eq @title&@title='777787'

how to get the Inventory dimension combination ItemCategory in D365F&O

2023-07-24T20:34:00.004+05:30

InventDimCombination inventDimCombinationLoc;

InventDim inventDimLoc,inventDimCombLoc;

select inventDimLoc where inventDimLoc.inventDimId == prodTable.InventDimId;

select inventDimCombinationLoc join inventDimCombLoc

where inventDimCombinationLoc.ItemId == prodTable.ItemId

&& inventDimCombinationLoc.InventDimId == inventDimCombLoc.inventDimId

&& inventDimCombLoc.InventColorId == inventDimLoc.InventColorId

&& inventDimCombLoc.InventSizeId == inventDimLoc.InventSizeId

&& inventDimCombLoc.InventStyleId == inventDimLoc.InventStyleId

&& inventDimCombLoc.configId == inventDimLoc.configId;

Dynamics 365 F&O SysOperation Simple example

2023-04-23T00:48:00.004+05:30

class FMCustService extends SysOperationServiceBase

{

public void processCustomerData( FMCustContract _contract)

{

CustTable custTable;

AccountNum account = _contract.parmCustAccount();

while select custTable

where custTable.AccountNum == account

{

Info(strFmt("%1",custTable.AccountNum));

}

internal final class FMCustController extends SysOperationServiceController

{

public static void main(Args _args)

{

FMCustController custController = new FMCustController(classStr(FMCustService),

methodStr(FMCustService,processCustomerData),SysOperationExecutionMode::Synchronous);

custController.startOperation();

}

/// <summary>

///

/// </summary>

/// <returns></returns>

public ClassDescription caption()

{

ClassDescription ret;

ret = "Customer base operation";

return ret;

}

[DataContractAttribute]

class FMCustContract

{

CustAccount custAccount;

[DataMemberAttribute(identifierStr(CustAccount)),

SysOperationLabelAttribute(literalStr("Customer account")) ]

public CustAccount parmCustAccount(CustAccount _custAccount = CustAccount)

{

custAccount = _custAccount;

return custAccount;

}

JSON file format to generate for outbound in Dynamics 365 F&O

2023-03-16T18:35:00.003+05:30

JSON file format to generate for outbound:

Class: formJsonSerializer

Contract class: pickListHeaderContract , need to pass all required values to contract class.

Str sJSONHeader = FormJsonSerializer::serializeClass(pickListHeaderContract);

Inventory module tables, classes, inventory posting classes in AX 2012 D365FO

2023-03-02T15:59:00.001+05:30

Invenotry Module tables classes

How to add user in the new development environment in d365FO

2023-02-25T20:33:00.005+05:30

Form control value versioning view Manager and make bold the modified value in Form Control in D365 FO

2023-02-13T19:47:00.004+05:30

x++ code to set bold of field value based on the modification in D365FO Form control

Form : PurchVendorPortalResponses

private void registerForChangeTracking()

{

viewManager = VersioningDocumentViewManager::construct();

viewManager.registerDataContainerForDataSource(PurchaseOrderResponseHeader_DS,

VersioningDocumentViewDataContainer::constructFromDataSource(

PurchaseOrderResponseHeader_DS,

[fieldStr(PurchaseOrderResponseHeaderAllVersions, PurchTableVersion)],

fieldStr(PurchaseOrderResponseHeaderAllVersions, VersionDateTime),

new PurchaseOrderResponseHeaderMapper()));

viewManager.registerDataContainerForDataSource(PurchaseOrderResponseLine_DS,

VersioningDocumentViewDataContainer::constructFromDataSource(

PurchaseOrderResponseLine_DS,

[fieldStr(PurchaseOrderResponseLineAllVersions, PurchTableVersion),

fieldStr(PurchaseOrderResponseLineAllVersions, PurchaseOrderResponseLine)],

fieldStr(PurchaseOrderResponseLineAllVersions, VersionDateTime),

new PurchaseOrderResponseLineMapper()));

viewManager.registerControlForTracking(PurchaseOrderResponseHeader_DlvTerm);

viewManager.registerControlForTracking(PurchaseOrderResponseHeader_DlvMode);

viewManager.registerControlForTracking(PurchaseOrderResponseHeader_VendorRef);

viewManager.registerControlForTracking(PurchaseOrderResponseLine_PurchQty);

viewManager.registerControlForTracking(PurchaseOrderResponseLine_ConfirmedDlv);

viewManager.registerControlForTracking(PurchaseOrderResponseLine_ExternalItemId);

viewManager.registerControlForTracking(PurchaseOrderResponseLine_Name);

}

=====

Extension to add extra feild.

/// <summary>

///

/// </summary>

[ExtensionOf(formstr(PurchVendorPortalResponses))]

final class TestPurchVendorPortalResponses_Extension

{

/// <summary>

///

/// </summary>

public void init()

{

next init();

viewManager.registerControlForTracking(PurchaseOrderResponseLine_PurchPrice);

}

====

Similarly:

Form: PurchVendorPortalAllResponse

Method: registerForChangeTracking()

Extenion to add new control for tracking and bold:

[ExtensionOf(formstr(PurchVendorPortalAllResponse))]

final class TestPurchVendorPortalAllResponse_Extension

{

public void init()

{

next init();

VersioningDocumentViewManager viewManager = this.getViewManager();

viewManager.registerControlForTracking(PurchaseOrderResponseLineAllVersions_PurchPrice);

}

Modify Email Subject for a report in D365 F&O from x++

2022-10-23T22:19:00.000+05:30

Modify Email Subject for a report in D365 F&O from x++

public void printReport()

{

if (reportContract.parmRdpName() == "ProjInvoiceDP") //Dp classs name

{

ProjInvoiceContract contract = reportContract.parmRdpContract() as PSAProjInvoiceContract;

ProjInvoiceJour invoiceJournal;

select firstonly * from invoiceJournal where invoiceJournal.RecId == contract.parmProjInvoiceJourRecId(); //Get the which field we need to add in subjcet

printSettings.emailSubject(strFmt(" %1", invoiceJournal.ProjInvoiceId));

printSettings.fileFormat(SRSReportFileFormat::PDF);

printSettings.fileName(strFmt("SAProjInvoiceModern.Report")); //attached file output

}

next printReport();

}