web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Business Central Report for item tracking and total quantity

(0) ShareShare
ReportReport
Posted on by

Hi experts, I'm looking for a report in business central where user can see the in and out quantity for all items based on their sales order no./purchase order no.

Is there any built-in report that fulfill these requirements in BC?

Thank you.

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    You can verify in the standard company if such a report that fulfills your business requirements exists, if not, you probably have to design it via an extension.

    Thanks.

  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    I assume you can go to "Item Ledger Entries" then filter for Entry Type (Purchase / Sales) then you can use Page -> Open in Excel.

    But I cannot recall any report for this.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hello,

    Adding to Marco and MahGah's replies.. There is not specific report you can print, per say. You can use, as MahGah noted, the Item Ledger Entries Page and filter by Document No. or Document Type to see the Positive and Negative impact on Items.

    pastedimage1621357782503v1.png  pastedimage1621357847688v2.png

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    ew9800 Profile Picture
    182 on at

    How about opening the item ledger entries in Excel, filtered as you need.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,585

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 780 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 712 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans