Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Najeem JanatAli]

HI All

I have more than 40 companies in the instance and have more then 100 inter company account which is making my Chart of account way long. Is there any suggestion to have one control account in COA like vendor or customer. Or any suggestion to control this through Financial dimension

Thanks and kind regards

——————————
NL

——————————

[Amy Akley]

Nazim,

We use one intercompany account and use another dimension to designate which business unit the intercompany belongs to. It makes account maintenance much easier. 

——————————
Amy Akley
Sr. Financial System Analyst
XTRA Lease
Saint Louis MO
——————————
——————————————-

[Nicholas Smith]

How do you get the business unit to populate on your Intercompany transactions?  Do you have to manually select it for each entry?

——————————
Nicholas Smith
Universal Leaf Tobacco Company, Inc.
Richmond VA
——————————
——————————————-

[Amy Akley]

Looking back, we made a small customization to assign additional dimensions to the intercompany postings besides the account number. We did not want to deal with 25+ accounts for intercompany transactions.

——————————
Amy Akley
Sr. Financial System Analyst
XTRA Lease
Saint Louis MO
——————————
——————————————-

[Najeem JanatAli]

Amy

Sounds like great idea

please can you explain bit in detail

thanks and kind regards——————————————-

[Amy Akley]

Nazim,

I am a functional user so I don’t know the specifics behind the customization. 

On the intercompany posting setup where you specify the account number you want to use, we added an additional dimension for business unit. When the intercompany posting is called, it uses the correct account and business unit combination. 

When we setup our chart of accounts, we made sure the intercompany account is the only one that uses this additional dimension.

——————————
Amy Akley
Sr. Financial System Analyst
XTRA Lease
Saint Louis MO
——————————
——————————————-

[Céline Langevin]

Hi,

We also have to deal with a lot of Entities and Interco. Here’s what we did: Each entity is named Exxx, where xxx is a number. We then set-up a Main Account for each Entity 14xxx, where 14xxx is the INterco Loan To/From Entity Exxx. Hence, since we have 52 Entities, we have 52 Interco Accounts. The Financial Dimension on each is set by Main Account Legal Entity override.

Hope it helps,

Celine

——————————
Céline Langevin
AIMCo
——————————
——————————————-

[Najeem JanatAli]

Hi Celine
That what we wanted to avoid to have 52 inter company accounts. It makes the Chart of accounts long

For us these 52 inter accounts becomes more then 200 account

On the top of that there are some companies who dont have their own bank account and other companies are paying for them which require to have inter co transactions

any suggestion

Thanks and kind regards——————————————-

[Muhammad Iftikhar]

Hi Nazim –

For the companies making payments on behalf of other companies, have you tried centralized payments functionality? (You will still have to setup inter-company pairs with related credit and debit accounts for intercompany transactions to take place).

Regards,
Jawad

——————————
Muhammad Iftikhar
Velosio
Dublin OH
——————————
——————————————-

[Zvika Rimalt]

I usually do exactly the same as Celine – the number of inter-company accounts = number of entities.
This works well for vast majority of implementations that have less than around 50 legal entities.

In the rare situation where there were more than 50 we always did the customization Amy described.

On a side note, that feature – to stamp intter company balances with a dimension is sorely missing from the D365 for many years… Maybe the R&D team will finally pick up on it.

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

[David Scattergood]

Have you considered using the legal entity as a financial dimension, as this is available out of the box, no development needed, i.e. the real legal entity not a custom list that looks like the legal entity, which would then require maintenance as the number of legal entities grows.

This financial dimension can then be defaulted onto the corresponding intercompany customer/supplier accounts so that they would automatically get applied whenever an intercompany SO/PO was created. Obviously you would need the account structure to have this financial dimension as a requirement for your chosen GL(s) to meet your reporting requirements. Using the legal entity in GL journals would be more manual but still feasible the only issue I could see there would be ensuring the intercompany balances are reconcilied between the corresponding legal entities, but somebody in Finance should have that on their ‘to do’ each month anyway.

——————————
David Scattergood
P2 Dynamics Solutions Ltd
Corby
——————————
——————————————-