Validating Inventory Balances Using the Health Check Dashboard in Business Central

-

When evaluating the integrity of inventory balances in Dynamics 365 Business Central, it’s critical to confirm that the General Ledger and Sub-ledger remain in sync. One helpful tool for this validation is the Health Check Dashboard created by ERP Connect Consulting, which provides a snapshot of potential discrepancies especially around inventory postings and other modules as well. This blog highlights a recent review process and how the system confirmed accuracy through several reconciliation points.


Inventory Posting Setup

The Health Check Dashboard pulls balances directly from the G/L accounts listed in the Inventory Posting Setup specifically the Inventory Accounts that are tied to inventory transactions. In this case, the total balance for those Inventory Accounts comes to $1,086,229.20, which aligns exactly with the amount shown in the Health Check under the G/L summary.



Interim Inventory Account Insight

However, it's equally important to factor in the Inventory Account (Interim). This account captures values for items that have been received but not yet invoiced, playing a key role in reconciliation.

The Inventory Account (Interim) accounts show a balance of $13,695.26, which critically matches the discrepancy between the G/L and Sub-ledger values flagged in the Health Check Dashboard. This indicates that the system is correctly accounting for received inventory that hasn’t been fully processed through to invoicing yet.

Confirming with the Inventory to G/L Reconciliation Report

To further validate the system’s postings, we ran the Inventory to G/L Reconciliation report. Scrolling to the bottom of the report, here are the key takeaways:

  • Inventory Valuation: $1,099,924.46
  • Received Not Invoiced: $13,695.26
  • Inv. Value Posted to G/L: $1,086,229.20

Final Thoughts

The reconciliation between the G/L and inventory sub-ledger is accurate. The Health Check Dashboard, Inventory Posting Setup, Interim Accounts, and the Inventory to G/L Reconciliation Report all reflect consistent and expected values. This confirms that the system is working exactly as it should, with no unexplained discrepancies.

If you have questions or want to review your own Health Check results, feel free to reach out I'd be happy to walk you through it.

To Learn More About the Health Check Dashboard check out Health Check – ERP Connect Consulting.

Comments

Post a Comment

Popular posts from this blog

Applying posted credit memos to posted invoices in Microsoft Dynamics 365 Business Central

-
Image
Applying posted credit memos to posted invoices isn't a hard task to complete in Microsoft Dynamics 365 Business Central. The example I use below is for a vendor credit, but the same process applies to customers.  Version: US Business Central 20.0 Open up the vendors list. Search for vendor that you'd like to apply the credit memo to an invoice for.  Click on Balance field to open up Vendor Ledger Entries window. This will show all the 'open' documents on the vendor ledger. Select the line for the Credit Memo that you want to apply to a posted invoice. Click Process > Apply Entries Within the Edit - Apply Vendor Entries window select the line(s) that you'd like the credit memo applied to.  Click Process > Set Applies-to ID This will put the users name into the Applies-to ID field on the line selected. To post the application select Process > Post Application. Written by: Kristen Hosman, Microsoft MVP
Read more

Reversing a customer payment in Dynamics 365 Business Central

-
Image
Steps to reverse a bank account transaction or customer payment in this case. Have you ever entered a customer payment and needed to void it out of the system? If so, this blog is for you! Follow the steps below to learn how to unapply a payment and void/reverse the payment. These steps will void the payment and the invoice will remaining outstanding when completed. Open the Bank Account Ledger Entries window and select the line for the transaction in question. ctrl+alt+Q on keyboard to open the Find entries page, or click on find entries on the Action Bar. Click on the Detailed Cust. Ledg. Entry line Select a line that has 'Application' as the Entry Type and then Unapply Entries on the Action Bar Click Unapply Yes OK Close windows until you get back to the Bank Account Ledger Entries page. Select transaction and then Reverse Transaction from the Action Bar. Reverse Yes OK Written by: Kristen Hosman, Microsoft MVP
Read more

Received not invoiced report in Dynamics 365 Business Central

-
Image
If you're using Purchase Orders (PO) in Business Central and have a receiving process that requires a warehouse team to receive items off a PO then this tip is for you. Within the Purchase Orders list you can personalize to add the column Amount Received Not Invoiced. This will all Accounts Payable and the Purchasing team to know what PO's have been received but not invoiced yet. To learn how to personalize Business Central check out this blog:  Personalizing Screens In Dynamics 365 Business Central (kristenhosman.com) Reconcile AP to GL There is also a report in Business Central called Reconcile AP to GL that can be useful. The name doesn't make sense but the data it provides does.  Search for  Reconcile AP to GL and make sure to bookmark it since it's hard to remember. Filter if needed or just select Print or Preview. Review the two pages. “The AP to GL Reconcile report is a 'point in time' report. It cannot be run for prior days as it gets its data from the ...
Read more