Updated Articles

  1. 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 ...
  2. 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.
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...