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 / Finance | Project Operations, Human Resources, ... / Stock value report -ho...
Finance | Project Operations, Human Resources, ...
Suggested answer

Stock value report -how to remove Physical values

(0) ShareShare
ReportReport
Posted on by abrzoza1 5

Hello,

I am new user who recently had started to work with Dynamics AX warehouse module. I am writing in connection with Stock Value report from Dynamics AX 2012 R3 (Stock management/Reports/Stock value/Stock value report). Before placing this post I read throught all Tech support and several posts done by Ludwig Reinhard concerning this report. I know what is the difference between Financial and Physical values/quantities but I have another problem.

Some of my data is loaded from external software and not all lines had been correct. As a result I have some positions in the warehouse where Financial values are different from Physical and this is error. Incorrect are Physical columns (see enclosed example).

How can I correct this by GL entry. I need to remove these values. Is there any possibility to do this by ordinary user via: Journals Movement or Stock adjustment or maybe Periodic Closing or adjustment? Can you give me example which Journal to use and what to input to clear Psyhical values to 0,00 only? Financials must stay as they are. Many thaks for instructions.

My warehouse works on Standard costs.

pastedimage1626559825895v2.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Stock value report -how to remove Physical values

    Hello abrzoza1,

    With standard costs things can become a bit tricky and you must be careful how to correct things.

    Basically, those physical transactions can only come from transactions are are not completed yet such as shipped but not invoices SO's, received but not invoiced PO's, etc.

    Can you identify those transactions?

    If so, try to complete them by invoice updating them.

    (You might want to talk to your AP department/vendors and your Sales Department/customers before doing that)

    Once this is done, check your standard cost prices to ensure that they are correct.

    If they are not, change and update them in a costing version.

    (This might result in a revaluation posting)

    Best regards,

    Ludwig

  • abrzoza1 Profile Picture
    abrzoza1 5 on at
    RE: Stock value report -how to remove Physical values

    Hello Ludwig,

    Thank you for yor reply.

    Answering your questions:

    a) at the beginning of 2021 we migrated from our old system to AX Dynamics 2012 R3. These data is migration error. Unfortunately company which migrated data no longer cooperates with my company and I was left with this problem;

    b) we are doing quaterly manual stock counting. After first such count we discovered that data was loaded incorrectly and only Financial values are OK;

    c) at standard costs;

    Now another my questions. I tried to use inventory close and adjustment form in my TEST environment to check if it works but this report is not showing me any transactions to select.

    When you use "close and adjustment form" you have to first select transaction and then you may correct. My form is empty even if I use standard selection criteria or narrow them by date or item number. There is nothing to select.

    Do I have to activate this report somewhere? I have admin rights but I do not see any extra options for this form.

    Enclosed the place where I have this form and my default search criteria. I have app. 100 warehouse transactions per day so there is no option that there is nothing to be seen.

    Is there any other possibility to clear these Physical values except close and adjustment form?

    Regards

    abrzoza1

    Close-and-adjustment-report.pdf

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Stock value report -how to remove Physical values

    Hello abrzoza1,

    In general, you can use the inventory closing and adjustment form to make corrections to such errors.

    Before doing that it would, however, be crucial to understand

    (a) how you entered those physical values in AX?

    (b) how you identified that the physical values are wrong.

    (c) What inventory valuation method you use

    Would be great if you could elaborate.

    Many thanks,

    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans