Knowledge Base

Learn how to pay for maintenance, purchase additional services, and input your new All Orders license key on NumberCruncher.com

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. ...

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...

"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...

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...

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...

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...

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 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...

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...

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

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

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...

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

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

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

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...

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.

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.

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 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...

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...

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...

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 "Ship To" ...

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 ...

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...

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 ...

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...

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...

"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...

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...

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.

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...

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...

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...

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...

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...

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 ...

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 ...

Using the TAB key

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 ...

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...

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...

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...

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...

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...

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 tab--> FEA...

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...

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...

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.

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"....

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...

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 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 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...

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...

How to clear all transaction in the database

As administrator Click on File -> Maintain -> Advanced Clear Transactions

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...

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...

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 ...

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...

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...

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 ...

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...

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...

AOMobile Settings

Preferences for All Orders Mobile Scanner Auto Fill for Pick Screen: indicates what to auto fill in the text box on the pick screen. 0 indicates auto fill is OFF. 1 indicates auto fill is UPC. 2 indicates auto fill is MANUFACTURE PART N...

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...

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...

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...

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...

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...

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 ...

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...

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 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...

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...

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 ...

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...

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...

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...

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...

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

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 ...

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. ...

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...

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...

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 ...

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 ...

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...

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...

"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...

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...

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...

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...

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...

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...

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 ...

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 ...

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...

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. *...

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 ...

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...

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...

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 Tool i...

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...

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...

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...

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. ...

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 ...

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...

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...

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...

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. ...

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 ...

Importing shipping addresses from Excel

To import shipping addresses use the Addresses.xls template contained in the folder \Program Files\NumberCruncher\All Orders\Import

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...

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...

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 --> preference...

How do I remove HQ locaton

You cannot delete HQ but you can rename it.

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 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...

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...

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

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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.

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.

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 time ...

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 to ...

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...

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...

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

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...

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.

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 be...

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 -> Adm...

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...

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...

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...

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 Orders instal...

Shiprush Error - Connecting SSL Unable To Post INTERNAL

Copy the shiprush DLL into the All Orders folder

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...

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...

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 -> Ope...

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...

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....

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 selective sy...

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 ...

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 ...

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...

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. Go to Re...

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...

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...

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 ...

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 the ...

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...

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...

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...

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...

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...

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....

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...

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...

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 ...

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...

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

Number of packages on ship doc equals quantity

Go into Preferences --> Shipping and UNCHECK 'Count number of packages'

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...

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. ...

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...

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...

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....

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.

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. You sho...

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 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...

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...

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...

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,...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 Tools. Sw...

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 ...

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...

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 ...

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...

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...

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...

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...

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...

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...

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 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 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 then t...

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...

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 '...

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...

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...

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...

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...

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...

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,...

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...

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...

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...

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. ...

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...

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 select to C...

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...

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...

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...

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...

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...

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...

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 Quick...

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...

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 ...

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...

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 ...

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...

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 [that ar...

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...

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...

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 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...

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...

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...

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 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...

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 --------------------------------------...

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 -------------------------------...

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...

Sync errors W/ QuickBooks Online ( QBO)

MAINTAIN-->ADVANCED-->RUN DB COMMAND Copy and Paste the below command into the box and click Run. ( this script will allow the error messages to populate in the folder that you just created.) --------------------------------------------------------...

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...

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...

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 you ...

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...

Shipping from multiple locations

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 quantity of 7 on sales ord...

Creating Ship Docs

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 easil...

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 Custome...

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) A vide...

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...

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....

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 ...

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 ...

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...

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 attached file ...

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 ship purchase...

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 transaction that re...

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 sales o...

Sales orders with multiple shipping dates

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 multiple ship dates ...

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 registry. On...

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 'Adva...

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 import Est...

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/Installing_...

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. Yo...

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 sho...

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 integrate...

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_Outside_Th...

Invalid object name deleted

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. Press th...

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" item associat...

Setting up SMTP Email with Office 365

SMTP settings to use in All Orders 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 Pr...

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...

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 regular ...

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 and style...

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 quantities therein ...

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...

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 document called a 'Ship...

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 ...

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. Attachment: https:/...

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 Preferences. Create an ord...

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 single ord...

Processing Customer Returns

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...

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 ...

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 created. The n...

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 noticed...

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 well a...

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...

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 feature. Al...

Using Drop-down lists

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 arrow and ‘drop-down’ t...

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 Cause T...

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 ...

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. 2...

Articles