Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Year end close: balance sheet account is processed as profit and loss account in one legal entity

(1) ShareShare
ReportReport
Posted on by 2,449
When running the year end close (General ledger > Period close > Year end close) in one legal entity, one account with main account type balance sheet is not transferred over to the new year. Instead, its closing balance is added to the retained earnings account for that legal entity. From what I'm being told by our financial consultant, that should only happen for accounts with a profit and loss account type.
 
This only happens for one of multiple legal entities. In other legal entities, the trial balance (General ledger > Inquiries and reports > Trial balance) is showing the expected entry for the account.
 
The general ledger parameters for fiscal year close are 
- Delete existing year-end entries when re-closing the year: Yes
- Create closing transactions during transfer: No
- Set fiscal year status to permanently closed: No
- Use Fund dimension for year-end transactions: No 
- Track year-end closing entries created during Purchase year end process: No
Same settings in the other legal entities where it works.
 
Not sure what other settings might be of interest. Our financial consultant tells me that no other settings should have an impact on how a balance sheet account gets processed.
 
I already spent a few hours debugging the logic. Due to the fact that some parts are executed in parallel across multiple batch tasks/threads and the overall complexity of the logic, it is slow going. So I'm hoping someone might have come across something similar or has an idea what to check.
  • Florian Hopfner Profile Picture
    Florian Hopfner 2,449 on at
    Year end close: balance sheet account is processed as profit and loss account in one legal entity
    Got word from our financial consultant. It appears the parameter "Keep detail during year-end close" (in General Ledger > Ledger setup > General ledger parameters, Ledger settlements) is connected to the behavior. If it is active for the account in question, the issue occurs. If it is inactive, the issue does not occur.
     
    While this resolves the immediate issue, we would like to use that parameter for the next year-end close. Since this parameter is also global and not just for a specific legal entity, it is curious that the issue only occurs for one legal entity.
  • Florian Hopfner Profile Picture
    Florian Hopfner 2,449 on at
    Year end close: balance sheet account is processed as profit and loss account in one legal entity
    Thanks for taking a look.
     
    Country of the legal entity is Germany. While we have several ISV solutions and some customizations, none are likely candidates for customizations in this area. So far, during debugging, I also have not encountered any customizations or country specific logic that would apply to Germany. There are also other legal entities in Germany where it works.
     
    The chart of accounts is the same for all legal entities (there is only one chart of accounts).
  • Verified answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,811 Most Valuable Professional on at
    Year end close: balance sheet account is processed as profit and loss account in one legal entity
    Hi,
     
     
    You consultant is right. If it is not any some country spesific issue or a customization, system will only look at the type of the account. Are you sure that the COA are the same?
     
     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans