Finance | Project Operations, Human Resources, ...

Project opening balances with deferral schedules

(2) Share

Report

Posted on by Elbeth

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)

All responses (3)

Answers (0)

Sort by

Suggested answer

Holly Huffman 6,554 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Ramesh Kumar 7,561 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Below 2 links can help you with setup template.

https://www.youtube.com/watch?v=OoHaQ-v23Ks

https://www.velosio.com/blog/data-templates-for-import-export-dynamics-365/

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,264 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No