web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Expense Report Distribution

(0) ShareShare
ReportReport
Posted on by 295

I have a multi company installation where the ledger uses different accounting structures. The expense categories have been set up with Finaincial > Main account.  When a user tries to send the expense report the user gets the following error for a expense category with main account 7320:

"Account structure Sweden P/L, for the combination 7320--------, is not valid for ledger 32."

The error message is correct because Sweden P/L is not set up for ledger 32. The problem is that I cannot find where I set which account structure to use in ledger 32 for expense reports.

When I open up the distribution form for the expense line olnly the main account field is shown among the dimensions. The MainAccount field is empty. and I could not select any account. The info log line also shows following error:

"The combination of the main account and finanicial dimensions, or one or more segments, is not valid"

I don't have the the same problem in the legal entities that uses Account structure Sweden P/L.

Has anyone else that got the same problems?

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,248 Super User 2025 Season 2 on at

    Hi Henrik,

    Did you copy the setup for expense categories from one company to another? If the new company uses another chart of accounts (possibly with the same main account number), the copy will cause the problem.

    The record id of the ledger account is stored as reference in the setup. So the diplay suggests it is OK, but the reference is set to a chart of accounts that is not valid for this new company.

    You have to update the setup entering the same main account value, but then the system will store the record id of the main account belonging to this company.

    It is also possible to create a script which can do this trick for you, but then you need to have knowledge of X++ language.

  • Verified answer
    Henrik Levinson Profile Picture
    295 on at

    The problem was solved by clearing the dimension cache.

    DimensionCache::clearAllScopes()

    Regards

    Henrik Levinson

  • André Arnaud de Calavon Profile Picture
    301,248 Super User 2025 Season 2 on at

    Hi Henrik,

    Thanks for the feedback and the solution. Can you mark your own answer as verified? Then other users can directly see the solution and this thread is marked are answered.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans