Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
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.
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?
Close and adjustment report.pdf
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)
Business Applications communities