Future of BV
End of BV FAQ
Spire HELP
Spire FAQ
BV Essentials
The Cloud
Privacy Policy

Wildwood Canada BusinessVision Help

How to resync the On Order, Back Order and Committed Quantities in Inventory

Sometimes, due to system problems such as network interruption or an over-busy network, the On Order, back Order, and Committed quantities in Inventory will get out of sync compared to the values that are actually in Order Entry and Purchase Order. Here is how to bring them back into sync.

The numbers being referred to are these:


To adjust these numbers one must do a Reorganize of the Inventory file. All users must be out of BusinessVision for you to be able to access this item. As well you must of course have rights to access it within BusinessVision.
From the menu, select File, Reorganize Files.


Select Inventory from the list of modules on the left side. In the big box on the right side check the box beside Recalculate On Order/Committed quantities.


Then click the Reorganize icon to start the process.


After a confirmation to proceed, you will shortly receive notification that the process has completed. It usually doesn't take more than a few seconds, unless you have a large number of Sales Orders or Purchase Orders in your system.

Still not fixed?
If after doing this the numbers are still not making sense, you may have what are called "orphan records" in either Sales Order or Purchase Order. These are detail line item records in the files that are not attached to any header record. These occur when a Sales Order is invoiced or a Purchase Order is closed and not all the detail lines are removed during the process.
To get rid of these is a simple process, but unfortunately not for the average BusinessVision user! Technical knowledge of SQL language is required for this. Please enlist the help of Wildwood Canada if you have this issue.

Wildwood Survival
Wildwood Tracking
Stone Age Skills
Tracking Quiz
Tracker Trail
Ontario Wildflowers
Ontario Trees & Shrubs
Ontario Ferns
Ontario Grasses
Grey-Bruce Wildflowers
World of Mosses
Ontario Insects
James Bay Road
Route de la Baie James
Rupert River
Trans-Labrador Hwy
Moped Trip
Wildwood Canada
Wild Ontario
Earth Caretaker
Wildwood Trackers
Ontario Trackers
Orangeville Trackers

The material on this page is copyright by Wildwood Canada Inc.