Virtual field in "Vendor invoice journal" Excel template

(3) Share

Report

Posted on by Zdenek

Hi,

I am trying to resolve an issue with populating of virtual field in data entity used for "opening in excel".

I have created an extension for VendInvoiceJournalLineEntity with new virtual field MyField. It is populated by the extension of postLoad() method.

public void postLoad()
{
next postLoad();

this.MyField = "X";

}

When I open the invoice journal in excel and modify the design (by adding the field), then it works perfectly in development environment. Excel sheet shows "X" in MyField column. After I deploy the customization in sandbox it doesn't work anymore. The column is empty in Excel.

To verify that the postLod is activated in the sandbox, I exported the journal transactions using a Data management project with the entity VendInvoiceJournalLineEntity. My virtual field is correctly populated in staging table as well as in the target file.

Any thoughts?

Thank you.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Zdenek 26 on at

Like (1)

Report
Copy link

Link copied!

In addition to the previous statement, I discovered something strange that may be useful to know. When entering postLoad in DEV, Dynamics switches to a company identical to the one from which the journal originates. When entering postLoad in UAT, DAT company is active.

Was this reply helpful? Yes No