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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inventory to G/L Recon...
Small and medium business | Business Central, N...
Suggested Answer

Inventory to G/L Reconcile Report - Filtering by Received Not Invoiced > 0?

(0) ShareShare
ReportReport
Posted on by KAY15 50

Is there a way to run the Inventory to G/L Reconcile Report and filter by the Received Not Invoiced amount?

When I run the report and export to Excel with no filters in place, I have a 60 page report. I am only interested in items with Received Not Invoiced > 0.

Because of the formatting (Item Description is on the line above the total), it's very difficult to even filter/analyze in Excel.

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    You could get similar with the item ledger entries. Any lines with a positive remaining amount that have a cost amount expected >0 indicates invoicing is still required. You could then pull out purchase receipt line data and create a link, in power BI for instance, to know exactly which PO’s need to be actioned. Failing that if you change over to a purchasing based profile you have received not invoiced as a saved filtered view on the purchase orders list.

  • beenmeckel Profile Picture
    beenmeckel 77 on at

    Anybody know where I can get my team coins that are for sale and not have to wait a week

    https://tutuapp.uno/ , https://9apps.ooo/ , https://showbox.kim/

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

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 566 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 347 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 327 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans