Finance | Project Operations, Human Resources, ...

List of a all valid main accounts

(0) Share

Report

Posted on by Basti Aurand

208

Hi,

I need to provide an entity (ODATA) with a list of all valid main accounts for a third party application in order to choose a valid account from the list. How could I achieve this. Is there any view representing this?

Basically the entity should imply the logic (e.g.: main account is part if an active account structure / "Active from" / "Active to" / "Suspended") behind the account reference group lookup in the general jounral to filter only on the valid accounts:

Thanks for any hint.

Sebastian

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Anthony Blake 2,609 Super User 2025 Season 2 on at

Like (0)

Report

List of a all valid main accounts

To second the point made by @Sohaib Cheema, validation is at point of entry and posting, not when displaying the main accounts for selection. Use the full list and validate your entries when they are made.

Was this reply helpful? Yes No
Sohaib Cheema 47,665 User Group Leader on at

Like (0)

Report

List of a all valid main accounts

Main accounts are not just numbers but change their context when used in various scenarios. A main account on its own could not tell about it, whether it is a good or bad account, unless used in a transaction, and there combined with the Financial dimension, the whole combination can pass or fail, based on rules. When I say rules, I speak of Accounting Structure and Advanced Rule Structure. You might be allowed to use one Dimension with a Main account and not with another.

If rules are not a worry in the equation of this question/post, you can get the list of Main Accounts as those are, and keep having them. There is no harm, unless you want to proceed a step further, with the transaction.

As soon as it comes to the point when you want to transact (General Journal Line or any journal line), you are looking at validations (for the combination of account with dimension).

I do not know what you are trying to build there, and what that third-party app is doing, but my gut feeling says it is something to do with integration.

Was this reply helpful? Yes No
Suggested answer

Anthony Blake 2,609 Super User 2025 Season 2 on at

Like (0)

Report

List of a all valid main accounts

Hi @Basti Aurand

I've created and tested an example in the D365 Finance APIs Postman workspace here:

https://www.postman.com/anthonyblakedev/workspace/dynamics-365-finance-apis/request/22139284-dd2589bc-c181-49bd-9001-95422aa9481e?action=share&source=copy-link&creator=22139284

The request I used is:

data/MainAccounts?$select=MainAccountId,IsSuspended,ActiveFrom,ActiveTo

Configure your environment and give it a try!

Anthony

Was this reply helpful? Yes No
Basti Aurand 208 on at

Like (0)

Report

List of a all valid main accounts

Hi Adis,

thanks for the response. As far as I know the MainAccountEntity does not apply the rules defined in "Account structures" (e.g.):

So the main account will appear in the list independently if it is part of an active account structure.

Is the condition connected to active accounts structures implemented in any other entity or view?

Thanks

Was this reply helpful? Yes No
Suggested answer

Adis 5,410 Super User 2025 Season 2 on at

Like (0)

Report

List of a all valid main accounts

Hi,

Check this out

The entity provides active from\to and suspended fields among other information, which you can filter.

Kind regards, Adis

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

1 people found this reply helpful.

Was this reply helpful? Yes No