Finance | Project Operations, Human Resources, ...

Customizing expense journal entity to create fixed asset transaction through excel add-in

(3) Share

Report

Posted on by AP-17101228-0

i 'm having a requirement to customize the project expense journal entity to create transaction line from excel addin for the transactional account type of (ledger,project and fixed asset type)

as on standard in project expense journal lines (ledger and project ) account type was there , i need to customize and add to create a fixed asset transaction from the same entities excel template

is there any possibilities to do that

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

CA Neeraj Kumar 5,099 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Please elaborate the business requirement behind this customization..

What project type you are referring here?.. As in Investment project and fixed price project, you can use elimination process to transfer the balances to Fixed assets..

Need to understand the rational behind adding an account type in Project expenses journal.. Purpose of expenses journal is different and if you try to add new account type.. Don't know where and all will have impact. Honestly saying, I am listening to this kind of customization for first time.

Regards,

Neeraj Kumar

Was this reply helpful? Yes No
AP-17101228-0 68 on at

Like (1)

Report
Copy link

Link copied!

@CA Neeraj Kumar
@André Arnaud de Calavon
the purpose is to create lines from excel for the ledger ,i need to create line with project account type ,ledger and fixed asset ,creating all these types from excel addin

i have seen that using project expense journal excel addin, we can create lines for the ledger with account type ledger and project

i need to add fixed asset line creational functionality in that excel addin

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 5,099 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Actually I am trying to say that project expense journal is designed for Ledger and Project, so it should not be used for Fixed assets. To affect the fixed assets transactions, it should either go from Fixed assets journals, and specifically in case of projects, it should follow the elimination process to create a FA and reduce the project costs.

Regards,

Neeraj Kumar

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The standard data entities do not support your scenario. Indeed a customization is required. I haven't seen this requirement myself. I would suggest to create a new data entity where you try to combine the project expense journal entity and the assed journal entities. Then check if you want to support the account types project and fixed asset for the account, offset account, of both.

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you want to post anything on the lfet/right(debit/credit) side with all the choices, you can choose General Jouranl

It is hard for me to understand the posting of Fix Assets using the Expense journal.

May be you want to provide more details in the business language please.

Was this reply helpful? Yes No