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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Some difference in sto...
Microsoft Dynamics AX (Archived)

Some difference in stock value between Trial Balance and Inventory value report

(0) ShareShare
ReportReport
Posted on by JauB 352

Hi

I have some difference in stock value  between Trial Balance and Inventory value report.

Before doing this comparison, i started stock recalculation but no changes !

What I can check please ?

Thanks.

*This post is locked for comments

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

    Hi,

    Have you run the potential conflicts report? This can give you some hints on the underlying cause of the problem.

    Another option is the use of a product financial dimension. Have you associated all your products with a product financial dimension? If this is the case you can quickly filter the transactions in the trial balance that are made without financial dimension and possibly caused the problem.

    Best regards,

    Ludwig

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    Ax in is a double entry system,  so there should be no difference between your sub ledger and TB.

    If there is a difference, then something has posted to the wrong account, either because inventory accounts are not locked and manual journals are done in the GL rather than via the sub ledgers or because a posting profile is incorrect.

    The reconciliation report Ludwig mentions is  a  good place to start.

    Run the Posting by Account report at GL > Reports > Reconciliation > Inventory – Item posting by account and review the transaction by the posting types. This will help in determining the transaction types posted to the inventory accounts and determine whether wrong transactions got posted to inventory accounts .

    • Run the Ledger transaction list report at GL > Reports > Transactions > Ledger transactions list to get a list of all transactions that may not have been captured by the Item posting by account report. This will help in analyzing any unwanted transactions(Service item transactions , manual entries etc) incorrectly  posted to inventory accounts.
    • Run the Inventory value report by item group at Inventory management > Reports > Status > Inventory value report by item group and match the financial values of each item group with the trial balance report.

    See this recent community post https://community.dynamics.com/ax/f/33/t/239099

    See also General Ledger > Reports > All reports under Inventory folder.

  • JauB Profile Picture
    JauB 352 on at

    Hi magic1949

    When i  : Run the Inventory value report by item group at Inventory management > Reports > Status > Inventory value report by item group and match the financial values of each item group with the trial balance report.   ==> I can see the difference for some items and after analyzing the setup ofr item groups I can see that we looped some settings in "Inventory" accounts. Can you tell me what we have to do after correcting this ? is there some thing to run to correct some entries some where ...?

    Thanks.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi JauB,

    Before making some corrections you should be absolutely sure about the underlying reason that caused this variance.

    You mentioned hat you looped some settings. What does that mean?

    Do you know of manual postings on the automatic inventory accounts have been made?

    Unless you are sure about the underlying reason that caused the variance I wouldn't do a correction because you might have to do it every month then.

    Best regards,

    Ludwig

  • JauB Profile Picture
    JauB 352 on at

    Hi Ludwig,

    You mentioned hat you looped some settings. What does that mean? ==> in item groups>inventory >Account type (Issue, Loss ...), the main accounts are not setuped as well as it should be !

    So I want to kno, if I put the rights accounts for the right Accounts type, have i to run something to correct the old transactions ? Or there is no possiblity ...?

    P.S : The closing of the stock is not made yet.

    Thanks

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi JauB,

    Changing the accounts in the inventory posting matrix won't help you after Transactions are already recorded. Also an inventory close won't fix that.

    Best regards,

    Ludwig

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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