Utilities

File Description Versions
Run Sql Scripts Use to run SQL scripts to fix certain data issues Version 6.X
Version 5.X
Version 4.X
Convert Non Inventory Items to Inventory Items This tool goes against the QuickBooks database editing all the Non Inventory items and converting them to Inventory Items. In addition it flags the Non Inventory Items by adding the prefix "-old” so   a record remains on QB that this item was converted All Versions
Find List Id This utility will help you resolve entity errors when an entity instance has been deleted from QB. Entity Instance (Item, Customer, Vendor...) is the List Id
The error generally looks like "error 170000-1077114172 object not found...."
Version 5.X
Version 6.X
Import Quickbook Units of Measure All Orders maintains its own unique set of UOMs (Units of Measure) outside of the sets of UOMs Quickbooks maintains and the two do not sync. If you would like to perform a one time import which will generate UOMs in All Orders based on existing UOMs in Quickbooks, download and run this tool. UOMConverter.zip
Copy Reports Use this tool to copy a report that has been created in one All Orders file to another All Orders file. ReportMover.zip
Automating Backups Use this tool to automatically backup your All Orders data file. Be sure to read the included ReadMe.pdf in the zip file for instructions. NCBackup.zip
Import Historical Quickbooks Transactions Use this tool to import select transactions from Quickbooks into All Orders (Mainly for historical reporting purposes). ImportHistory.zip
Active Reports Help This zip contains the help file Active Reports which is used for All Orders reports. AR2Std.zip
Auto Importing Quickbooks Sales Orders Into All Orders Use this tool to automate the importing of Quickbooks Sales Orders into All Orders. Handy if something exists that is already generating Sales Orders in Quickbooks from another application, such as an ecommerce website. QBSOIMport.zip
Note: Download the zip file to your computer. Extract the enclosed exe file to any folder and double click it.