Knowledge Base

A collection of articles ranging on how to questions answered to steps by step guides on popular workflows to error and warning messages explained.

Articles

Error: -247467259 error-cannot open database login failed
If you are receiving this error it is possible that your Database has gone offline. Please follow the below steps: *** Perform the following steps on the SERVER 1. go to the start menu and open CONTROL PANEL 2. go to ADMINISTRATIVE TOOLS 3. ...
Why is AO average cost different from QB?
The average cost in All Orders is pulled directly from QB. Notice in the Inventory Item screen, of AO, that the average cost is not a field that you can update. That is because AO does not calculate the average cost, instead it pulls the average cos...
After I create the ship doc in NC, what do I have to do for it to sync to QB or does it do it automatically?
Once your items have shipped, click on the Invoice button (icon) on the Ship Doc screen’s toolbar and the invoice will automatically sync with QB, if your preferences are set up to automatically sync.
Which Bins/Lot/Serial #s are chosen when auto filling on Ship Docs or auto picking on Work Orders?
In our typically scenario we will first check if lot/serial #s are being pulled from inventory. If they are we will select the ones with the oldest expiration dates first. If you are not tracking expiration dates then the ones that have been in inve...
Invalid object name deleted Updated
If you are receiving the above error message, please follow the below steps to fix this issue. 1. Download the attached file to your desktop 2. Login to All Orders as Admin 3. In All Orders do File - Maintain 4. Click the 'Advanced' Tab 5. ...
Installing AOM for Windows 10 Systems
If you are having trouble installing Windows Mobile device center on a Windows 10 PC: -------------------------------------- 1. Make sure that Windows mobile device center is installed on the PC.( even if it is the old version that is installed. ...
Rerecord Stops Working
There are many reasons that the rerecord might stop functioning properly including, but not limited to, connectivity issues and timeout error. If this occurs you can continue to use your file as normal. When you are ready to restart the rerecord, r...
Invalid File Name error when opening All Orders
This error occurs when All Orders is trying to open the last file that was opened but is unable to. There are a few possible causes for this. -If you have not opened All Orders since you have logged into Windows some of your mapped drives may no...
The min quantity must be less than the max quantity
This is a known issue that occurs due to Quickbooks adding a new Max Quantity field to the items and filling in a value of 0 instead of leaving it blank. To fix this issue, all the max quantities for items in Quickbooks must be reset to be blank i...
Emails sent from Order Time have warnings associated with them that they might be spam or phishing
When Order Time sends emails, while they are being sent from the Order Time server, we will show the email as coming from your own email address. That way the recipient of your email will not be confused and any replies will be directed to you. So...
Entering BOM components as percentages
BOM components can be entered as percentages. This specialized function is geared towards components that are part of mixes which make up the finished good. Here is how you can start to enter your BOM components as percentages: 1) Open the company...
Merging Item in QuickBooks - All Orders
When you merge an item in QuickBooks and then synchronize, All Orders thinks that the item has been deleted and will attempt to delete it as well. If there are transactions using that item, All Orders will be unable to delete it but will make it inv...
Understanding Dependencies
Overview A dependency is when one transaction relies on another transaction.   Some systems call this concept cross-docking.  For example the fulfillment of a sales order may not occur until a purchase order is received.   The tran...
How To: Setting up templates for the subject and body of emails
In All Orders, templates can be created to be used as the subject and body depending on the form or report being emailed. Here is how! -Go to the Lists menu and then Profile Lists, Sales, Custom Messages. -Here new "messages" can be crea...
HOW TO - Opening All Orders 6 client without QB (additional tips)
All Orders 6 client can be open without QB being open on the client...however this implies that a QB file was at least open once to create the All Orders company file. This QB file must have been set to have the Integrated Applications Preference in...
Excluding bins when picking a work order
When allocating a work order using the Pick Selected or Pick All function, All Orders can exclude bins that are marked as unavailable. Then in work order preferences UNCHECK 'check for unavailable bins when picking'. You must als ensure the allow ...
Reports are very slow or cause the system to hand or become non responsive
This can be caused by the indexes in the database needing maintenance. To reindex them open All Orders as the admin, go to the file menu, click maintain, and then click the reindex button.
Medical Device Excise Tax
As part of the Affordable Care Act (aka Obamacare), manufacturers of the medical devices will be required to charge Medical Devise Excise Tax (MDET) starting January 1, 2013. This tax is to be treated like any other sales tax. US QuickBooks 1....
Automation error library not registered" when trying to send an email
This error is caused by a particular library not being installed on the workstation that is required to send email. Please follow these steps. For users with Office/Outlook not installed at all: Follow this link and download and install the th...
Why is QB QOH and Quantity different on the Item List.
QB QOH is the quantity on hand within QuickBooks. All Orders will update QB QOH when ship docs, receivers, adjustments and work orders are recorded in QuickBooks. Quantity is the quantity that All Orders computes. Quantity is updated when ship doc...
How does currency or currencies work in All Orders.
All Orders works with currencies as follows: Item Editor: Price (standard price) and Cost (standard cost) are in home currency except for on the vendor list where the cost is in vendor's currency. Sales Order, Ship Doc, PO and Receiver when cust...
Reports are not showing all of the pages/data
When you open a report directly from Design Reports or from its icon, it automatically opens up in Design Mode. Design Mode only gives you a sample of pages or data on the report so that you can quickly switch back and forth from the Preview and Mod...
Item is on list but not on sales order or purchase order
All Orders has the ability to show you items where they are needed. For example if you buy items for production but never sell them, why should the be on the sales order. Whether an item shows in a SO, PO or WO depends on its GROUP and particularly ...
How does the New Quantity Count work?
The New Qty Count, located under the Warehouse menu, will list all of the items that have current quantity on hand for a specific location. It will list the quantity for each item, bin, and lot and serial number. You can print this list called the C...
Can you process more than one sales order at a time.
1. Do Sales --> New Batch Shipment  2. Adjust your filters and allocate by accordingly  3. Click Process  After the ship docs are completed you can go into the shipping list then  1. List -- Select All  2. List --> Record In QuickBooks. ...
What date is used when a work order is finished.
By default the work order when a work order is finished, it is marked as finished on THAT date. That date will be used as the Posting date in QuickBooks and All Orders Ledger reports. You can change this behavior in Work Preferences by checking '...
Purchase Order does not print i.e., prints a blank PO
This happens on version 6.1.27 or lower This occurs because the PO needs to be approved before printing it
Sales order approval
As part of your system of internal controls, you may require that all sales be approved by someone authorized to do so before being filled.    All Orders enables sales order approval so that if a sales order is not approved, it cannot be filled nor ...
Inactive Component in a BOM and Work Order- How to Replace?
Once you make an item inactive, that item is still listed in the BOM and Work orders. A feature we have is to replace a component with another component. It is located in the Item List. Check the inactive item, right-click your mouse, and select Rep...
Synching Transactions to QB
Here is a list of all of the transaction screens that will sync to QB: Ship Docs Receiving Docs Work Orders Customer Returns Vendor Returns Quantity Adjustments Value Adjustments ALL transactions can be synched to QB using the following options...
Sales orders with multiple shipping dates Updated
In your business your customers may place 'blanker orders' or orders in which your customers want to be shipped on specified dates.   One solution is to create multiple sales orders however All Orders has the ability of handling mu...
Using Enhanced Inventory Receiving in Quickbooks with All Orders
Without Enhanced Receiving, the Item Receipt and Bill in Quickbooks are one transaction and an item receipt is simply changed into a bill once the bill is received. Using the new enhanced receiving, the item receipt and bill become separate transact...
There is an invalid reference to a parent *.* in the Bills list. Quickbooks error message: Invalid argument. The specified record does not exist in the list.
If you receive this error and you are using the Canadian/UK versions, then in QB, open the Sales Tax Code list, create the new tax code only using the period symbol ( . ) and save. Do a Selective Sync in AO. You will now have a ( . ) in AO Sales Tax...
AOMobile Settings
Preferences for All Orders Mobile Scanner Auto Fill for Pick Screen: <AutoFill></AutoFill> indicates what to auto fill in the text box on the pick screen. <AutoFill>0</AutoFill> indicates auto fill is OFF. <AutoFill>...
Linking Work Orders and Sales Orders
If the WO already exists, Open the WO, click on Details - Dependency - click Add (you can filter by date or location). This will generate a list of SOs. Click the Include box for the SOs you want to link. If a WO does not already exist, Open the Sal...
How to create a System DSN / ODBC Connection for Microsoft SQL Server
The article details how to setup an ODBC connection to the AllOrders database. This must be setup on the computer where you installed the AllOrders SQL Server. 1. Start Windows Administrative Tools (Start > Control Panel > Administrative Too...
Home Screen
The Home Page The All Orders Home screen is a special launch screen that serves as a handy one-stop collection of all the most often-accessed lists and forms. There are two sections of note. The first is a quadrant that represents the four aspects...
AO Web Address by name
Be sure to setup a sub domain to point to your fresh new All Orders product website to make it easily accessible outside your local network. For example, if my website was bakery.com I might setup orders.bakery.com for my wholesales customers...
Linking my All Orders Sales Order Number to the Invoice in QB
1. Create a custom Field in QB items. Open any Customer in QB>Click on Additional Info> Define Fields>Enter in the Customer field label for Sales Order # and click on use for Customer. 2. In the QB invoice, go to the Formatting Tab and se...
I created a transaction (e,g, Sales Order) but I cannot see it on the list.
If you created a transaction but cannot see it on the list may mean your user is filtered for location or sales rep. (Company - Manage Users) Ask the admin to change your user privileges or input the correct rep or location on the affected transacti...
All Orders Solidworks Integration
All Order can now integrate with Solidworks! Using the propriety drawing files created by Solidworks, All Orders can now populate Bill of Material components and attributes without users having to manually update them in All Orders. Simply browse ...
Qty on Order but no PO's or WO's exist
This generally means that PO's were done in QB, the On Order qty reflects the PO's in QB as well as in NC
Error while creating step, converting string to datetime
With certain regional setting, you may getting an error creating a step relating to converting string to datetime.  The issue relates to how your regional setting show the date AM or PM.  For example, 4/5/2007 12:45:10 a.m. will generate an error....
Manually Controlling How All Orders Synchronizes Currencies And Exchange Rates
Typically, All Orders can determine whether or not Quickbooks has the multi-currency feature turned on or off by querying the Quickbooks company preferences. At times, however, there may be issues retrieving this information in which case we may nee...
Non US Customer Tax Settings Not Visible
This issue is caused by some Quickbooks files not sending the correct tax settings to All Orders. You can fix it by following these instructions: 1. Have everyone log out of All Orders. 2. Log into All Orders as the admin and then click on the F...
Off-Site Backup System
We recommend using iBackup.com as the off-site All Orders backup program. Use their SQL Server plug-in that they provide for you. Be sure to read through their help documents to get it up and running. Go through each step to make sure you have...
Why will the Count not finalize?
If there are no quantity differences the count will not finalize. This is a known issue. To work around either make an adjustment to at least one item or delete the count.
Sales order list not showing sales orders just entered
Check the user rights and make sure sales rep or location is not filtered for a specific rep or location. Make sure there are no other filters selected for this list...check the left down portion of the screen to ensure this if there is a filter sho...
Invalid use of NULL
If you are receiving this error, typically it means that there is a piece of information that is missing somewhere. Remove the item/doc that is causing the error from the sync queue-->make sure the sync queue is clear--> run a selective select...
Setting up Custom Fields
If you find that you need to set up information for one of your lists where there is no corresponding field, you assign a custom field to fill that role. For example, if you're in the habit of sending your customers a greeting card every year on...
Value Adjustment error when sending a Bill (must be positive)
An error occurs when you are decreasing the value of an item and you create the value adjustment. QB will not allow you to send a negtive bill. Therefore, delete the vendor and the ref# from the adjustment. Now, send your adjustment to QB. Create th...
Transaction (Process ID 60) was deadlocked on lock
Deadlock occurs when two users have locks on separate objects and each user wants a lock on the other’s object. When this happens, SQL Server ends the deadlock by automatically choosing one and aborting the process, allowing the other process to con...
This application has not accessed this QuickBooks company data file before
Symptoms When you open NumberCruncher either for the first time or after an software update, you may get the following error: Open QB: This application has not accessed this QuickBooks company data file before. The QuickBooks administrator must ...
Error when entering shipping or freight amount.
After selecting a ship method and entering an amount, you get the following message. To assign a price with a ship method, it must be associated with an item. Close the sales order open the ship method list and assign it to an item. To correct t...
Why does the Batch Shipping screen pop up when I am trying to fill a Sales Order?
The Batch Shipment Screen shows up if: #1 The "Ship From Location" field is left blank in the Sales Order. (See screen shot - BlankShipLoc) Since you may have multiple locations where you can Ship from, the batch shipment screen will pop up to s...
How to change the display on the Item Drop Down
1.Go to Preferences 2.Click My Preferences Tab 3.Click General 4.On the bottom right you will see a box that says ' Columns currently ...' 5.Click Add 6.Check or Uncheck the desired columns 7.Click OK 8.Click Apply
How do you remove all locations except HQ
Log into All Orders as the administrator,  Go to File -> Maintain -> Backup  Then from the Location List select the location(s) you want to delete then right click your mouse and press on delete selected
Error: User X is currently syncing. Please try again when that user has completed syncing.
When attempting to sync with QuickBooks, you may receive Error: User X is currently syncing. Please try again when that user has completed syncing. Solution: 1. Login to All Orders as Admin 2. In All Orders do File - Maintain 3. Click the 'Advan...
How to put a hyperlink in a report.
1. Draw a label on to the report in the location you want the hyperlink to apear.  2. Open the properties box for the label.  3. For 'Hyperlink' type the URL enclosed by quotation marks (eg. " www.numbercruncher.com ")  4. For Capition type what yo...
How do I close, void or clear a sales orders
At times your customer may cancel some or all of a sales order. If you do not want to delete the sales order you can close it manually by CHECKING the Clr box on each line item then click Save. You can also go to the Sales Orders List, Check the S...
"Method '~' of Object '~' Failed
"Method '~' of Object '~' Failed" CAUSE You structured the parent child hierarchy of your items or customers. RESOLUTION Go to Company - QuickBooks Sync - Selective Sync, Check all the boxes and press OK. This process may take a while so do not...
What 'Cost' is used on the Bill of Materials?
NumberCruncher uses Cost as Entered or Vendor Cost for the FIFO cost of the 'Quantity Per' on the bill of materials. When you create an item in QuickBooks without an opening value and quantity, QuickBooks uses the Cost field as the average cost. A...
User Access Violation
When editing a record in All Order or when attempting to open a list. You may get an error message which states User Access Violation.     To resolve please have the administrator adjust your user setting within Manage Users. There is also a...
Accessing All Orders Web & Mobile outside the local network ( external IP)
  Please refer to the following documents for some basic instructions on making our web based products accessible outside of the local network where it might be hosted. Adobe PDF http://numbercruncher.com/docs/Accessing_All_Orders_Web_Outsi...
Using the Scan box with No Scanner Option
You do not need a scanner to use the scan box, you can simulate a scan by using the Tab Button on your keyboard. In the scan box you can type in the Item Name, Item UPC, Manf. Part #, Vendor Part#, Vendor UPC, and Descriptions. Partial entries can...
How to Add Fees to a Sales Order
If you want to add an additional Percentage based Fee to a Sales Order here are the steps:   1. You must first turn on the option. Log into AllOrders as the admin.     Go to COMPANY-->PREFERENCES-->SALES ORDERS-->Company Preference t...
How to buy inventory on a credit card?
At times you pre-pay or purchase items using a credit card. A duplicatepurchase can arise when you receive the items through NumberCruncher and postBill in QuickBooks. To avoid this do the following: 1. Create an 'Other Current Asset' (e.g. Prepai...
How do you give an advance payment to a vendor?
At times you may need to pre-pay a vendor for a purchase. A duplicate purchase can arise when you receive the items through NumberCruncher and post Bill in QuickBooks. To avoid this do the following: 1. Create an 'Other Current Asset' (e.g. Prepai...
Use Individual Line Discounts To Total The Order Level Discount - Advanced Sales Order Preference
This preference will change the way line item prices on invoices are posted into Quickbooks. Typically when a ship doc is sent to QB and an invoice is generated each line item on the invoice will have the specific price per as specified on the ship ...
How to do you copy or duplicate a sales order or purchase order?
1. Find the relevant order on its List 2. Highlight the row 3. Right click your mouse 4. Select 'Duplicate' 5. Confirm by pressing OK 6. Make changes to the order as appropirate 7. Click Save
Multi-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done--- Version 6.2.35 only ( SO LIST )
If you are getting the below error in Version 6.2.35: SAVE THE ATTACHED SCRIPT TO YOUR DESKTOP Log in as admin --> go to FILE-->MAINTAIN-->ADVANCED--> RUN DB COMMAND--> Browse to the saved file--> select file--> run.   ...
Cannot log into All Orders on some machines
All Orders uses UNICODE for some of its functions and depending on the regional settings and character sets it may prevent a user from being able to log in. If a user has their password reset but it still unable to log in on their machine try follow...
Script to add items with zero quantity to Count
Close any open Counts -> run the script below -> log out of all orders and log back in -> Open a new Count and you will see all items. In order to fix the above issue, we have created a SQL script to run on the computer which has All Orde...
Sync Error on Account Type - UK QB
Description Upon Synchronizing with QB using the UK QB edition, an error occurs saying 'Invalid Account Type' Cause: QuickBooks Chart of Accounts Definition Resolution: You must change the QB accounts type from "Suspense" to "Non-posting"....
The specified name is invalid or of the wrong type
QuickBooks customers, vendors, and employees exist in the same database table. When you look at vendors, you're looking at a filtered list of records where the customer type is vendor. Customers can have a type of other. Our system cannot locate cus...
All Orders Mobile - Error: Cannot connect to web services
The first thing to test when barcodes are not scanning properly into All Orders Mobile is whether or not the scanner has been configured to properly scan and add a terminating character, in this case a carriage return character. To tun a quick test ...
Non-inventory items have no description or prices
Cause The Purchase and Sell option is not set for your item. Resolution Within QuickBooks, edit the item and check the Purchase and Selloption. After you have checked the Purchase and Sell option, you will seePurchase Description, Cost, Prefer...
How do I include EMPLOYEE costs?
This is the way you do it: 1. Create an Item called Labor (should be a service item) select a new expense account 2. Include the labor component in bill of materials. 3. Labor will never be out of stock 4. When you finish production, the labor cos...
Setting up default payment gateways per customer
Starting in version 6.1.73, All Orders now allows you to setup a default gateway for each customer based on a custom field on the customer/document. By doing this the custom field value can drive which gateway is used. This is commonly implemented i...
Costing in All Orders
All Order maintains a 'shadow inventory sub-ledger' which applies an alternate valuation method than that used in QuickBooks. QuickBooks uses the weighted average cost while All Orders applies a combination of specific identification and First-in-fi...
PO's not syncing
The normal process of AO is to create the PO, Receive, and Sync the bill from AO to QB at the end of the process. Therefore, the PO will not sync to QB, it will sync only after it is received and billed. To set AO to sync the PO from AO to QB: Go ...
How can I find a list of BOM's that contain a specific component?
If you have a component and you need a list of exactly where that component has been used, you can use one of the two methods below.   Method 1: Go to the "Production" menu--> select " Bulk Update BOM" Enter the component name in t...
When you add a price level in Number Cruncher, how does it get added in QB? It seems that when you synch, the new price level doesn?t appear in QB.
QuickBooks only allows 2 types of price levels, Customer Item Price and Customer Discount. In All Orders, when you select either one of these types, a box will appear stating “Is QuickBooks Price Level”. Check that and it will sync with QB. However,...
Checking customer credit
If you use the credit limit function within QuickBooks, All Orders can provide information on a customer's credit status at order time.     To enable, CHECK 'Check credit limit before saving sales order' in Sales Order Preferen...
Creating Custom Data Sources For Custom Reports
Below you will find a guide in both Word and PDF formats detailing how to create custom data sources for custom reports which will never get overwritten in future updates to All Orders. https://info.ordertime.com/hubfs/CustomReportDataSources...
Understanding Quantities in All Orders
There are different quantities that All Orders works with. The following is a description of how it works. The basis for all quantities in All Orders is derived as follows: Adjustments + / - Work Orders - Finished Goods (Produced) + Work Ord...
All Orders Web ( AOW) - How can I change the logo or picture
To replace the image, you must locate the logo.jpg in the following directory of the website: aoweb/App_Themes/SmokeAndGlass/images/Logo.jpg The aoweb directory will by default be located here: C:\Inetpub\wwwroot ...
Settings up Gmail In All Orders
To send emails directly from All Orders using any GMail/Google email account follow these steps: -Open All Order as the user that is going to be sending the email. -Go to the Company menu and click Preferences. -Select the Email preferences...
Error 3631:Violation of PRIMARY KEY constraint 'PL_tblitemLot'. Cannot insert Duplicate Key.
This error typically occurs when a SD has the same item listed on Multiple lines and one line is deleted. The workaround is to save the SD as soon as you delete the line, and then continue working. You can also try changing the line to be a differen...
How to Change your Logo in AOW
To change the logo in AllOrdersWeb, navigate to the following path: C:\inetpub\wwwroot\AOW\App_Themes\SmokeAndGlass\Images In this location, you will see a file named " logo.jpg" This is the file that you are going to replace. Save the...
The validate record has been updated at the same time by another user. This save has aborted.
Error -2147220958 The validate record has been updated at the same time by another user. This save has aborted. This error means another user has updated the record in QuickBooks. Solution: Close the tab you are trying to Save in All Orders. Also, m...
When do transactions hit the All Orders Ledger?
- Ship Docs/Customer Returns - when Shipped is checked (if not this will also happen when you click Invoice if the prereneces to mark as shiiped is selected)  - Work Orders - when status is changed to In Production of Finished  - Receivers/ Ve...
Installing the All Orders client silently / Network Installation
This topic is for network administrators wanting to install All Orders on multiple workstations without having to go through the full installation dialog each time. Please download/view the document below for instructions. Adobe Acrobat Reader PD...
How to make items inactive
To make an item inactive, open the inventory item screen and check the box, to the far-right, Item is inactive. When you open the item List, there is an Is Active filter for you to separate the items. Once an item is inactive, you can no longer use ...
Shipping methods - All Orders will not let me edit, make inactive, or delete
Some Shipping Methods found All Orders are currently found grayed out not allowing you to edit/modify, inactive, nor delete them. This is because Quickbooks does not allow this is happen. You need to make the necessary changes in Quickbooks. In ...
On Backups in AO and on System Backups
When considering to backup your All Orders database you must be very careful in that some offline backup utilities used for System Backups may not backup the AO database. Depending on which utility you are using for system backups, you must check if...
How to find your company files (config files) and error logs
To find your company files (config files) and error logs: On your Windows toolbar, go to Start and Computer. In the pop-up box, make sure that you are using the Small Icons view. Select: C:\Users\Your Computer’s folder\AppData If your App...
Error -2147217913: The conversion of char data type to a datetime data type resulted in an out-pf-range datetime value
Error -2147217913: The conversion of varchar data type to a datetime data type resulted in an out-pf-range datetime value If you are receiving this error it is being caused by the Regional Settings on your machine being set to something other than...
Invalid use of null or Invalid procedure error when posting a transaction to Quickbooks
The most common cause of this error message is when an item exists in All Orders which was never created in Quickbooks and the item has not been assigned a proxy and is not in the sync queue waiting to be posted to Quickbooks. To resolve this issue ...
How to change the Company Address in Reports
If you are connected to QuickBooks, update the Company Information. That is where AO pulls the address, phone and fax numbers, as well as emails. Next, update the location in AO. It can be found in the menu Lists and Locations. Double-click your l...
Error 1911 Could not register type library for file AOLib6.dll
Setup program causes Error 1911 Could not register type library for file AOLib6.dll Resolution: On File explorer locate the following file: For 32bit, c:\windows\system32\cmd.exe or for 64 bit, C:\Windows\SysWOW64\cmd.exe click just ...
Syncing Tracking Number to QuickBooks
In order to sync the tracking number on the All Orders Ship Doc to the Invoice in QuickBooks please do the following. 1. In QuickBooks create a Customer custom field called Tracking No. 2. In All Orders, make sure you are logged as Admin and do ...
How do you restrict items being added to an existing purchase order.
When you 'Run Analysis' and check 'add to open orders' , All Orders will find the latest 'open' order for that vendor. Also if you have 'Use SO or PO location on linked POs' checked it will find the latest PO last 'open' PO with both the same vendor...
Using the TAB key
In All Orders you jump from one field (i.e. entry box) to another using the TAB key not the ENTER key. Copyright © 2012-1999 NumberCruncher.com, Inc. All rights reserved. ...
Doc already exists in Quickbooks with a matching reference #
This message will show if All Orders finds what it thinks is a duplicate of the document that is being recorded in Quickbooks. There are a few options for dealing with this message. -If the document does in fact already exist in Quickbooks you can...
Error 2018 Page Margins too large when running reports
Log in as ADMIN---> Go to Company --> Preferences --> Reports, make sure Apply Default Printer is unchecked. Try to edit the printer preferences by switching from landscape to portrait or vice verse depending on what the setting is now. ...
The integrated application has no permission to access personal data
Error When syncing a customer or sales order payment you may receive the this error message. Cause This will occur when you do not allow All Orders to share personal data or credit card information and you updated to version 6.1.50 or later. ...
How can I find out what my inventory stock quantities were as of a specific date?
Using the Inventory Movement Summary Report will allow you to filter for a specific date range. Filtering for a date range will summarize the totals so if you look at the Sum Qty Column it will display the summarized total for the quantities for a...
How to Limit SQL memory usage
If you find that SQL server is using too much memory on your server and causing it to run slow and lag then Please see this article:   https://www.javelin-tech.com/blog/2017/11/microsoft-sql-standard-memory-limit/   No matter which version...
Entering Trial or License Codes
Entering the Trial Code Before you purchase All Orders you are granted a free trial. You will have received a trial ID from NumberCruncher. When you launch All Orders, enter the Trial ID and press OK. Note, that you must be connected to the Intern...
Script to Sync Barcode field from QB
In order to fix the above issue, we have created a SQL script to run on the computer which has All Orders installed. 1. Login to All Orders as Admin 2. In All Orders do File - Maintain 3. Click the 'Advanced' Tab 4. Press the 'Run DB Command' butt...
Crediting credit cards not linked to prior captures/sales using the Authorize .Net Payment Gateway
Authorize .Net accounts require special permission to be able to process an Unlinked Credit. Per the Authorize .Net Website: This transaction type is used to issue a refund for a transaction that was not originally submitted through the payment ga...
Error - Violation of UNIQUE KEY constraint IX_tblDependency
This error is generally caused when the following steps occur: 1) A Work Order is created with components which are sub assemblies. 2) A linked Work Order is generated from the original Work Order. 3) The due date is changed on the original Wo...
How to add a Style name to a Sales Order or Quote?
First open the sales order or quote and enter the customer's name. Next, open the Style List from the the List menu, select the style to be entered, and right-click your mouse. Select Add to Open Docs, then choose your attribute selections. Wh...
Error 5: Invalid procedure call or argument when opening All Orders
When opening All Orders you may receive Error 5: Invalid procedure call or argument Source: AOLib6 - LoadCompanyObject. Solution: The Regional Settings in Windows need to be set to English (United States or Canada) format.
How do you turn off sync on startup
On the login screen there will be a check mark set for sync on Startup Remove the check mark
Cost and Foriegn Exchange Rates
When you change the exchange rate on foreign currencies, the cost on the Item does not change in Home Currency for the products being purchased in the Foreign Currency. The preference is not visible in the user interface. If you want the cost for ...
Creating Ship Docs Updated
Ship Docs are transactions that show what Items are shipped to Customers.  Ship Docs usually correspond to Sales Orders to show how much of the Ship Doc needs to be filled. However, Ship Docs can be created without Sales Orders. Ship Docs are ...
How is FIFO applied in All Orders
Generally FIFO requires costs be applied in date order starting with an earliest date. For example, assume you received an 50 units of an item on Dec 20 for $3 per unit and a further 75 units on Jan 2 for $3.10 per unit . You sold 25 units on each o...
How to assign time to a work order
First, add the labor item in the components. Next, on the Step, go to the Details Column and select Assign Time. Select the Name of the Employee, enter the start and ending time or the duration in hours, then select the Labor item on the drop-down o...
Multiple-step OLE DB error when opening PO list- V 6.1.99
In order to fix the above issue, we have created a SQL script to run on the computer which has All Orders installed. 1. Extract the attached file to your desktop 2. Login to All Orders as Admin 3. In All Orders do File - Maintain 4. Click the '...
Error 2147220955: Quickbooks found an error when parsing the provided XML text stream.
Typically if you are receiving this error, there is a bad character located in one of your data fields. Please review the data and see if you are able to locate the " bad character" and remove it. If you are not, please contact customer suppo...
Cannot log into my All Orders Web or Mobile user
This commonly happens when you try to log in too many times with the wrong password and the account gets locked. In order to fix the above issue, we have created a SQL script to run on the computer which has All Orders installed. 1. Login to All...
What is a Rerecord?
The ledger data is based on all of the documents that are entered into the system. Sometimes when users go back and edit or delete documents in the past it creates discrepancies in the ledger and instead of attempting to fix them on the spot, which ...
Setting up SMTP Email with Go Daddy GoDaddy
Here are the SMTP settings to use in All Orders. In All Orders under the preference for Email: Server - smtpout.secureserver.net Username - YourEmail@YourDomain.com Password - Your Email Password Port - 465 Use SSL - Checked ...
QuickBooks Sync Error Messages
When syncing with QuickBooks you may receive the following error messages: Error recording Item - A related object is already in use, or failed to acquire the lock for this object. Error recording Item - There was an error adding, modifying or d...
CreditCard Processing- Difference between Authorize and Capture
When you are processing payment through Authorize.net gateway there are 2 buttons. 1 says AUTHORIZE and the other says CAPTURE. What is the difference in these two buttons? Answer : Authorize transactions are submitted to Authorize.Net , th...
List crashes or gives a pointer error
One of the causes of this is having a custom field for the entity that is listed that has the same name as an existing field for that entity. For example, if I created a custom field for Sales Orders named "Due Date" I will start to have this proble...
Making Locations/Bins Unavailable
If you need to make a Location/Bin unavailable this is possible. 1.Log into All Orders as the admin ( or a user with permission to change locations) 2. Go to LISTS--LOCATIONS 3. Open the Location that needs to be made Unavailable      a. If ...
SMTP Email Error Messages
When using our SMTP email, you may receive error messages. Please make sure the following steps are taken then try sending a test email again. -Make sure the settings you are entering are correct (Port, username, password, etc.) -Disable ALL fi...
Transaction must be positive when sending a bill to QB
When you use the Canadian/UK version of All Orders you may get the above error when recording a bill to QuickBooks. Try unchecking 'record adjustment as bill' in the QuickBooks Synchronization Preferences. This preference is located in All Orders. G...
Quantity Differences Between Valuation Report and Inventory Movement or Screens
The quantity reported on the Inventory Valuation, Inventory Ledger, and Transaction reports are posted transactions to the All Orders subsidiary ledger where as the quantity on the Inventory Status Details, Inventory Movement, and Items by Location ...
Run Time Error 339 - Component FM20.dll
Run Time Error 339 - Component FM20.dll Error Message Runtime Error 332 Component FM20.dll or one of its dependents is not correctly registered of a file is missing. Cause: Certain Microsoft components are not on your computer. Sol...
Setting up Part Numbers, Product Codes or SKUs for InventoryItems
Assigning part numbers to your items requires some upfront planning or you might find that your scheme runs out of room quickly. Numbering schemes are a matter of personal preference and they will differ widely from company to company. When creating...
Blanket orders and multiple ship dates
Create a sales order as usual and add items. For each item with different ship dates, click 'Details' and select 'Ship Dates'. Enter your dates and quantities in the grid provided then click 'Save & Close'. You can change the quantities at any t...
Change the date on the Count Sheet
Once the Count has been saved, the count date cannot be changed. You will have to close the count, delete it from the Count List, then open a new count with the new date.
AO-->QB sync Order
Account Class Currency Sales Tax Code PaymentMethod Term Vendor Type Employee Vendor Item Sales Tax SalesRep PriceLevel Item Customer ItemDiscount Sales Order Adjustment Receiving Customer Return Work Order Disassembly Vendor Return Shipping Value ...
Welcome
Welcome and thank you for using All Orders by NumberCruncher. This user's guide is available is printed format in summary form (i.e. a Quick Start).   To print the Quick Start guide,  go to the All Orders Windows program group and select User's M...
Foreign Addresses are incorrect after being entered correctly
There is a known issue with Quickbooks in which foreign addresses cannot be entered in the same way as standard US addresses. Due to this issue when a foreign address is entered correctly into All Orders, once it is sent to Quickbooks it will be for...
QuickBooks report that shows average costs calculations
Open the Inventory Valuation Summary in QB – find the item – double click on it This will bring you to the Inventory Valuation Detail report – click on Modify Report – click on Advanced – click on the In Use button – click Ok – change the date range...
Shiprush Error - Connecting SSL Unable To Post INTERNAL
Copy the shiprush DLL into the All Orders folder
Error- The specified user is already logged in
Log into AO as admin Go to File --> Maintain --> Clear Users Then select the user you would like to clear by checking the box next to their names Click OK. Close and reopen AllOrders Log in as Usual
Why are my Previous YTD totals incorrect?
In All Orders, our Previous YTD is based on a date range starting at the beginning of the previous year up until the current day and month of the previous year. So as an example, if today is 1/15/2019 then by default the Previous YTD would be calcul...
Can I assign one item number with multiple pricing detail?
In the menu Lists, Profile Lists, then Price Levels is where you can set additional item prices for your customers. It can be set for and individual customer, group of customers, or company-wide. Create a name of your price level, i.e. the c...
How to restrict users to a particular location
1. From the main menu select Company --> Manage Users 2. Click the user on the left. 3. Select a location using the second Pick List 4. Press Save
Hosting All Orders on a Dedicated Server
Please download/view the document below for recommendations when migrating All Orders to a hosted dedicated server. This document can also be applied to when upgrading or replacing in house servers. Microsoft Word Format http://numbercruncher...
Shipping from multiple locations Updated
At order time you may not know from which location you will ship a particular order.   To handle this scenario, when creating the sales order leave the 'Ship From Location' blank.   For this example I entered an order qua...
Importing Sales Orders from QuickBooks with Multiple Addresses
There may be instances when you need to import Sales Orders from QuickBooks and the Ship To Address is different than the Default Address. Solution: Go to File -> Import -> QuickBooks -> Sales Orders, select Addr1 in the drop down for "...
Access Violation Error when shipping from ShipRush
When processing shipments from shiprush you may receive error Access violation at address 17F9AD34 in module 'ZRush_ShipRush9.ocx.' Solution: After running the script, please log out and log back in to AO and trying shipping again.   1. Logi...
Adding Costs to a Receiving Doc
Sometimes there are additional costs that are incurred when receiving items into stock that you may want to build into the landed cost of your items. Examples of these are freight charges, customs and port fees, storage etc.. There are two ways to a...
Installing SQL Server 2012 for All Orders
Please download/view the document below for instructions on installing SQL Server 2012 for All Orders. Word Document www.numbercruncher.com/docs/Installing_SQL_Server_2012_for_All_Orders.docx PDF http://www.numbercruncher.com/docs/Ins...
Sync Error Message: Customer, Item, Vendor NOT FOUND in the list or Invalid Argument
Problem: When syncing an invoice or bill to QB you may get an error message indicating that a customer, item or vendor was not found in the list OR invalid argument. Solution: 1) As the AO administrator, go to Company -> Synchronize Qu...
Why are the quantities different in QuickBooks and NumberCruncher.
From time to time the quantity of and item shown in the 'Available' on the Inventory List in NumberCruncher may be different that the 'On Hand' column on the item list in QuickBooks. This is what we called 'timing differences' which are due to: 1....
Column Width Wont save on Lists
If you find that you are changing the widths of your Columns on any list screen, and they are not remaining how you set them, you will want to TURN OFF the " FIT TO PAGE" option. See Image below.     ...
Error:Can only add items that were ordered
When creating a ship doc or receiver you may get the message. Can only add tiems that were ordered. This is a preference that is set to prevent users from shipping or receiving more than was ordered. The admin user can change the preference to allow...
Quickbooks Sync Error : This Customer already has job information.
When trying to save a new sub customer in All Orders and have it sync over to Quickbooks you might get this error message. This indicates that at some point some job data has been entered into the top level customer. A top level customer cannot have...
Why does my inventory go to the default bin?
AO will first select the default bin of the location on the transaction. When you open the location screen, and select the Bins tab, the bin checked Default is the bin the inventory will be placed in. However, AO looks to see if the Item has an assi...
QuickBooks Online and All Orders
As of December 17, 2019, QuickBooks Online will migrate to OAuth 2.0. All Orders does not support the new QuickBooks Online authorization token. There are currently no plans to support the use of QuickBooks Online with All Orders at this time. ...
BOM Revisions
The BOM Revisions feature in All Orders allows snapshots of the BOM to be saved to the database and then late accessed. There is not limit to the number of revisions that can be generated for each assembly. Simply click the Revisions tab when editin...
How to run a script in All Orders
The admin user has the ability to run scripts from the All Orders user interface to update the database. Scripts may come in one of two forms, a file or a block of text that can be copied and pasted. Here is how to run both! -Open All Orders as th...
Error 339 ExComboBox.dll or Module Failed to Load Error
This is caused by a software component not being registered properly.  To fix the issue:  1. Find cmd.exe in the WINDOWS\system32 or syswow64 folder  2. Right Click and select Run as Administrator  3. type: regsvr32 " C:\WINDOWS\system32\ExComboB...
Email error- Property is Read-Only
When sending an email from AO and you come across the following error message: " Property is READ ONLY" This means that you are using OUTLOOK to send emails and there are some preferences in AO that need to be altered. 1. In AllOrders, g...
Error 2147024882 - Not Enough Storage is available to complete this operation
This error means your list so large your machine or sever does not have the resources to load it. One option is to change the filter to only show active ones and make any items that you are not actively selling to inactive. Another option is to c...
Handling the Costs of Goods Sold account. How certain conditions may impact behavior and WO components
From time to time you may see various small bill amounts in Cost of Goods Sold or Inventory Asset relating to an NC Internal Bill. KEEP IN MIND THAT ALL ORDERS ONLY SENDS THE COST TO QB BUT DOES NOT HANDLE IT. In addition, KEEP IN MIND that All Orde...
When opening Shiprush from All Orders for Postal Service USPS shippig the screen is wrong and missing things
This is because there are two versions of Shiprush for shipping with the Postal Service. Currently the only supported version is the Stamps.com version so follow these instructions to activate it within All Orders. -In All Orders go to the Lists men...
Quantity Ordered on a Purchase Order Rounding
When creating a new purchase order the quantity ordered is rounded to the nearest whole number. Solution: Go to the Inventory Item screen for that item -> click on the Purchasing tab, at the bottom under Preferred Vendors the Order Inc needs ...
ShipRush Error - MSFLXGRD.OCX not found
When you are in a Ship Doc and click on ShipRush -> View/Delete, then receive an error in regards to MSFLXGRD.OCX not found (line XXX) 1. Windows 7 does NOT include this OCX file, but previous versions of Windows do. 2. The OCX files needs to...
Setting up SMTP Email with Office 365
In All Orders under the preference for Email: Server -  smtp.office365.com Username -  YourEmail@YourDomain.com Password - Your Email Password Port - 25 Use SSL - Checked Under the General preferences, My Preferences tab, Email tab: Fro...
Creating a New Sales Order
To create a sales order, choose New Sales Order from the Sales  menu, or simply hit Ctrl-S . A Sales Order form will appear. First, you will need to select a Customer as well as choose the address to which the order will be sent (if the Cu...
Unknown error when sending a Europian customer to Quickbooks
This is a known issue bug with some versions of Quickbooks Canada/UK such as 2014. It is due to a new requirement in Quickbooks where customers must now have a Sales Tax Country assigned to them under the VAT settings. However, since 3rd party appli...
How To: Put multiple ship dates for line items on a Sales Order
In order to accomplish this, right on the line item on the Sales Order just right click the mouse and then select multiple ship dates, this will allow you to setup multiple ship dates for an item
Error -2147220955: The given object ID "" in the field "list id" is invalid
This error may occur when trying to update information when either saving an entity or syncing with Quickbooks. Typically this is caused by an option being selected from a drop down and assigned to an entity and the item selected from the drop down ...
Error During Handshake when processing a credit card
This error is due to the payment gateway disabling old security protocols and putting new ones in place. To update All Orders to use the updated protocols open the system as the admin. Go to the file menu, maintain, advanced tab, run db command, a...
How does NumberCruncher Handle Sub-Contractors/Processes?
NumberCruncher Work Orders can track sub-contractors/processes.  It is recommended that you use non-inventory part, service or other charge items to track sub-contractors. If you have not created the items do so as follows:  1. Create an Item (e.g...
Why are inventory quantities negative?
Causes: From time to time you may notice that your inventory quantities are negative. The following are several reasons this may occur: 1. For finished goods you produce or sell, invoicing an item with 0 quantity or before the status of awork or...
Why should we use Purchase Orders?
In business, it is good practice to put agreements in writing to avoid misunderstanding. A Purchase Order (or PO) is an agreement between you and your vendor setting forth the terms for the purchase of goods or services. Even if you verbally order p...
An internal QuickBooks error occurred while trying to access the QuickBooks datafile
Descriptions: When trying to link a QuickBooks company file to NumberCruncher for the first time you may receive the following error. Open QB: An internal QuickBooks error occurred while trying to access the QuickBooks data file. Cause 1: Y...
How to change a serial or Lot #.
You may need to change a serial or lot # due to clerical error. 1. Find the item on the Item List. 2. Click Info icon 3. Click Lot Serial # Tab. 4. If the # has no Qty remove the filter on the bottom status by click the X [Lot Qty.] <> 0 5. ...
Document are being duplicated in Quickbooks
While All Orders tries to ensure each document being posted to Quickbooks only goes over a single time there are instances where duplicates can happen. The most common one is when All Orders sends a new document to Quickbooks but never gets a valid ...
Using Batch Sizes when entering Bill of Materials
All Orders now supports Batch Sizes for easier entering of component quantities when setting up BOMs. While in most instances the quantities for components needed to build an assembly are entered based on what is required to build a single assembly,...
Exclude Checkbox in Reports Filter
First, select the filter you want to exclude, then to the far-right click Add Filter. Next, highlight your filter and check the Exclude box. If the Exclude checkbox is checked without the selected filter, it will have no effect.
Average Cost appearing in AllOrders seems too large or just wrong
Solution: The Average Cost is computed by QB and READ BY AO ...AO does not manufacture the Average Cost of this item, it is read by AO from the QB database when a sync is done. Therefore the first thing that should be done is to sync the item. *...
All Orders Web ( AOW) - Can I change the color scheme to match my companies?
To change the color scheme you must make changes to the theme which is being applied to the website. You can view the files for the theme in the App_Themes\SmokeAndGlass directory.
Setting up Auto Sync for All Orders
Here is a link to download the new utility to auto sync on the server. https://www.dropbox.com/s/6njtuv2dzu31jdz/SelectiveSync.zip?dl=1 Here are the instructions. Once you have it placed where you want it, open the config file and put in you AO...
I get duplicate serial or lot number error but I deleted the transaction that used it.
As the administrator  go to  File - Maintain - Advance  Delete unused serial or lot #s
Items not showing on PO
When you do not see all the items in the drop down list of the PO it could be 1. The Item Group from which it belongs is not marked as " Is Purchased " 2. You are using the Purchasing Preference to Limit items to those supplied by the specific v...
Extra digit in barcode (Check Sum Digit)
Problem ------------ There is an extra digit in the barcode when scanned. Solutions ----------- 1. Configure you scanner to drop the check digit. 2. Use a different barcode symbology. 3. If you cannot drop the check digit on your scanner and you a...
Updating C.R.M
To update your already existing CRM installation: Please make sure that the following steps are performed on the machine where the CRM is being hosted ( typically the server) Download the file from out FTP site: 1.From the start menu click ...
How can I see Inventory quantity or status by bin, lot or serial number
There is a report of the same name "Inventory Status Details" that shows inventory quantities by bin and lot/serial numbers.
How do you add an Item to a count
The count screen will only show items that have a count (negative or positive). However you may find an item that is not listed. To add the item select Activities drop down (near the Help button) and then Add Item.
Object "XXXXX-XXXXXXXXXX" specified in the request cannot be found
If you get this error when trying to post a payment over to Quickbooks the most likely cause is a bug in Quickbooks that occurs when the payment is trying to be applied to the invoice. The workaround is to specify which Accounts Receivable the payme...
Number of packages on ship doc equals quantity
Go into Preferences --> Shipping and UNCHECK 'Count number of packages'
The All Orders User Interface
All Orders allows you to have several lists, entry forms and editors open at the same time.  Each new window that is open creates a tab just under the main toolbar.   You can easily switch between open items by clicking its corresponding tab. ...
Error 5707 Set device name failed. Invalid printer device name.
When opening or printing a report you get a Gray Screen or: Error 5707 - Set device name failed. Invalid printer device name Cause: The last printer used by Active Reports is remembered and could have changed. Solution: 1. Login to All Or...
How to force task schedule to run an app as 32 bit INTERNAL
create a batch file in the same directory, with the following code: %systemroot%\Syswow64\cmd.exe /C "C:\Selective Synch\AOAUtoSync.exe"
Error -2147217913: The conversion of varchar data type to a datetime data type resulted in an out-of-range datetime value
Error -2147217913: The conversion of varchar data type to a datetime data type resulted in an out-pf-range datetime value If you are receiving this error it is being caused by the Regional Settings on your machine being set to something other than...
CRM- Error 500
If you are receiving ERROR 500 when attempting to access the CRM webpage just follow these steps to fix the issue 1. Go to the machine where the CRM was originally installed 2. Go to the Start menu 3. search for " services" 4. Open the S...
QuickBooks Merchant Services
QuickBooks Merchant Services has been merged and is now QuickBooks Payments. To learn more about this development head here: https://quickbooks.intuit.com/payments/faqs/qbo-account-migration/ All Orders does not support the new QuickBoo...
Quickbooks error message: This list has been modified by another user.
If you are receiving this error message Please run the following script:   1. Log into AO as admin 2. go to FILE--> MAINTAIN--> ADVANCED tab--> RUN DB COMMAND 3. Copy/Past the following script into the box ----------------------...
User is already logged in
You may receive this message when attempting to log on to All Orders. This means either the user is logged in on another machine or the user was not able to log out of the system properly. The Admin can log users out as needed by clicking on th...
Error 549: The currency of the account must be either in home currency or the transaction currency
When we send an invoice to QB, by default we do not specify the account receivable associated with it. When this happens QB tries to use the same account that was used on the most recently entered document of the same type. In this case an invoice. ...
Active X error after install
If you have installed AllOrders and you are getting an ACTIVE X error when trying to open the program, please see the below steps to resolve. Make sure that you do NOT have any anti-virus or anti-malware programs running. If you do have any of...
Error- Violation of UNIQUE KEY -- AK_OpenDocs
If you are receiving this error in V 6.2.23 please run the following script 1. log into AO as admin 2. go to FILE--> MAINTAIN--> ADVANCED tab--> RUN DB COMMAND 3. Past this script in the box and click RUN -----------------------------...
Reorder Points being deleted or overwritten
This is a known issue that occurs due to Quickbooks adding a new Max Quantity field to the items and filling in a value of 0 instead of leaving it blank. To fix this issue all the max quantities for items in Quickbooks must be reset to be blank inst...
Approved Label Printers
All Orders is compatible with any desktop laser printer that prints labels horizontally on an 8 1/2 x 11 sheet and label printers that print and feed labels horizontally. * All Orders is not compatible with label printers that print and feed label...
Maximum # of licensed users are already logged in
This message will appear if the maximum number of users in the licensing are currently logged in. To manually log users out open All Orders and click Cancel on the log in screen. Go to the File menu, Maintain, Clear Users and check mark users a...
SQL Server 2016
While the typical SQL Server installation for All Orders uses SQL Server 2012, All Orders does support SQL Server 2016 as well. Advanced users can download SQL Server 2016 from the link below and follow the same basic guidelines included in the SQL ...
The "Begin Session" method has not been called or did not succeed. Item: Save
Typically this message refers to the fact that AllOrders is not able to connect to QB. If you have QB closed, please open QB and try to save again. If QB is currently open and you are still getting this error, please reboot your machine. If you st...
How to use the work order list filter
The work order list filter is a multi-select. By default Waiting, Ready, In Production and Finished are selected. To change the filter you need to scroll through the selections and click it so that it turns to the highlight color to include or until...
error 1327- invalid drive ( when installing)
Issue: When you start to install, you get error 1327, which references an invalid drive number. Causes: The System Registry may be erroneously pointing to a temp drive. Solution: Back up your Registry. Select Start> Run> and ...
User Authentication Error when processing a credit card
This error means some of the gateway connection information has changed and needs to be updated. To do this log into All Orders and go to the Lists menu, then Profile Lists and select Payment Gateways. Now find the gateway you are trying to use and ...
Access Denied - APPLIES TO WINDOWS 7 MACHINES OPERATING AS THE SERVER
Problem: When creating or updating an All Orders database file and you have a Windows 7 machine acting as the server (where SQL Server is installed) you receive Error - Access Denied Solution: Go to the Windows Start Menu -> Control Panel -&g...
All Orders Mobile does not scan my barcodes properly
  The first thing to test when barcodes are not scanning properly into All Orders Mobile is whether or not the scanner has been configured to properly scan and add a terminating character, in this case a carriage return character. To tun a...
How do I remove HQ locaton
You cannot delete HQ but you can rename it.
Inventory Valuation
There are in fact three ways of calculating inventory valuation in All Orders:  1) Purchase Cost * Quantity This basically calculates the cost as entered or last vendor cost times the Quantity On Hand (see the faq about understanding Quanti...
Vendor consignment inventory
This article describes how to management vendor consignment inventory through All Orders. --------alternative 1------ 1. Create a new location. 2. Receive the inventory into the new location through a receiving document and CHECK NC Only to prevent ...
How do you show a column on a list
1. Open the List  2. Right click the first row  3. Click - Select Columns  4. Check the desired columns  5. Click OK
How to clear all transaction in the database
As administrator Click on File -> Maintain -> Advanced Clear Transactions
Control number of labels - Advanced.
Recently we have been asked if you can control the number of labels that print. Currently in the Label Setup (double-click on the label's name), you have Repeat Labels = false which prints only one and Repeat Labels = true which prints, say the quan...
SummaryGroup 'XXXX' doesn't exist.Please check Control 'XXXX'
This error is caused by a data control on a report having an incorrect group assigned to it. Follow these steps to fix the issue: -Open up All Orders -From the Reports menu select Design Reports -Find the report in the list of reports and then hig...
How does a Payment panel show up in a Sales Order or Ship Doc?
Basically you must first check your QB preferences to make sure that the Integrated Applications, under All Orders and under Properties, have the allow personal information checkbox checked.  In all orders, select a TERM or create a new TERM and as...
What is a Bill of Materials?
A bill of materials (BOM) is like a recipe. It provides the components and quantities necessary to make 1 unit of a finished product. It serves 2 purposes; manufacturing and accounting. On the manufacturing end, the BOM may include special instructi...
Error 526- One or more lines does not have an item
If you are receiving this error message go to Company--> preferences--> SalesOrders-->Advanced tab--> Make sure that the preference " use individual line discounts to totalthe order level discounts" is UNCHECKED
The Transaction Log for Database 'DB name here' is FULL due to 'NOTHING'
If you are receiving this error message: 1. Log into SQL 2. Take a backup of the database 3. Detatch the Database 4.Locate the .LDF file 5. Delete the .LDF file 6. Reattach the Database ( should automatically create a new .LDF file 7. Log into All...
I don't want All Orders auto-fill a sales order
If you want to enter quantities and/or serial #s manually then go into Company Preferences - Shipping and UNCHECK 'Auto-fill open quantity' When the ship doc appears and the item is serialized, click into the quantity box to show the serial # edit...
Linking QuickBooks custom fields to All Orders
  You need to create the custom field in QB first before it can be mapped. 1. Select Company - Custom Fields 2. From the drop down select Items, Customers of Vendors 3. Check Map to QB Custom field, after a moment a drop down list will appea...
Printing blank or extra page
To remove a blank page, open the report in Design View. You may notice a red line on the right side of the page. Drag the right margin of the page to the left until the red line disappears. You may need to first move the content that exceeds the mar...
Report does not show all data
If you are running the report from Design Report then by default it will only show the first 20 records so as to improve performance as you edit the report. On the bottom of the Modify Design tab, you can UNCHECK Design Mode to view all records. ...
Importing units of measure
The iteminventory.xls does not have unit of measure import rather the unit of measures and the associated conversion rates are inherited from the Item Group. You can make as many item groups as you wish and apply the Item Group in the import templ...
How do add class per item on an invoice
Invoice derive their classes from All Orders ship docs. By default the ship doc has one class for all the items. However you can enable a class per line by setting the appropriate preference.  1. Close the ship doc  2. Select Company --> prefere...
How to sync manufacturing part #.
Do as follows: 1. From the menu select Company - Preferences 2. Click Company Preferences tab 3. Click QuickBooks Synchronization on the Left. 4. CHECK "Sync manufacturers part no#. 5. Click OK to save your changes and close the preferences window...
Importing shipping addresses from Excel
To import shipping addresses use the Addresses.xls template contained in the folder \Program Files\NumberCruncher\All Orders\Import
"Error 549 unable to return object".
  This is actually an error being caused by a problem in QB. The way that we work with QB is that we send a request over to QB and QB processes that request and sends us a response that the request has been processed which in turn allows us to clo...
Shipping complete
Shipping complete means that an entire order must be shipped at the same time and on the same ship doc in other words the order does not allow back orders.    In order make a sales order ship complete UNCHECK the 'Allow back orders' box below the Or...
This application is not allowed to log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for automatic login through the Integrated Application preferences.
When attempting to sync or record a transaction into QuickBooks you may receive the following error: This application is not allowed to log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for...
Installing AOWeb All Orders Web on 64 bit server with SBS Sharepoint Exchange
Here were the issues and how it was resolved. It was due to it being installed on a 64 bit server which had exchange/sharepoint 2011 installed. 1-The web.config was missing much info. Make sure all relevant AO Web assemblies are listed in the add...
ShipRush UPS Account Registration Failed
When setting up ShipRush UPS you receive the following error: Unable to activate account. (PLDAccountProcessor.Init) Unable to init UPS Communication API: (Initializing COM interface) OLE error 80049D6D (PLDAccountProcessor.Init) unable to i...
There was an error when composing an address in "". QuickBooks error message: There is not enough address lines to compose the address. Please rearrange the individual fields, so that they can fit in the 5-lines block.
While Quickbooks has many fields for the address you cannnot use them all. Between all of the fields you use on the address it can only span 5 lines. Here is where the lines would potentially go: Address1 Address2 Address3 Address4 ...
Backing up your All Orders database
All Orders uses a SQL Server database to store all of your company’s data. Backing up the database properly is critical to recover your data in the case of a disaster. It is the only file that must be backed up as all company data for All Orders is ...
Setting up All Order to export reports to All Orders Web
In order for All Orders Web to be able to run forms/reports from the main All Orders system they must first be exported to the docs\templates folder that is inside the All Order Web folder. Once a report is exported it should not have to be done aga...
Working with styles
A style is a grouping of items that have virtually the same characteristics but differ by their attributes.   For example a shirt can come in different sizes and colors.  Before you can styles to transactions you must create the attributes...
Error 5000 when running Customer or Leads Report in 6.1.92 or higher
Error 5000 : Error in processing report. [ Extended Info:Invalid column name 'OnHold'.] Resolution: In order to fix the above issue, we have created a SQL script to run on the computer which has All Orders installed. 1. Extract the attach...
Sales Orders With Multiple Ship To Addresses
Certain of your customers will want you to ship orders to different ship to addresses for example a retailer.   One solution is to create multiple sales orders however All Orders has the ability of handling multiple ship to addresses on a singl...
Understanding Back Orders
The term 'back order' has different meanings to different people.  When people where using paper for order entry and the order could not ship complete, a new order called a Back Order would be created with the remaining items and quanti...
winmail.dat email attachments
Content below if from: http://email.about.com/od/outlooktips/qt/Prevent_Winmail_dat_Attachments_from_Being_Sent_in_Outlook.htm ------------------------------------------------------------------------------------------------- "Do recipients of...
"QuickBooks Dividing Date" ERROR
PROBLEM: "You may not create or edit a transaction dated on or before the dividing date." SOLUTION: The dividing date is the date you gave a copy of your QuickBooks to your accountant. No invoices or estimates dated earlier than the dividing dat...
Converting All Orders from V3 to V6
This guide consist of three parts I. Conversion Procedure, II Conversion Tips (preconversion considerations) and III. Conversion Expectations Guidelines (what to expect after converting) I. CONVERSION PROCEDURE Open All Orders 6, do File -> ...
The file is not attached to the server--or-- Database Failed to Restore
If All Orders is unable to connect to the database you might get one of the messages: The file is not attached to the server Database failed to restore There are many things that may cause this to happen: -The database server might be tu...
Database Failed To Backup After Update
All Orders has a built in function to backup your database every time an upgrade to the software is done. In the event that any issue arises with the new version of the software this will ensure an up to date backup is ready to be restored if needed...
Hot Keys & Shortcuts
The user interface includes various key press combinations that can be used to quickly and easily complete various tasks without having to use the mouse. They include: Ctrl+Z - Undo Ctrl+X - Cut Ctrl+I - New Item Ctrl+S - New...
Using Entry Forms & Editors
Entry forms and editors are where you add or modify information in All Orders.   For example, the entry forms for a Sales Order or an Item’s Editor.     The fields (i.e. boxes) in yellow are required and cannot be left blank.  For example, when crea...
How To Move Your Database From One Server To Another
This is an advanced topic please consult an IT specialist or NumberCruncher if you are unfamiliar with any of the steps below. Please note that after performing the move you will need to reenter your license keys in All Orders. 1) On the ser...
Using the Lists
The lists in All Orders are the jumping point to all the records in All Orders.  For example, if you are looking for customer you would start off with the customer list.  The icons on the Home screen or toolbar that have a small check box are lists....
There has been an internal error when processing this request when syncing or sending a transaction to Quickbooks
If the Quickbooks data file being used once had the Advanced Inventory feature turned on but has since been turned off you might get this error due to a bug in Quickbooks. To resolve this, please first make sure you are running version 6.1.66 or lat...
Main Menu and Toolbar
The main menu and toolbar can also be used to navigate to various functions in All Orders. For example, the File menu contains data related functions like backups and importing and the List menu contains all lists. You can modify the icons that ap...
Tips for speeding up All Orders
All Order is built with a SQL Server back end which lends itself to high scalability and availability. There are times, however, when the user interface may slow down due to large lists. The lists that tend to grow the largest and cause spee...
Synchronization options
Synchronization preferences are discussed in greater detail in the Reference --> Preferences --> QuickBooks Synchronization Preferences.   In this section I want to focus on the ‘Send All’ preference (Send all unsent transactions / payments [t...
Ongoing Synchronization
You can add or change a list record (customer, item or vendor) either within All Orders or within QuickBooks and they will be synchronized.   If the record changes in All Orders, then the change in QuickBooks will generally occur in real-time.   If ...
Initial Synchronization
During the creation of the company file  an initial synchronization occurred.   During this initial synchronization all the active items, customers, vendors, price levels as well as what All Orders calls profile lists (accounts, types, terms, ship...
How do I change the default printer for All Orders
  All Orders has two main options for which printers, and their associated page setups, are applied to forms/reports/labels. It is important to choose the correct one in cases where you might be printing different reports to different prin...
Adjusting Preferences
A critical part of the All Orders setup process lies in adjusting its many preferences to suit the needs of your business. You can access the Preferences dialog by choosing Preferences from the Company menu:     As you've probably noti...
Designing and Using All Orders Report
Designing Templates, Reports and Labels All Orders is packaged with many templates, reports and labels.   You use the report designer (shown below) to customize your templates and reports to suit your needs.   The report designer is fully integrat...
Setting up Custom Fields
If you find that you need to set up information for one of your lists where there is no corresponding field, you assign a custom field to fill that role. For example, if you're in the habit of sending your customers a greeting card every year on the...
Managing Users
The Manage Users command, available from the Company menu, allows you to set access levels for every individual in your organization who will be accessing the All Orders system, including sales, administration, production teams, etc. This must b...
Sharing All Orders data with business intelligence and analytics systems
While All Orders allows for custom building and designing reports there may be certain reporting needs that the built in reporting engine is simply not designed to handle. This includes: -Graphical charts and trends -Pivoting data -Sub repo...
How to install an All Orders patch
If you are provided with a patch for your All Orders system you can follow the steps below to patch up any workstations using All Orders. If the patch does not change the version of All Orders it will only need to be installed on any workstation whe...
Creating a Company File
Before creating a company file it is suggested that you read the section on preparing your information .   You must have already installed the server and at least one client computer. In order to manage your products, customers and vendors as w...
Installation
Before installing the software please review our system requirements .   All Orders is comprised of 2 parts; the 'server' and the 'client' software.  The server software is contained in a file called SQLExp2005Installer.exe and the client softw...
Preparing your information
Before you start working with any new system you want to ensure that your data is as clean as possible.  The data you will need to operate All Orders is as follows.   Users: your users that will log into All Orders Item list:  A listing ...
Planning
Any new system that you implement in your business will mean a change from how you do things today.   It is human nature to resist change because of the uncertainty of what the change will mean.   NumberCruncher is absolutely certain that through pr...
All Orders Inventory Valuation and Ledger ( Rerecord )
As you know QuickBooks valuation method is the weighted average cost (Average Cost). For most businesses that do not experience wide fluctuations in purchase cost or have now 'specific identification' requirements (more on that below), the Average C...
Error Message - "Cannot Start QuickBooks"
This error message indicates that All Orders is having trouble connecting to Quickbooks to transfer data back and forth. Here are some steps you can take to try and resolve the issue. -Make sure you have Quickbooks running with the correct comp...
Using FedEx Ship Manager with All Orders
Using FedEx Ship Manager with All Orders On the machine having your FedEx Ship Manager please perform the following steps. STEP 1 - CREATE ODBC SOURCE Click the Start Menu. Click Settings/Control Panel. Double click ODBC data sources i...
Errors using Excel / Office 2010 and higher or sending email from Outlook 2010 and higher
Microsoft has made many changes to Office 2010 and higher. There are two things you need to check for to ensure that All Orders can communicate with any Office 2010 or higher application including Outlook and Excel: 1-Microsoft no longer allows 3...
Sync errors W/ QuickBooks Online ( QBO)
If you are having trouble with your QB Online sync tool and you are getting an error, Please follow the below steps to send the errors into support for troubleshooting. Perform all steps on the machine where the sync tool is installed! Step 1:...
All Orders Capacity Planning
All Orders offer capacity planning where users can setup steps/process that take place during production, assign budgeted time for those steps/processes on BOMs and Work Orders, groups the different steps/processes into Production Centers with allot...
How to Track production processes/steps that are done by 3rd Party Vendors
When setting up your Bill of Materials for your assemblies you might be trying to figure out how to keep track of processes in production that are done by 3rd party vendors where the inventory is sent to their location and then sent back to you when...
UPS WorldShip - Integrating with AllOrders
On the machine having your UPS World Ship please perform the following steps. STEP 1 - CREATE ODBC SOURCE Click the Start Menu-->Click Settings/Control Panel-->Double click ODBC data sources icon (found under Administrative ...
Cannot edit the quantity directly because a sub form has more than one entry
When changing the quantity on a ship doc you may receive the error.  "Cannot edit the quantity directly because a sub form has more than one entry" This message means that you have lot or serial # or multiple bins allocated thru the bin or ser...
Importing Data from Excel
If your file is linked to QuickBooks then existing items, vendors and customers will already have been imported.   If you are converting from another systems or you want to import orders from a web site then you can use our Excel import fe...
Moving REPORTS from one database to another within same sql instance
Please find attach a zip file with a utility that will allow you to move reports from one database to another database within the same sql server instance, in this case presumably 'allorders'. Included in the zip are: 1) the utility itself 2...
Creating a New Sales Quote
If a Customer requests a price quote for Items they wish to order, you can provide a detailed statement in the form of a New Quote , which can be accessed from the Sales menu. Aesthetically, the Sales Quote is nearly identical to the Sales Orde...
When I press Fill on the sales order, my quantity (on the ship doc) increased when I scan my items. How can I fix this?
First, go to the menu Company, Preferences, Shipping, and uncheck "Auto fill on shipping". Also, check "Deny shipping quantities greater than ordered." Now when you press Fill on the Sales Order screen, the quantity filled will be 0. When you scan t...
How to prevent freight from being taxed
Your Shipping Method is attached to an Other Charge item that is marked as taxable. Take the following steps: -Go to the menu Lists, Profile Lists, and Shipping Methods -Select UPS and see the Other Charge item it refers to -Open the Item List and...
How to perform a Location Transfer
  This feature is used when a business operates from multiple locations. From time to time your company may need to transfer Inventory to and from locations. This is sort of like a Shipping doc only you are the sender and the recipient. To C...
Sync Queue
Lists (i.e. customer) or transactions (i.e. ship doc) when add or changed in All Orders will update QuickBooks in real-time or be added to Sync Queue.   The Sync Queue is a temporary holding place for pending updated to QuickBooks.    A record will ...
Typical Sales Cycle Work Flow
The purpose of this topic is to describe in general terms the sales cycle within All Orders.    There are many variations on this work flow which will be discussed in other topics. In All Orders the 'trigger' for a sale is a ...
How BOMs and Work Orders work with Subcontractors
Here is an example of how BOMs and Work Orders work with Subcontractors: Question: We bring certain components in as bare steel components. They are for example in our inventory as part # 1000. We then send these components out to another supplier...
A QuickBooks company data file is already open and is different then the one requested
Description: When attempting to communicate with QuickBooks (e.g. when syncing), you may get the following error message: A QuickBooks company data file is already open and is different then the one requested or a Begin End Session error Ca...
Adding to dependencies to existing orders.
    When the reorder analysis screen open check the 'add to existing orders' box on the top left corner.   ...
Class Not Registered or ActiveX Component Could not Create Object when trying to open All Orders
Symptom Error message immediately when trying to open All Orders or open an NCD file. Reason MSXML 4 may not be properly installed. Resolution Download and install the following software: https://www.microsoft.com/en-us/downlo...
Error- You have no items. Or one or more of your amounts is not associated with an item. Please enter an item.
If you are receiving the above error, please check the following 1. Please see attachment ( step 1) . DO you have this preference turned on? If yes, please turn it off. 2.Please check that all your ship methods have an "other charge" ite...
Drop Shipping
Drop shipping a sales order is when a vendor ships the product to your customer on your behalf.   The vendor will then notify you by sending you an invoice as to which products have been shipped.   In All Orders you can create a drop shi...
Token List for Custom Messages
[ACCOUNTNUMBER] [BALANCE] [BILLADDR1] [BILLADDR2] [BILLADDR3] [BILLADDR4] [BILLCITY] [BILLEMAIL] [BILLFAX] [BILLPHONE] [BILLSTATE] [BILLZIP] [BITEMCUSTXX] [CONTACT] [CURRENCYCODE] [CUSTOMER] [CUSTOMERPO] [DOCNO] [INVOICENO] [ITEM] [ITEMDESC] [ITEMPR...
Shipping Multiple Sales Orders
Creating a ship doc for one sales order at a time may suit your needs but if you want to process multiple sales orders at one time then you should use the batch shipping functionality in All Orders.  With batch shipping you can take all open sa...
This feature is not enabled in this version of QuickBooks
This issue can occur if there is a feature being used in All Orders that would typically sync with Quickbooks but the feature is not enabled in Quickbooks. Typically with items the class syncing causes this error to appear. Sometimes the error...
Please wait while Windows configures ...
When opening All Orders a Windows installation repair window runs every time which says "Please wait while Windows configures...". This is generally an indication that of a file from the installation is missing. For more details go to: -Start Men...
Price Levels
Introduction Types of price levels How All Orders applies price levels Working with price levels fields   The Price Levels profile list helps you set up and track discounts (reductions) and markups (increases) of your reg...
Generating Vendor RFQs
Many businesses order from vendors on a quote by quote or sales order by sales order basis. All Orders make this easy by allowing you to create linked purchase orders directly from a sales order.   In cases where you have multiple vendors where...
Orders with kits or configurations
Adding to quotes and orders All Orders allows you to offer your customers selections and options when ordering kit items or configurable bill of materials. Once you have created them you can add them to a quote or sales order using the drop down of...
AO Web - Fix Date On Reports
To change the Date in your AO Web report, take the following steps: In AO: 1. Open the report 2. Click on the Date field in the Modify Design screen 3. Select the Property List icon 4. Click on the Output Format field 5. Click on the little box wit...
Synching an Assembly (BoM) between AO and QB
When you originally create an assembly item in AO, it is set up as an Assembly item group showing the bill of materials. However when it syncs to QB, you only see it listed as an Inventory Part. The components are not listed. When you create the a...
Using Drop-down lists Updated
On most entry forms and editors you use a drop-down list is used to make selection.   For example, on a sales order you select a customer, ship to address and ship from location with a drop-down list.    You can click the arr...
Importing orders from QuickBooks
All Orders was designed so that quotes, sales orders and purchase orders originate and are processed through All Orders and by default these are not imported from QuickBooks during synchronization.   All Orders offers an import feature to ...
ShipRush crashes All Orders.
  When ShipRush is installed, All Orders will spontaneously close. To fix the issue download the attached file listed below. The name of the file is ShipRush.reg. Once downloaded, double click it and allow it to import into the system registr...
Processing Customer Returns Updated
Whether due to error or a change of heart, your customers will occasionally return items. Customer Returns are transactions that show what Items are shipped by Customers back to you. You will notice that the Customer Return form is nearly identical...