Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Can we post project ex...
Finance | Project Operations, Human Resources, ...
Answered

Can we post project expenses to different ledger accounts based on line property?

(0) ShareShare
ReportReport
Posted on by Neeraj Kumar Gudapati

Hello,

We have a requirement to post Chargeable (project) expenses to a group of general ledger accounts based on the selected expense category. We also have a requirement to post non-chargeable expenses (non-project expenses or Billable = No for project expenses) of those same categories to a different group of general ledger accounts.

Is there a way we can set this up with Out of the box functionality?

Scenario1:

Category: Airfare

Project ID: Proj1

Billable: Yes (Line property with Chargeable field marked as Yes)

Expected Outcome: Expense should get posted to ledger account 123456

Scenario2:

Category: Airfare

Project ID: Proj1

Billable: No (Line property with Chargeable field marked as No)

Expected Outcome: Expense should get posted to ledger account 567890

Scenario3:

Category: Airfare

Project ID: <blank>

Billable: <Blank>

Expected Outcome: Expense should get posted to ledger account 567890

If this is not possible, can we at least route expenses to different ledger accounts based on selection/non-selection of projects? I mean when project is selected, expenses should get posted against 123456 and when project is not selected, expenses should get posted against 567890 ledger account.

Thanks,

Neeraj

  • Neeraj Kumar Gudapati Profile Picture
    Neeraj Kumar Gudapati on at
    RE: Can we post project expenses to different ledger accounts based on line property?

    Thanks André!

    I am able to post expenses to different accounts based on project selection/non-selection.

    Unfortunately, creating additional categories is not something we prefer as our current system (third-party) supports all our requirements. We will have to customize for meeting that billable criteria requirement.

    Anyways, thanks again for your help!

    Regards,

    Neeraj

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Can we post project expenses to different ledger accounts based on line property?

    Hi Neeraj,

    There are only workarounds available to achieve what you want to try to achieve. Andre mentioned one - setting up new categories. Another one would be to post the non-billable charges to a specific subproject that uses different accounts.

    Yet, I am wondering why you need that?

    Can you explain why you want to separate billable from non-billable airfare costs?

    Do you want to show those airfare charges in different parts of your financial statements or what is the reason for trying to make this separation?!

    Best regards,

    Ludwig

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at
    RE: Can we post project expenses to different ledger accounts based on line property?

    Hi Neeraj,

    There is an option to specify a separate account for the category,  project and also a combination of the category and the project.

    There is no option to differentiate based on the line property.

    If the default options are not sufficient, you can consider setting up different categories for billable and non-billable.

  • Neeraj Kumar Gudapati Profile Picture
    Neeraj Kumar Gudapati on at
    RE: Can we post project expenses to different ledger accounts based on line property?

    Hello Ludwig,

    Thanks for the response!.

    Our current expense management system supports posting to different accounts based on billability selection. So, I am checking if that is something which D365 supports too.

    Is there a way we can post expenses to different ledger accounts based on selection/non-selection of projects (irrespective of the billability criteria)?

    Regards,

    Neeraj

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Can we post project expenses to different ledger accounts based on line property?

    Hello Neeraj,

    The billable criteria is not a criteria that you can setup in the project posting profiles.

    Can't you define the way how the ledger account is identified in a different way?

    Best regards,

    Ludwig

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,983 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans