Dynamics Community Forum Thread Details

Migrating WIP and Opening Balances for FP and T&M Projects from Legacy to D365 F&O

I am designing the data migration strategy from a legacy system (GP) to D365 F&O. I need to migrate active projects so that life-to-date reporting and revenue recognition remain consistent.

Scenario:

Fixed-Price (POC): Projects are partially complete (e.g., $6k spent against a $10k budget). I need the first Revenue Recognition in D365 to accurately reflect 60% completion and pick up the legacy cost as the "Actual" in the cost-to-complete calculation.
Time & Materials: I need to migrate historical costs that have already been billed, as well as unbilled WIP that needs to be invoiced out of D365.

Specific Questions:

What is the recommended vehicle for migrating historical project costs? Is a Beginning Balance Journal preferred over a Project General Journal, specifically regarding how the Estimate engine (for FP) and Invoice Proposal engine (for T&M) "see" these transactions?
How do you handle the "Denominator" for FP projects during migration? Is it better to initialize a Project Budget or a Forecast Model to ensure the POC calculation is accurate immediately after the first migration post?
To avoid double-posting to the General Ledger (since the TB is usually migrated separately), what is the best practice for the Ledger Posting setup on migration journals? Should we post to the ledger and offset to a migration clearing account, or use a "Never Ledger" status?
Are there specific Line Properties or Cost Status settings that ensure migrated costs hit the "Actual Cost" column in the Revenue Recognition/Estimate forms?