• Has anyone used an external requisition software?

    Has anyone used a software package that integrated with Sage 500 ERP for creating Requisitions outside of Sage and then generating Purchase Orders in Sage? What software did you use? How did that process go? Any recommendations or precautions?

  • Split Commission Invoice in vdvInvoice


    I am noticing that invoices with a split commission are not showing up for the secondary salesperson in vdvInvoice. Has this been an issue for anyone else? 

  • 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…

  • 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…

  • Announcing Sage 500 ERP product updates

    We are pleased to announce the release of Sage 500 ERP 2018 SP5 and 2019 SP2.

    What’s New:  

    These releases deliver resolution to issues reported, which will improve performance and your overall Sage 500 ERP experience. They also include enhancements…

  • Finding Answers Fast: Resources for Sage 500 ERP

    Sage has many resources to help you get the most value out of your Sage 500 ERP solution. Sometimes, however, having multiple options can be a little overwhelming. Now you can get quick access to all assets by remembering a single URL:


  • EFT file location

    Can the EFT file be saved to a network location? 


    CITRIX, Sage 7.7

    When the set file location button is clicked only the C:\ drive contents are displayed with no option to change to a network drive.

    Thank you

  • How to get user access report using SQL query

    This script a quick way to check user’s permissions to Sage 500 tasks and security events. It is based on the explicit permissions to the tasks and security events stored in tables tsmSecurEventPerm and tsmTaskPerm. If the records do not exist in either…

  • Preparations you can make to continue to run your business during uncertain times

    As a Sage customer or partner, it’s never been easier to work remotely and empower your business and customers through cloud-based technology. We’ve put together a list of tools and helpful tips to keep your business on track when you may need to work…

  • Recalculate fiscal and inventory calendar period balances

    Sage 500 inventory history is tracked in multiple tables and by inventory calendar and fiscal calendar. If you are running into a situation where current quantities on hand and value are different when Inventory Valuation Report is run by different start…

  • Looking for an ERP Support Manager based in NH

    Hi Folks,

               We're in the need for an ERP Support Manager based in NH for MAS500 and a WMS application.  If you are or know of such a person, feel free to reach out and I can provide more information.

  • SO to PO

    HI, I have a HOW TO question.  Is there any way to automatically create a Purchase Order from a Sales Order when certain items or drop ship items are on the Sales Order?  Has anyone done this or is this core functionality?

    Thank you.


  • New company setup

    We currently use Sage Mas500 for three companies. We would like to create a new company and use one of the existing entities as a template so as to avoid manually configuring the various modules. I've read that this may be possible in other versions of…

  • DataPorter and Metadata

    DataPorter is based on moving data between spreadsheets and forms. It prepares a spreadsheet to receive data. Data is either copied or entered in the spreadsheet. It then takes the rows on the spreadsheet and imports them back to the form. DataPorter…

  • SAGE 500 GL Posting restrictions

    We do not have a way to restrict a user from creating and posting a journal entry in the GL.  Our IT department tells us it isn't possible.  How is everyone else dealing with this in Sage 500?

  • Sage City, your new source for product release updates

    When it comes to product updates, it’s critical the right people get the news in a timely manner. That’s why we’re asking you (and your colleagues) to proactively choose the news most important to you by subscribing to the Announcements…

  • MRP Generation enhancement for items using Manual reorder method

    Starting with the October 2019 product update for Sage 500 version 2019 we have made a change to MRP processing user interface. As shown in the screenshots in the Material Requirements Planning Generation form’s Options tab we have replaced in the Selection…

  • Webcast: 2020 Sales Tax Changes

    For anyone that deals with sales and use tax, this is the most important presentation to attend this year. As 2020 nears, it's time to get prepared for the major tax changes taking effect across the United States. Register for our live webcast to …

  • Webcast: Become a Data-Driven Organization with Sage Alerts & Workflow

    Avoid the dreaded “if only we had known” 

    Business intelligence. Almost every organization has it as a goal, but few can afford the time, cost, and resources to implement it. Until now. Because just like ERP applications, when it comes to BI…

  • Business Insights Dashboard checklist

    Business Insights Dashboard allows executives to view company financial information from a web browser.

    This article is a summary of the settings that need to be in place in order for the Business Insights Dashboard(BID) to work correctly. It may also…

  • how do I know when a sales order is fulfilled and ready to invoice

    I am using MAS500 and I am handling many spare parts orders.  Most of the parts I need to order from my vendors and will wait for them to be received.  How do I know when the parts are received and a sales order is ready to invoice?

  • Email Variables

    We want to customize our statement emails to include customer name, code, etc.

    Can Document Transmittal accept variables?  if so, is there a list of variables?



  • How to add a Business Insights Explorer option to the Preview Navigation bar

    You can use Maintain Business Insights Views / Context Menus to  add a Business Insights Explorer option to the Preview Navigation bar. In the following example a Pick List preview is added to an existing BIE Customers task. You can create your own BIE…

  • New company setup

    Can someone point me in the direction to set up another company within Sage 500?  We will be adding another company on and I want to keep them completely separate from one another. Therefore I will need to setup a whole new company / entity for AP, AR,…

  • accounts payable tables

    Hi everyone,

    Can someone provide a list of accounts payable tables to show AP invoice payment history?

    Also, I am looking for vendor master tables.

    thank you