There are several utilities available within MicroBiz to keep your system safe and healthy. Some of these routines should be used on a regular basis, and some are just there in case they are ever needed. Familiarizing yourself with these tools is the first step to ensuring that your system will stay happy!
Reindex, Clean & Pack
This utility should be used on a regular basis to ensure that your files are kept current. Running "All Files Above" at least once a month is recommended. The Reindex feature will update your .CDX (index) files and the Clean & Pack feature will update your .DBF (data) files. Aside from regular use, you can run a Clean & Pack any time you feel that your records might be incorrect.
This process can be performed for specific types of files individually or altogether. To run a Reindex/Clean & Pack:
- From the Main Menu, choose Management, Reindex/Clean and Pack, etc.
- Choose the routine desired: Customers, Product, History, Miscellaneous, or All Files Above.
Before running any of these routines, it is advised that all other instances of MicroBiz be closed first. Depending on your computer and the amount of data used by MicroBiz, this process can take several minutes or even, in rare circumstances, hours. DO NOT INTERRUPT THE CLEAN & PACK PROCESS! This could cause serious database corruption.
For this reason, it is advised that this process be performed at a time when the system is not going to be used for ringing sales, receiving inventory, etc. It's a good idea to try this process out at such a time before you need it, to establish a baseline of the time required by your system.
Recalculate Customer/Product Data
The Recalculate ("Recalc") utilities can fix certain inventory/sales figures, should you ever suspect they are incorrect, based off of your stored product/invoice data.
These utilities are found just under the Clean & Pack utilities as shown above. Here is a list of the routines available, and what each does:
- Recalc Customer Buckets –Recalculates the sales period (Year-to-Date, Quarter-to-Date, etc.) figures stored by MicroBiz.
- These figures are available for viewing by selecting a customer and choosing "Explode" from Customers, Customer Add/Edit.
- Recalc Customer Balance Due –Recalculates the outstanding balance for each customer's house account.
- This only applies to Business Controller Plus users.
- This procedure can be performed for a single customer from the Work Screen by double-clicking on the Balance display in the upper-right corner.
- Recalc Customer Credit Balances –Recalculates the outstanding store credit figures for each customer.
- This only applies to Business Controller Plus users.
- This procedure can be performed for a single customer from the Work Screen by double-clicking on the Credit display in the upper-right corner.
- Recalc Product Buckets –Recalculates the sales period (Year-to-Date, Quarter-to-Date, etc.) figures stored by MicroBiz.
- These figures are available for viewing by selecting an inventory item and choosing "Hist" (history) from Inventory, Inventory Add/Edit.
- Recalc Product Backorder Quantities –Recalculates the backorder figures for all items.
- These figures are available for viewing by Reports, Backorders.
As with the Clean & Pack process, Recalculations should only be performed when all other users are out of the MicroBiz system to prevent data corruption.
Duplicate Files Check
This utility checks the data files in both your System and Local Files Paths (as defined under Management, Customize, Windows Settings) and ensures that no files are found in both directories. The option for running this check is found under Management, Duplicate Files Check (as seen in Figure 18-1).
Some files should never be duplicated, and a MicroBiz Support Technician may ask you to perform this check if duplicate files are ever suspected.
DBF Scan for Corrupt Files
This is another utility that is used more often by MicroBiz Support than by end users. It will scan your data files and report on any corruption found. This can be run by choosing the option under Management, as shown in Figure 18-1. If you wish to perform this scan but are unable to open the MicroBiz program, you can run "dbfscan.exe" which is found in your Local Files Path (usually C:\BizWin).
Query Rebuild Index
This utility is used to rebuild the index files used by Queries. If you ever get an error when running a Query, this tool is the first thing to try.
MicroBiz backups are highly recommended! Some users have their own utilities for backing up their data, but this utility makes using other applications unnecessary.
To configure MicroBiz backups:
- From the Main Menu, choose Management, Customize, Global Settings.
- Click on the File Backups tab at the top of the screen.
- Choose the backup type from options 1-5.
- Never do any Backup – This option is only recommended if you have another way of backing up your MicroBiz data files. It is ALWAYS recommended to back up your data!
- Ask me each time after every Close Out – You will be prompted to back up after completing each Close Out (usually every day). You have the option of choosing not to back up each time with this method.
- Automatically after every Close Out – The backup procedure will take place, without prompting, after completing each Close Out.
- Ask me each time before every Close Out – You will be prompted to back up at the beginning of each Close Out (usually every day). You have the option of choosing not to back up each time with this method.
- Automatically before every Close Out –The backup procedure will take place, without prompting, at the beginning of each Close Out.
- This option should be enabled by default on new installations of MicroBiz.
- Select the Backup Directory. This is NOT the directory that will be backed up (this will always be data from the System Files path), but rather the location in which MicroBiz will save your backup data.
- Click on the Save button to exit and save your settings.
You can also perform a backup whenever desired by navigating to this menu and choosing "Back-up now."
It is also highly recommended that an external or off-site copy of backups be updated on a regular basis (i.e. on a CD or flash drive). Performing regular backups helps to ensure that your data is safe! For more information on backups,
By default, MicroBiz invoice numbers have an upper limit of 999,999 (due to the system only using 6 digits for this field). If you find your invoice numbers approaching this limit, there is a utility that can expand the invoice number range for you. If you have already reached this limit, you might have seen error messages such as "numeric overflow." This means that it may be critical for you to get your invoice number range expanded (or perhaps a range of invoice numbers has been skipped).
Using this utility, and troubleshooting this scenario in general, should be addressed only with the aid of a MicroBiz Support Technician. MicroBiz Support can be reached at (800) 929-8324 (call may be billable depending on support contract status).