web
You’re offline. This is a read only version of the page.
close
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, ... / Project opening balanc...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Project opening balances with deferral schedules

(2) ShareShare
ReportReport
Posted on by Elbeth 20
Good day
 
I have been searching for data templates to use for bringing in opening balances for projects (cost and revenue deferrals) and would greatly appreciate any guidance on best practices to follow.
While reviewing the "SubbilldeferralScheduleTableEntity," I couldn't find any relation to the project.

Could anyone provide insights or recommendations on how to approach this?
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,530 Super User 2025 Season 2 on at
    Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today! 
     
    Bringing in opening balances for projects with cost and revenue deferrals can be a complex process, especially when working with entities like SubbilldeferralScheduleTableEntity. Here are some insights and recommendations to help you approach this:

    1. Enable Billing Schedules with Projects
    • Ensure that the Billing Schedules and Deferrals with Projects feature is enabled in the Feature Management Workspace.
      • This integration works with the Project Management and Accounting module in Dynamics 365 Finance.
      • Once enabled, refresh your browser window to apply the changes.
    2. Use Project Group Setup
    • Configure the Project Group to include deferred options for costs and revenue:
      • Set Post Costs options to Deferred for hours, expenses, and items.
      • Similarly, configure Deferred Revenue options for hours, expenses, items, and fees.
    3. Create Deferral Schedules for Projects
    • To create deferral schedules for project transactions:
      • Navigate to All Projects and select the relevant project.
      • Add a billing rule where the Line Type is set to Time and Material.
      • Enter project transactions (e.g., hours, expenses, fees, or sales orders) and mark them as Chargeable.
      • Post the invoice proposal to generate deferral schedules.
    4. Map Opening Balances to Deferral Schedules
    • Use the SubbilldeferralScheduleTableEntity to import opening balances:
      • Map fields like Deferral Schedule Number, Start Date, End Date, and Recognition Account to the corresponding project data.
      • Ensure that the dimensions match the structure for integrating applications.
    5. Address Missing Project Relations
    • If the SubbilldeferralScheduleTableEntity lacks a direct relation to the project, consider creating a custom entity or view to bridge the gap.
      • Use Power Automate or a plugin to link deferral schedules to project data.
      • Alternatively, export the data to Excel, add the project information manually, and re-import it.
    6. Test in a Sandbox Environment
    • Before importing data into the production environment, test the process in a sandbox environment to ensure accuracy and consistency.
     
    Hope this helps some!
  • Ramesh Kumar Profile Picture
    Ramesh Kumar 7,527 Super User 2025 Season 2 on at
    Hi,
     
    Below 2 links can help you with setup template.
     
     
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Vahid Ghafarpour Profile Picture
    Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at
    If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

    To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

    Thanks for being an active part of the Dynamics 365 Community! 😊

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans