web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Virtual field in "Vendor invoice journal" Excel template

(0) ShareShare
ReportReport
Posted on by
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.
Z.
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 719 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 650 Super User 2025 Season 2

#3
CU05031448-0 Profile Picture

CU05031448-0 536

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans