Finance | Project Operations, Human Resources, ...

VendorInvoiceLineEntity - update defaultdimension based on Project's defaultdimension

(0) Share

Report

Posted on by JackieMc

128

I've extended the VendorInvoiceLineEntity to include VendInvoiceInfoLine_Project as an outer join and am successfully saving/updating records via OData both when I have a project and when I don't.

The last hurdle I'm facing is that when a project is included (VendInvoiceInfoLine_Project is populated), the field VendorInvoiceLineEntity.Dimension should be updated to the DefaultDimension from ProjTable for the ProjId in VendInvoiceInfoLine_Project. In other words, if a Project is populated, the Project's default dimension should be used. This is what happens when entering a Vendor Invoice through D365 manually.

However this field is Private in the Data Entity:

Is there any way for me to update this field based on the Project's DefaultDimension? Note that these are usually Vendor Invoices without POs so we can't pull any data from the PO.

From my database (VendInvoiceInfoLine table), the record with DefaultDimension populated below was entered through the D365 application manually where project and project category were entered instead of an account string and the other three records were interfaced through the VendorInvoiceLineEntity with a Project and Project category populated in the message.

Categories:

Dynamics 365 Project Operations

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 305,703 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Moved the question from the Dynamics 365 General to the Dynamics 365 Finance & Project operations forum.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,703 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Jackie,

The reason that this field is Private, is because this is storing the reference record ID beloning to a dimension value set. It is not managing the dimensions as concatenated string.

In case you want to copy the dimensions from the project, you can use X++ coding to find the dimension and then default the dimension value from the project. You can e.g. use the method mapEntityToDataSource() for this purpose.

Was this reply helpful? Yes No
JackieMc 128 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I'm still getting this compile error when I put the logic in the mapEntityToDataSource() extension:

Field 'this.Dimension' is private and can only be referenced from within the element in which it is declared.

Here's my code in my extension - am I using the wrong syntax for this??:

public void mapEntityToDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx)
{
switch (_dataSourceCtx.name())
{
case dataentitydatasourcestr(VendorInvoiceLineEntity, VendInvoiceInfoLine):
VendInvoiceInfoLine vendInvoiceInfoLine = _dataSourceCtx.getBuffer();

if (this.ProjId)
{
LedgerDimensionAccount projDefaultDimension = ProjTable::find(this.ProjId).DefaultDimension;
this.Dimension = projDefaultDimension;
}
}

next mapEntityToDataSource(_entityCtx,_dataSourceCtx);

}

(note I've tried having my case stmt reference VendInvoiceInfoLine and VendInvoiceInfoLine_Project but I get the same result)

Was this reply helpful? Yes No