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
Is there a report in D365 that can gives you: (Opening Balance / transactions during the month / closing balance) for all the items?
It needs to be a monthly report.
Are you looking for a report with one line per item and have the transactions in one column? Or do you need a report with a row per transaction? Does the report need to show quantities, amounts or both?
Hi Rogerio Ruella,
Yes there is, please check Inventory value report in inventory management module. This report is setup based & with minimal setup you can generate the required information.
You can setup the inventory value report through Inventory management > Setup > Costing > Inventory Value report.
You can access the inventory value report through Inventory management > Reports > Status > Inventory Value report.
Please mark YES against the answer that helps you. Thanks
The report can be one row per item and have the transactions consolidated in one row or if not, I can consolidate it later but I need to have the opening balance and the closing balance for each item.
The best would be quantities and amounts.
You have not mentioned much about the data that this report shall include.
Do you want to analyze item transactions or financial data?
If you are only interested in financial data (values) then you can use the management reporter.
If you want to report on items then you can use the management reporter only if all of your items have a financial item dimension assigned. I assume that this is not the case, which necessitates that you use other reporting tools, such as PowerBI.
The "inventory value in export format" gives me the closing balance (quantities & amounts) per item for a month and in this report I can also select the transactions for the same period of time (quantities & amounts), but it gives me a huge amount of rows.
What I would like to get is the (opening balance for the month / transactions (quantities & amounts) summarized / closing balance) per item.
Is there any configuration that I can use in this report to get this result? Or at least a way to run this report in the "Detail - transactions" mode (DTL-T) summarized.
Hello Rogerio Ruella,
As far as I know there is a local standard report available for that, which is, however bound to a country key (China if I am not wrong). You can check out this report and test it in the electronic reporting workspace. If it matches your requirement you can test adding your country/region code and make it available for your users.
@Ludwig I tried to enable the China reports for inventory for D365 as well. Those reports are the best that define inventory in different intervals quantitative wise. Unfortunately, it didn't work like they used to in ax 2012. They have country region enabled and this time it's hard to remove it.
The reports will be giving the best data according to different date intervals with reference of each transaction. The reports are purely quantitative, i guess the report that gives inventory data for amount is Inv value.
If anyone manages to overcome the country code matter please share.
Not sure if you can remove country region properties in Dynamics 365, but at least it would be possible to extend the list with countries in the object properties.
I am not referring to the standard SSRS reports but rather to the new electronic reporting framework and the country specific reports that are available there.
Some time ago I found a report that has the opening/transactions/closing structure for inventory transactions in China if I remember it correctly.
One should be able to make this report available for other countries as well by creating a copy of the electronic report configuration and adding one's country key.
I did not check this much further.
Would be great if you could check and test this possibly in one of your demo companies.
Business Applications communities