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.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
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 | All TechTalks
User want to know what will be approx cost that system takes after they post inventory journal in case of negative qty.
Ax blocks entering cost if qty is negative, so need some solution so that user can forecast approx total value.
You can check the running average cost price in the on hand form. In the second tab at the bottom you should see the value and the price that will be taken for the next issue transaction.
Thanks for the instant reply.
I want to confirm one more thing.
When i am running inventory journal for 31/12/2018 for posting stock variances, it will take avg price as of today or as of 31/12/2018 ?
In onhand form, its showing as of today
In my case i need to achieve with price as of 31/12/2018.
The price that AX takes for the temporary posting is the current running average price.
That is the price that you see in the on hand form.
If you backdate transactions also this price will be used, however, only temporary because the inventory close / recalculation will use the correct price that is in line with your inventory valuation method such as FIFO, LIFO, etc.
Does that answer your question?
I suggest read this recent thread https://community.dynamics.com/ax/f/33/t/219071
For your first question, if you enable the Latest cost price on the Released product, AX will maintain a recent cost price for the item, which it will put on to the journal line when you create it. This cost price might not be the price that is actually used when you post the journal (or be the cost that is assigned after Inventory close has run) but there is every chance that it will be close.
Business Applications communities