145
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.
*This post is locked for comments
Hi Mohammed,
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.
I suggest read this recent thread https://community.dynamics.com/ax/f/33/t/219071
Hi,
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?
Best regards,
Ludwig
Dear Ludwig,
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.
Hi,
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.
Best regards
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (