Skip to main content
Dynamics 365 Community / Forums / Finance forum / Excel Add-in VendInvoi...

Excel Add-in VendInvoiceJournalLineEntity with LedgerJournalTrans_Project

editSubscribe (0) ShareShare
Posted on by
Need some advise on how to proceed with this issue.
We are trying to use Excel-Add in in Ledger Journal Lines and create/update records.
However, for records that have Account / Offset Account = Project, we need to fill in additional details in Project tab.
We have extended the VendInvoiceJournalLineEntity, added the LedgerJournalTrans_Project and applied the relation. We have added the fields to be filled in and build without issue.
When we use the excel add in, we can update records with project accounts in journal lines via excel (publish without issue). But we are encountering error when inserting new lines and set the accounts to Project:
Warning: insert not allowed for field 'LedgerJournalTrans_Project,RefRecId'.
I did some checking and it's related to the AllowCreate/Edit properties of the field.
I'm not sure though as to why we can update but cannot create records with Project Accounts in Excel Add-in using the extension. Seems like it's not assigning the LedgerJournalTrans RecId to LedgerJournalTrans_Project RefRecId during creation.
Any advise? Thanks!