Dynamics Community Forum Thread Details

Custom Field - D365F&O Subscription Billing

We are seeking help urgently please

CRM Integration Project
***********************
Module: Subscription Billing
Customisation: Added 3 new fields
                             1. ReleaseDate
                             2. CostOfSale
                             3. VendorAccount
Added these 3 fields in SubBillScheduleLineEntity, SubBillScheduleLineStaging, SubBillScheduleLine
Able to see the mapping in DMF, entity refresh done.

Issue: Unable to update the custom fields from DMF and API

Workout: Added 3 buffer fields to entity to hold the values to update, SubReleaseDate, SubVendAccount, SubCostOfSale

Extended the data entity class added logic to the update method(updateEntityDataSource) as below,

public boolean updateEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx)
{
    boolean retloc;
    SubBillScheduleLineEntity lineEntityloc = _entityCtx.getEntityRecord();
    SubBillScheduleLine lineupd;

    retloc = next updateEntityDataSource(_entityCtx, _dataSourceCtx);

    select firstonly lineupd where lineupd.SUBBILLBILLINGSCHEDULENUMBER == lineEntityloc.ScheduleNumber
        && lineupd.LINENUM == lineEntityloc.LINENUM;

    if(lineupd)
    {
        ttsbegin;
        lineupd.selectforupdate(true);
        lineupd.ReleaseDate = lineEntityloc.SubReleaseDate;
        lineupd.VendAccount = lineEntityloc.SubVendAccount;
        lineupd.CostOfSale = lineEntityloc.SubCostOfSale;
        lineupd.doupdate();
        ttscommit;
    }
    return retloc;
}

Also added the mapping fields(mapEntityToDataSource) in the below method.

public void mapEntityToDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx)
{
    next mapEntityToDataSource(_entityCtx, _dataSourceCtx);

    this.SubReleaseDate = this.ReleaseDate;
    this.SubVendAccount = this.VendAccount;
    this.SubCostOfSale = this.CostOfSale;
}

After this code update, Custom fields are updated from DMF and API. But facing another issue as both the custom and standard fields together in the API and DMF are not updating and throwing the error as below.

DMF Error - Results. Import to target failed due to an update conflict as more than one process is trying to update the same record at the same time. Please try again.

API Error -
"message":"Write failed for table row of type 'SubBillScheduleLineEntity'. Infolog: Info: Cannot edit a record in Billing schedule line (SubBillScheduleLine).\nAn update conflict occurred due to another user process deleting the record or changing one or more fields in the record..","type":"Microsoft.Dynamics.Platform.Integration.Services.OData.

Below is the API Body, trying to update the fields,

--batch_1234
Content-Type: multipart/mixed; boundary=changeset_567

--changeset_567
Content-Type: application/http
Content-Transfer-Encoding: binary

PATCH /data/SubBillBillingScheduleLines(dataAreaId=’XXXX’,ScheduleNumber=XXXX-SUB000007',LineNum=1)?cross-company=true HTTP/1.1
Content-ID: 1
Accept: application/json
Content-Type: application/json
{
"ReleaseDate": "2026-02-15",
"CostOfSale": 15,
"VendAccount": "XXXX_VEN-000000002",
"LineNum": 1,
"CustomerRef": "Testing on 03Feb",
“Quantity”: 25,
“UnitPrice”: 25
}
--changeset_567--
--batch

Categories:

Dynamics 365 Finance

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL