• GL Statistical Accounts

    1. How do we clear GL statistical accounts in Sage 500 at yearend 2. Can we use GL statistical accounts in Sage 500 for budgets
  • Server and OS Upgrade

    Hello, I have a client on Sage 500 v 2017. This is was the main ERP for a smaller company that was bought by a larger one. I am being asked to upgrade the server - both the Windows OS and the Sql Server. (I am reluctant to upgrade the sage 500 version…
  • Just released: A new way to schedule support appointments for Sage 500

    Keeping in line with our Sage value Simplify, we’re making it easier for Sage 500 customers to book your appointments by using Microsoft Bookings. Switching our scheduling tool over to Microsoft Bookings will streamline the way you make appointments…
  • Process Invoice for Payment

    The Treeview has changed and it is now unusable. Tree view use to contain yellow/ black circles to this you can no longer select individual invoices for payment
  • Recording bank drafts

    We are performing bank reconciliations for our client. The client is recording bank drafts by writing "dummy checks," as they call them. Is there another way to record the bank drafts so that they will still show up as an item to clear in the bank reconciliation…
  • Upgrading from 2016 to 2021 SAGE 500

    We noticed there are additional security events in the 2021 version (such as view tax id in plain text). Are all the events documented somewhere?
  • Importing purchase requistion details from an external csv file into the grid field

    Newbie here. I am entering items details manually into the different fields of a purchase requisition. I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…
  • Is there an easy way to import journal transactions to SAGE 500 ver 2016 from QuickBooks

    Looking for the best method to import transactions. We do not have Data Import Manager. Sage 500 version 2016, upgrading to version 2021 this year.
  • Labor Entry posting for the entire shift

    We have an issue with a product line, and we can't seem to correct it. On 90% of our routings for manufactured products, when we do a Labor Entry it calculates Overhead and Fixed costs using the pieces per hour and work center rates. One one product…
  • Determining if a budget was closed

    Is there an easy way to determine if someone closed a budget period? SAGE 500
  • any risks in compacting sage intelligence meta data?

    Are there any risk(s) associated with compacting the MetaData? Is it worthwhile? Sage 500 2017 and Sage Intelligence.
  • Sage Intelligence and Office 365

    We are using Sage 500 2018 (v7.9) and we recently upgraded from Office 2016 to Office 365. Now our Accounting department is receiving errors when using Sage Intelligence i.e. Sage.BI.ExcelFunctions1.1.x11 don't match. I have tried to Add the Report Designer…
  • Sage 500 RAID Configuration

    Hello Everyone, We are in the process of setting up our new server and was wondering if Sage 500 will work in a RAID environment? The SQL Server will be running in a VM and we have 16 1TB SSD drives to "play" with.What RAID configuration would be best…
  • SQL Server 2022 Compatibility

    Hello, We are purchasing new hardware to replace our outdated server. Does anyone know if the latest version of Sage 500 will be compatible with SQL Server 2022. I like to believe that there won't be any issues but you never know. Has anyone been running…
  • Adding quantity from invoice lines to project lines view/explorer screen.

    We are starting to you use Project accounting, and find the explorer window great. However, the quantity invoiced in the vdvproject lines view, seems to be inaccurate. Infact, we would like to quantity from invoices lines view. I have tried a couple joins…
  • Bank Accounts - Possible to Edit the name?

    I know it's possible to do but can't recall where in SAGE 500 I am able to edit a Bank Account. I recently created a few bank accounts in SAGE 500 ERP. Realized I could be more brief with the account name and went to edit them however the Bank Account…
  • MAS 500 ERP 2021 update 2 error: No Sales Order options records exists for your company

    Database and Client upgraded from MAS 500 ERP 2018 (7.90.2.0) to Version 2021 update 2 (version 8.10.2.0) on test environment. For Sales Order, when tried to create new sales order error No Sales Order options records exists for your company pops up.…
  • Price Sheets / Contract Pricing

    I have a situation where I am having trouble finding a solution. Please, see below: I have one salesperson that I want to give promotional pricing to, but not other salespeople who pull out of the same warehouse Is there any way that I can possibly…
  • AP Voucher Entry - Shortcut to go Back in to Grid?

    When I'm in the AP enter vouchers window, if I'm on the Totals tab, is there a keyboard shortcut to enter back into the grid on the Details tab? I know that I can do Alt + D to go back to the tab, but I'm hoping to find a way to enter back into the grid…
  • Office update to 2019

    We have some users using Sage 500 locally, we just did an Office update to 2019. Now the export does not work in the Explore view. Options are greyed out.. Is there a setting in Sage needs to be updated?
  • Sage Intelligence Filter and Parameter combination - need help

    Need some eyes on a Sage Intelligence Transaction report filters and parameters. Please see attached file. Adding filters with parameters works for one set but not another. Can someone look to see if you have a suggestion as to why the filter/parameter…
  • Material Costs in reference to routings

    I am stumped and need to find some answers, hopefully someone here can help? On the routings, each material item has an associated "Material Cost", I am trying to determine where is cost is coming from. It doesn't matter to me if the material part if…
  • Duplicate account numbers in consolidated report (Accounts S500 1-0)

    Changed a report to pick up 3 of our companies (A,P and C) (Created consolidated connector then exported and imported the report using the consolidated connection) The accounts union report (Accounts S500) is one of the many that are included in it…
  • Error in CalcCrRatioSlackTime Routine

    Trying to run Schedule Generation for the first time and i'm getting a few errors. it was going through the steps and stopped at a work order. gave an "Error 5 occurred at frmmfzmn001 in Procedure cmdGenerateSched_Click. Invalid procedure call or argument…
  • Critical error during matching process

    Trying to post a Goods Receipt and get this message during matching. What would cause this?