When you want to load beginning/opening transactions in a project without affecting financials/general ledger, then one should use the feature known as beginning balances in "Project management and accounting" module in Microsoft Dynamics 365 for Operations (AX)
- Enable beginning balances setup for the project type and project stage in "project management and accounting parameters"
- Setup project beginning balance type journal
- Create a beginning balance journal header and in lines specify the opening transactions with details
- The types allowed for beginning balance journal are:
- hour
- Expense
- Item
- Fee
- On account
- If needed enable a flag in "project management and accounting parameters" under journals and ledger section viz. "Automatically set accounting date to open period"
- Recommend to create dedicated categories for loading opening balances.
- After the beginning balance journal is posted, verify the posted transaction against the project and also verify that there is no financial voucher posted.
- Ensure the line property being chosen has the WIP posting for capitalize cost set to Yes/enable.
- The types allowed for beginning balance journal are:
- Post regular transactions on the project (let us take investment project type)
- e.g. hour posting
Dr |
Payroll allocation |
Cr |
Project WIP cost |
- When running estimate for investment project, ensure to enable "Beginning balance" slider and then run through the estimate.
- After running the estimate, beginning balance transactions would directly show in the Profit and Loss section or WIP section based upon on the line property.
- If line property has the WIP posting for capitalize cost set to Yes/enable then it would appear in WIP section
- If not enable then would appear in profit and loss section and these transactions total would reflect as Not capitalized in the Consumption section of estimate.
- All regular posted project transactions would appear in WIP (work in progress)
- When you the post estimate for the investment project, only the WIP cost would be transferred to the project cost
Dr |
Project - WIP cost |
Cr |
Project - cost |
- Upon eliminating the estimate,
Dr |
Elimination account/asset/project |
Cr |
Project - cost |
*This post is locked for comments