Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
one item has zero qty but there is some negative financial cost amount .
how can we remove that please let me know.
Hi Ashok R,
Have you tried creating and posting a counting journal with a qty of 0 and run a inventory recalculation thereafter?
Did this remove the $-amount from your report?
yes i tried that but it did not remove the negative financial cost amount.
and another item having positive financial amount without stock so i have added stock to that item and removed , In this scenario financial amount has removed.
Thanks for the feedback.
In this case I would suggest that you run an inventory Close. Once this is done you should be able to access the adjust-on hand button in the inventory closing form.
Open the adjust on-hand form, select the item for which you need the value adjustment via the select button in order to get one or more lines into the adjustment form.
Once this is done and you can see some lines, select adjustment-value in order to bring the value down to zero.
Can you test this in your demo system first whether this resolves the issue?
What is the inventory model on your Item's Item model group?
Do your items have a Storage Dimension Group which has 'Use warehouse management processes' ticked?
i try to adjust in on hand level but no luck .
Can you actually see a quantity, price and/or value in the on-hand adjustment form?
If so, can you share what you see?
Yes i saw some negative qty and negative amount also.
Ok, And can you select adjustment - value/Price or something alike or is everything greyed out once you select adjustment?
yes it is greyed out if i select adjustment.
can you please suggest another way.
Can you tell us what the inventory model on your Item's 'Item model group' is?
A screenshot of the setup of the item's storage dimension group would help. As would a screenshot from the On-hand inquiry showing the zero quantity line.
Hi Guy Terry,
item model group is FIFO.
Inventory model is weighted avg.
It would also be helpful to know which inventory dimensions are enabled for 'Financial inventory'. Check your Storage Dimension Group (and Tracking Dimension group if you use it) for lines which are both 'Active' and have 'Financial Inventory' ticked. Make a note of these dimensions.
Then go to the On-hand inquiry and use 'Dimensions display' to set it so these dimensions are visible (as well as any Product dimensions), but hide any Storage or Tracking dimensions which are not ticked for 'Financial Inventory'. Then you can examine the costs.
In your screenshot, you do not have 'Site' visible. Since 'Site' is always ticked for 'Financial Inventory' you should atleast have this enabled.
I came across the same issue recently.
Are you still facing this issue?
Can you check if all transactions for this item have Financial date? if not maybe you need to invoice pending receipts/shipments.
Hello, i have the same problem, but the inventory model on my Item's Item model group is standard cost... , a peculiarity is that we use the bill of materials diary in those articles (some transactions), the problem is that in some cost changes, there is no revaluation transaction. Do you have some idea about how can i correct the cost?,
Business Applications communities