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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Inventory cost revaluation posted without mandatory financial dimension (which is not allowed in account structure).

(0) ShareShare
ReportReport
Posted on by 1,282

I saw many posts related to it but so far no solution. I am trying to understand a sales order which is posted with the following voucher where we have a $0.01 difference in "cost of unit" and "cost of good sold". The difference is being posted to Inventory cost revaluation account, which is not an issue,  but the issue is - it is getting posted with no financial dimension while it is mandatory in my chart of account structure as you can see I have 100 for all accounts, I am not able to understand why? Also, where can I set the dimension for inventory cost revaluation (other than fixing it at the main account level). I see 100's of these transactions in my system. There is no customization here and the it is 10.0.8 version of D365 FO.

2476.png

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Kumar,

    Can't you setup the account in question with a fixed financial dimension?

    This would overcome the issue.

    Best regards,

    Ludwig

  • Kumar_Sat Profile Picture
    1,282 on at

    Dr. Ludwig, do you know why it would allow posting without a dimension and why we did not get an error? My item is not fixed with the financial dimension because it is used with multiple dimension but it is beyond my understanding that it is overwriting my account structure settings. Fixing the account is not an issue but I would like to know the reason.

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

    Hi Kumar,

    Usually only the dimension value will be cleared if the account does not have a dimension setup via the account structures. In this case it is an empty value. Is the account structure setup to allow for empty values?

    If the account structure is setup to not allow blank values, it can be considered as a bug. Have you looked at LCS issue if there is a known issue? If not, you can create a ticket for Microsoft support.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Kumar,

    I am in line with Andre.

    If there is a dimension requirement for this account then you should get an error message if a process is trying to post on this account without a findim.

    The only thing I can think of is that somebody changed the account structures before posting or that somebody put a fixed 'blank' findim value on this account before posting.

    Can you replicate the issue in a different system?

    Do you get an error when you try replicating the process?

    Best regards,

    Ludwig

  • Kumar_Sat Profile Picture
    1,282 on at

    I am sorry but I do not agree with your suggestions. I will find out the real reason and post the answer here later.

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

    Hi Kumar,

    Do you have an update already? I wonder why you don't want to answer our questions. We are only trying to help...

    If you need help, I'm really interested how exactly you did setup the account structure for this main account.

  • Kumar_Sat Profile Picture
    1,282 on at

    Andre, I know the basics of account structure and I know it is correct and active in my instance. I think it is a design issue in D365 F&O (or may be a bug) wherein an automatic transaction is created by D365 which does not care about advance rules or account structure. I will definitely let you know the outcome once I confirm with Microsoft.

  • Rahul Mohta Profile Picture
    21,032 on at

    +1 Andre and Ludwig

    number one thing in solving an issue is recreating it

    if it can be recreated could u suggest on accounts structure and adv. struc

    also if it cannot then it is perhaps the accounts structure which was active at the time of posting taken in

  • Kumar_Sat Profile Picture
    1,282 on at

    Inventory cost revaluation transaction is posted automatically by the system to adjust the cost due to change in cost in procurement, manufacturing process or ex. rate movement and I think the issue is right in here. All of my transactions are validated for account structure rule but not this particular account. I think the rule to validate this automatic posting is somewhat different in D365 (not like any other account) and that is what I am still exploring.

  • Kumar_Sat Profile Picture
    1,282 on at

    Update from Microsoft:

    "Inventory revalue account" is a system account and it does not follow standard account posting. I have requested further clarification but so far this is what is given to me from Microsoft.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans