New Articles

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