Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Report of posted invoi...
Small and medium business | Business Central, N...
Suggested answer

Report of posted invoices containing item

(1) ShareShare
ReportReport
Posted on by CU09081641-3 53
Hello,
 
I often need to trace the posted sales invoice numbers containing a particular product.
 
 
How can I quickly do this?
 
If I go the Items menu 'Related-History-Entries-Ledger Entries'  only the Sales shipment Doc number is shown.
 
 
 
Categories:
Dynamics 365 Business Central
  • Ramesh Kumar Profile Picture
    Ramesh Kumar 233 on at
    Report of posted invoices containing item

    I believe there are multiple ways to approach this, depending on how often you need the data:

    1. Use a configuration package with a filter.
    2. Create a Power BI report with a search option.
    3. Utilize the standard Business Central filter.

    Personally, I often prefer using the configuration package with a filter, as it allows me to download all the columns.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    Report of posted invoices containing item
    Just to add some information:
    Business Central 2022 wave 2 (BC21): More document lines are searchable (Posted and non-posted document lines)
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,925 Super User 2024 Season 2 on at
    Report of posted invoices containing item
    The quickest way would be to use the Posted Sales Invoice Lines Page. You can filter on the No. field for the specific item no. you're looking for. You can then look at the Document No. to get your posted invoice no.
     
     
  • gdrenteria Profile Picture
    gdrenteria 12,338 Most Valuable Professional on at
    Report of posted invoices containing item

    Hi, good day
    I hope this can help you, and give you some hints.

    How to find Posted Sales invoices that include a certain product item number

    Best Regards
    Gerardo

  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,470 Super User 2024 Season 2 on at
    Report of posted invoices containing item

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans