Skip to main content

Notifications

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

Inventory reports

(1) ShareShare
ReportReport
Posted on by 14
Has anyone found a reliable report for inventory that will tie out to the general ledger?
 
 
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 8,124 Super User 2025 Season 1 on at
  • CU17011839-0 Profile Picture
    CU17011839-0 4 on at
    Inventory reports
    There are many ways to consolidate inventory data into a general ledger. The key to success is choosing a system that meets your needs and integrates well with your current accounting system.
     
  • LG-16012201-0 Profile Picture
    LG-16012201-0 14 on at
    Inventory reports
    I started this report at 9:30 this morning and it is still running.
     
    As far as inventory items, I do not post directly to the G/L.
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,787 Super User 2025 Season 1 on at
    Inventory reports
    If the report doesn't match, it's likely due to transactions posted directly to the G/L without going through the subledger. Did you post anything directly to the inventory G/L accounts in the G/L?
     
    Regarding the report's slow performance, how many minutes are we talking about?
     
  • LG-16012201-0 Profile Picture
    LG-16012201-0 14 on at
    Inventory reports
    I have run the inventory to G/L reconcile and it does not match. I do not have thousands of items just a couple of hundred and it still takes forever.
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,787 Super User 2025 Season 1 on at
    Inventory reports
    In addition to the Inventory Valuation report mentioned, if you're using the NA localization of Business Central you can also use the "Inventory to G/L Reconcile report."
     
    As to the report taking all day to run, do you have a lot of items in your company? This report can take some time but I've only seen it take a few minutes to run.
     
  • Martin Dráb Profile Picture
    Martin Dráb 230,934 Most Valuable Professional on at
    Inventory reports
    Moved from Integration, Dataverse, and general topics forum.
  • LG-16012201-0 Profile Picture
    LG-16012201-0 14 on at
    Inventory reports
    This is what I am using, but does it usually take all day to run?
     
    I have been running my report since 9:30 this morning.
  • VaHiX Profile Picture
    VaHiX 4,350 Super User 2025 Season 1 on at
    Inventory reports
    I think The Inventory Valuation report is designed for this purpose
     
  • LG-16012201-0 Profile Picture
    LG-16012201-0 14 on at
    Inventory reports
    365 Business Central

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,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans