Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Reconcile AP to GL report is not available in BC

(1) ShareShare
ReportReport
Posted on by 8
Hello all, I am trying to find a report which gives inventory item received but not invoiced. When I search the report Reconcile AP to GL, I am not getting. Kindly guide me how could I get this report or any other alternative reports other than inventory valuation?
  • Verified answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,053 Super User 2025 Season 1 on at
    Reconcile AP to GL report is not available in BC
    Report Reconcile AP to GL is only in US localization. 

    You can ask Your MS partner to get this report from US localization and put it on your system as a new report.
    Or You can try to create the a similar report by extracting Configuration package of Purchase Lines (table 39) and filter by Field 58 (Qty. Rcd. Not Invoiced) <>0. Then in the excel you get add a column where You multiply this Qty Received not invoices * Unit Price.

     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 7,919 Super User 2025 Season 1 on at

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans