• What is the difference between 'Do Not Match' vs 'Soft Override' matching in PO Receiving?

    In Purchase Order > Maintenance > PO Setup > Set Up PO Options > Others > Matching > Match Invoice to PO

    Match Invoices To PO

    • Select this check box to allow invoices to be matched to purchase order according to the tolerance codes established in 'Set Up Tolerance Codes'.  Selecting this check box enables the PO Default and Line Item Default files.  Clear this check box if you do not want to match…
  • How to configure Business Insights Dashboard for Internet Explorer 11 and above, including Microsoft Edge

    Configuring Business Insights Dashboard in Internet Explorer 11 or above

    1. Open Internet Explorer.
    2. Click the Settings button on the top-right corner.
    3. Select the Compatibility View Settings option.
    4. Add the Business Insights Dashboard link:

    Example: http://localhost/BusinessInsightsDashboard/ 

    1. Then, refresh Internet Explorer and Go to the above link.

    1. Also, you can add this link to the following: Select the Internet…
  • How to setup Sage 500 to track the new Colorado Retail Delivery Fee

    Beginning July 1st, 2022 Colorado will impose a $0.27 retail delivery fee on all deliveries by motor vehicle to a location in Colorado. The fee is per order and applies if there is any taxable item in the order.  Wholesale or other exempt sales are not subject to this fee.

    The fee is displayed on the sales invoice. It is charged to the customer by the retailer and that retailer is liable to collect the fee and remit the…

  • Sage Intelligence Task Pane is missing or Error: "Microsoft Excel cannot access the file 'c:\Program Files (x86)\Common Files\BIExcelFunctions1.1\64bit\Sage.BI.ExcelFunctions1.1.xll'

    The most common issue with Sage Intelligence, is when you run a Report Designer Add-In Report, you get '#NAME?' on all of the cell values in the Report.  This is caused by the Task Pane being missing.

    Remember, all the cell values on the report are all formulas.  Without the Task Pane, Sage Intelligence is no way to interpret the results of those formulas.

    Below is our Support document on how we troubleshoot Task…

  • How Credit Card Vendor works in Accounts Payable in Sage 500

    In Accounts Payable, Maintenance, Maintain Vendor, Users have to create a Vendor that will be used as a Credit Card Vendor, for example (VISA, Mastercard, Amex, Discovery, etc.)

    Under the Main tab, enable the 'Credit Card Vendor' box as seen below.

    This feature was added in a later version of 2018.  This feature where Users able to create a Vendor and treat it as a Credit Card Vendor.  This means that when you…

  • Inventory Calendar for year 2022

    The new year 2022 is coming and that also means that you need to have year 2022 created in your Sage 500 inventory calendar. The Inventory Calendar must be set up before posting transactions to the year 2022.  Since there is no direct task on the Sage 500 desktop the Inventory Calendar may be hard to find.  

    The inventory calendar starts on 01/01 and ends on 12/31; however, you can break this down over multiple periods and…

  • Cash Management and Bank Reconciliation Hints and Tips

    • The ‘Book Balance’ is the balance in Cash Management Module. It is not the General Ledger balance in General Ledger.
    • The Bank Balance (Book Balance) calculated in Reconcile Bank Accounts is the sum of any beginning balance entry made in Cash Management (CM), plus the outstanding transactions sourced from Accounts Payable (AP) checks, Accounts Receivable (AR) deposits, and CM transactions, including adjustments…
  • About bins in Sage 500

    Bins are built into Sage 500 activities to manage stock movement and inventory transactions.

    • Specify volume, weight, and count cycle for bins.
    • Define preferred bins for specific items.
    • Use fixed bins for items that may be stocked in various bin locations within the warehouse.
    • Use random bins for items that may be stocked in various bin locations within the warehouse.
    • Staging bins can be used to temporarily hold items…
  • Set Up IM Options

    Set Up IM Options sets defaults that are used throughout Inventory Management and other modules, and activates / deactivates features and processing options available on the system. These options are designed to allow the users to tailor the Sage 500 ERP Inventory Management module to the specific needs of their business.  

    Here is a graphic representation for some of the setting that will help you understand better how…

  • Negative On Hand Quantity

    Allow negative quantity on hand option determines if the system allows the user to ship, issue, transfer or consume more than the quantity they have on hand. Theoretically, a stocked inventory item should never have a negative balance, but negative on-hand balances have their place in the real world. Suppose a product runs out and customers are constantly calling to see if a shipment of the item has arrived. As soon as…

  • Available Inventory Quantities in Sage 500 ERP

    Sage 500 ERP product has summarized quantities in various screens to assist the user in making business decisions relating to inventory availability.  You probably noticed that often in various Sage 500 forms/windows (usually accessed thru one of IM context menus) quantity on hand and quantity available are different. Quantity on hand is a quantity of a finished good or raw material item that is physically present in the…

  • Light vs. Advanced Manufacturing

    Light Manufacturing provides an easy-to-use Production Entry screen where finished goods are reported after the fact. This single point of entry eliminates dozens of potential labor and production transactions by automatically issuing material quantities, outside process transactions and labor time to finished goods. There are no Work Orders with Light Manufacturing. Use the backflush feature to automatically issue labor…

  • Bill of Material Glossary

    The manufacturing software industry has many industry-specific terms. We've compiled a short list of key manufacturing terms used with Bill of Materials in Manufacturing module. Here it is:

    Backflush – The deduction from inventory records of the component parts used in an assembly or subassembly by exploding the bill of materials by the production count of assemblies produced.

    Bill of material (BOM) – …

  • Import file formatting

    Often you need to import Sage 500 data using built in Import utility in multiple modules (GL, AP, AR, IM).  The data is imported as ASCII records in flat files using either fixed length or record delimited (using a specified character) source records. By convention, files containing fixed length records have the extension ".asc," while the files containing delimited records have the extension ".del." .…

  • Purchases Clearing Report

    Purchases Clearing Report can be used to simplify month-end reconciliation of the purchases clearing account balance with open amounts on purchase order. The purchases clearing account is a liability holding account that contains inventory received in Receipt of Goods Entry without full invoicing until all invoices are posted in Process Receipt of Invoice (partial receiving and invoicing in Sage 500 is allowed). This account…

  • Outside Processing in Sage 500

    An outside process is an external process or service that is performed by a vendor outside your company.  Outside processing involves sending raw materials or manufactured goods to a vendor outside the company for processing. For example, if you manufacture items which have chromed parts on them — but your company does not have a metal chroming facility — then you would need to send the raw metal part to an outside vendor…

  • Cost Tier Adjustment

    Adjustments to inventory value are made using Process Cost Tier Adjustments task. Here are some important  things to know about cost adjustments :

    • Inventory Quantity cannot be adjusted through Cost Tier Adjustments. Quantities in the cost tiers are not adjusted through this program, but rather, would be corrected or adjusted through the inventory transactions program.  
    • Cost adjustments will create general ledger transactions…
  • How is cost calculated when processing Physical Counts?

    We are at the end of the year and many of you are preparing or already processing physical counts. If you are familiar with this process in Sage 500 you have already noticed that unit cost field is not available in any of the forms in this task. This is because the unit cost is calculated based on the item’s valuation method and a setting in Set Up IM Options form. So here is the logic:

    For all valuation methods…

  • 1099 for year 2020 reminders

    When will the 1099 update for tax year 2020 be available?

    1099 updates are independent of Sage 500 product updates. The official release date is by the end of the calendar year. However, we normally release the second or third week of December as we make a serious attempt to get it out as early as possible. The tax year 2020 will bring a new 1099 form, the 1099 NEC (Non-Employee Compensation). With it, will bring some…

  • Sage 500 and impact of deprecation of TLS 1.0 and 1.1

    Transport Layer Security (TLS) is an encryption protocol intended to keep data secure when being transferred over a network. Microsoft has been announcing  the deprecation of TLS 1.0 and 1.1 for the Office 365 service for more then two years and finally enforced it starting October 15, 2020. 

    The Office client can use TLS 1.2 if the web service of the local computer can use TLS 1.2. Here is how Microsoft is addressing this…

  • Drop Ship Returns

    How  do you handle returns when you're drop-shipping and the goods were sent directly to the customer from the supplier?

    Drop-ship returns are processed as customer returns. In Set Up SO Options, you can also select if drop-ship items can be returned through the Customer Returns process.

    Select this check box to allow customers to return drop ship items that are linked to sales orders. Clear this check box if you do…

  • How to add a default value to an Existing Control using Customizer

    If you need to add a default value to an existing control you can use Sage 500 Customizer. In this example using Customizer  script the default credit limit in Maintain Vendors form is loaded by tabbing to the control containing the default value.

    1. Launch AP/Maintenance/Maintain Vendors
    2. Click on the ‘Customizer’ (Alt + F3) to open the ‘Customization’ screen
    3. Click on the ‘Credit Limit’ text field…
  • Using Data Import Manager with SQL source connection

    Remember that you can use Data Import Manager to import data from any SQL Server data source. In this example I am using an SQL view (vdvBudgetAnalysis_COA) to import budgets from company COA to company SOA. Make sure that in your case it’s possible to map GL accounts between two companies either by column mapping, concatenation, partial column map, etc.

    First I will create a view for the budget that already exist…

  • So how do I update Bill of Material?

    There are two tasks used to regenerate and replace bill of material items for the selected routings. These tasks are located on the Activities > Bill of Material menu.

    BOM Regeneration

    Use BOM Regeneration to regenerate the bill of material standard cost for the selected routings. Use this task when a large number of routings and versions are updated, material standard costs have changed, or work center labor and…

  • Bill of Material

    What is Bill of Material?

    The bill of material summarizes the relationships between the different items used in the manufacturing of the finished good defined in the routing. It contains the cost rollup information, including the materials, outside processing, and fixed and variable manufacturing cost. The bill consists of a parent item and component items that make up the parent.  If the Standard Routing check box is selected…