Finance | Project Operations, Human Resources, ...

Year-end process for public sector

(2) Share

Report

Posted on by STP

541

Hi everyone,

My customer is requesting to post different retain earning accounts for various financial dimension 'Fund'.

Have anyone implemented it?

I've done below configuration:

GL parameter

Financial dimension 'Fund'

Setup the funds and add it into the financial dimension

My questions are:

1. Close type

Based on MS learn, Close type is required. However, I don't find the field in the edit in excel / data management, how do I update all main accounts in one-go? Otherwise, updating manual is time consumption.

2. Transaction post definition and Posting definition

It looks like I need to configure them, but I have no idea how to use them.

There are some examples on MS Learn, but it's not easy to follow...

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Raj Borad 1,428 on at

Like (0)

Report

Hi @STP,

The setup requires using posting definitions, particularly important for the public sector or fund-based accounting. First, ensure the Fund dimension is created and configured under General Ledger > Dimensions > Financial dimensions, and the “Use Fund dimension for year-end transactions” toggle is enabled (which is done). Right?

For retained earnings by Fund, each main account must have a Close type = Nominal, which routes balances during year-end close.

Unfortunately, the Close type of field isn’t exposed in Excel/Data Management by default. To update in bulk, you can either customize the entity, use “Edit in grid” in the UI, or apply an X++ job.

After that, set up the Posting definitions to post closing entries to different retained earnings accounts based on the Fund dimension. Configure the rules under General Ledger > Setup > Posting definitions to match each fund with its retained earnings offset account.

Thanks,

Raj D Borad

Was this reply helpful? Yes No
Suggested answer

Abhilash Warrier 5,426 Super User 2025 Season 2 on at

Like (1)

Report

Regarding Question 1.

Have you tried using the table browser?

Will post the response for the second query once this issue is fixed. Thank You

If this helped, please mark it as "Verified" for others facing the same issue.
Keep in mind that it is possible to mark more than one answer as verified.

Was this reply helpful? Yes No
STP 541 on at

Like (0)

Report

@Abhilash Warrier, I've tried to open and edit 'Close type' in the table browser, but it doesn't work.

@Raj Borad, Yes, I've set up the financial dimension 'Funds' and enabled the parameter 'Use Fund dimension for year-end transactions'

Re Posting definition, I've setup for those account structures with Fund, do I need to setup for non-Fund account structures?

Thanks for confirmation about no DM/Edit in excel for Close type.

I have the error message when I run the year end close. Not sure if it is due to incomplete setting in posting definition or Close type.

Was this reply helpful? Yes No