Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

November 11, 2009 by

2 Comments

This star rating of the post below was determined by two factors: how many times the post was read, and by how engaging the post was as measured 'by time on page' metrics from Google Analytics.

Velosio

Historical Inventory Trial Balance – Obtain a TRUE Inventory Balance in Dynamics GP


Email | Print

Attention all Inventory Managers!  Microsoft Dynamics GP has made it easier than ever to determine your current inventory balance with the Historical Inventory Trial Balance (HITB) module.  Reconcile, create clearing transactions and run validation reports all within the historical inventory trial balance module. Now, the HITB report can be used to reconcile General Ledger (GL) any time of the month.

Gone are the days of remembering to print the Stock Status at month end and remembering that not all transactions make it into the Historical Stock Status.

The Historical Inventory Trial Balance report provides a current and historical value of your inventory items.  It lists quantity balances by each of the five quantity types (On Hand, Returned, In Service, In Use, and Damaged) and inventory values at a certain point in time or for a designated date range.  You can use this report as the basis for balancing your inventory with the appropriate accounts in General Ledger.  You can run the report for a single GL account or run the report without any restrictions to reconcile the entire current inventory value.

In order to utilize the Dynamics GP’s Historical Inventory Trial Balance, the following items must be performed:

  • While not required, you should perform an inventory stock count to be confident that you are working with accurate quantities
  • Post all un-posted inventory related batches
  • Install HITB on server and each workstation
  • Run the IV reset tool to calculate the appropriate starting inventory amounts.  This process will not affect current inventory quantities but it will post a journal entry to account for differences between the inventory value and general ledger.

 Contact SBS Group or email info@sbsgroupusa.com to learn more about the Historical Inventory Trial Balance module.  It is available in Dynamics GP 10.0 w/ Service Pack 2 and more recent versions.

 By: SBS Group – New Jersey Microsoft Dynamics GP Partner

November 11, 2009 by

Email | Print
Velosio

Ask The Author

Tags: , ,
Posted in About Microsoft Dynamics GP, Dynamics ERP for Distribution, ERP Software Information, Microsoft Dynamics ERP Functionality | 2 Comments »

More Posts By Velosio

  1. Are the Analytics in Your Business Management System Enough?
  2. Power BI Mobile Apps: What They Are and Why You Should Be Using Them
  3. Selecting a New ERP or Business Management System? Be Sure It Supports These Microsoft Excel Capabilities
  4. The Power of Data Integration: When Your ERP Connects with Your Email and the Microsoft Ecosystem
  5. 3 Steps to Implement the Right Accounting Solution for Your Business

Related Posts

  1. The Top 12 Reasons Why Inventory Managers/Materials Managers Use Microsoft Dynamics GP as their ERP system of choice
  2. Baker’s Dozen of WMS (Warehouse Management System) Acronyms Defined
  3. SalesPad Mobile Order Entry Now Available for Dynamics GP
  4. What’s New in Microsoft Dynamics GP 2015?
  5. DynaRent and the Internet of Things: ideal for Equipment-driven businesses

Comments are closed.