Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Inventory Stock Status \ Historical Stock Status

Posted on by Microsoft Employee

In Dynamics GP we used to have 2 Important reports against our inventory

1- Stock Status

2- Historical Stock Status

which both can show the available quantity for all the item or group of items, unit cost & Total Value,

how can we get the same reports in Dynamics 365 Business Central with an option for historical dates and costs?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Stock Status \ Historical Stock Status

    Mohammed,

    There are a lot of Inventory based reports, standard, in BC. Here is a short list:

    701 Report "Inventory - List"

    702 Report "Inventory Posting - Test"

    704 Report "Inventory - Transaction Detail"

    705 Report "Inventory Availability"

    707 Report "Inventory - Availability Plan"

    708 Report "Inventory Order Details"

    709 Report "Inventory Purchase Orders"

    711 Report "Inventory - Top 10 List"

    712 Report "Inventory - Sales Statistics"

    713 Report "Inventory - Customer Sales"

    714 Report "Inventory - Vendor Purchases"

    716 Report "Inventory Cost and Price List"

    717 Report "Inventory - Reorders"

    718 Report "Inventory - Sales Back Orders"

    721 Report "Inventory - Cost Variance"

    1001 Report "Inventory Valuation"

    To show Available Quantity, Unit Cost, and Extended Value, by Item or Groups of Items, you have the Inventory Valuation report. As for historical reporting, you have the Transaction Detail report. If you cannot find a report that meets the requirements, user will turn to Jet Reports or Power BI to accomplish there needs.

    Hope this helps.

    Thanks,

    Steve

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans