• Announcing Sage 500 ERP 2019.0

    What's New The 2019.0 release of Sage 500 ERP includes the following enhancements: • Ability to make Buyers and Reason Codes inactive • Exclude unused records from Report Selection Criteria • View payments in Vendor Status Window • View receipts in…
  • Can you adjust the time period used by Average cost?

    We are using Average Cost, but I"m finding that during the first couple of years using Sage MAS 500 there were a lot of issues with incorrect settings, bad data, user errors, etc.. and this has caused an inflated value with our average cost. Can I somehow…
  • Reverse a Bank Account Reconciliation

    FormerMember
    FormerMember
    is there a way to reverse a posted bank reconciliation? I am new to Sage 500 and have made an error that covers 2 months of bank reconciliations. I failed to key in the Bank Ending Balance for these 2 months and have just caught the error.
  • Lead Time Formula vs Projected Lead Time

    If you specify both a Lead Time formula & Projected lead time in the Maintain Inventory, which does MRP consider? I did a average lead time calculation based on the last 15 months using the PO date vs the Receipt date and was going to update the Projected…
  • Error posting Receipt of Goods batch

    Hello! We are trying to post a batch of Receipt of Goods and keep receiving the following error: Can anyone offer advice/suggestions/a solution?? Thank you!
  • Does anyone know what a TranStatus of Incomplete in the tpoReceiverLog table means?

    We have some, less than 100, records in the tpoReceiverLog table that show a status of 1, which vListValidationString says is Incomplete. The RcvrKey 's do not exist in tpoReceiver, so I am suspecting that they are somehow orphaned records in the system…
  • Sage Intelligence Sage500 Statistical data

    Can SI for Sage500 pull Statistical GL data, i.e. Qty? If so any hints on how?
  • Sage's Silver Support Plan Changed to 5 cases per year.

    Does anyone have current documentation from Sage showing where their Silver support plan changed from 20 cases per year to 5? Our support was changed and we did not receive notification of this change from Sage or our business partner. I can't find anything…
  • Posting AP Check to Previously Closed Period - SAGE 500

    Hello - I was asked by an auditor if my team can post an AP invoice to a previously closed period. in Sage 500. Always assumed 'no', but an AP staff member was able to post to a prior period once they 'accepted' the 'posting to a prior period' warning…
  • Inventory Transaction History Analyzer, Stock Out and Lost Sales Quantity field calculation

    In the Inventory Transaction History Analyzer, does anyone know how are the Stock Out field and Lost Sales Quantity field calculated?
  • clsScriptMgr.ExecuteScript: Method '~' of object '~' failed

    A user is getting this error message when they try to complete a Transfer Order. In the past, logging out and back in has allowed the user to continue, however now it's not working as a workaround anymore. I logged in on my account and the transfers went…
  • Freight taxes

    Our company needs to start taxing certain customers and I'm very familiar with how to use Sales Tax for items. I remember also taxing freight - many years ago - but I cannot remember how to set it up to include freight as well. Can anyone remind me how…
  • Using Data Porter for Project Transactions

    I'm in Finance / Accounting at an international consulting firm. We're trying to find a way to accrue revenue at a project level without having to record credit memos and reversing debit memos that would actually impact accounts receivable. We're therefore…
  • Sage Enterprise Intelligence 7.1.6 for Sage 500 ERP available for download

    Sage Enterprise Intelligence version 7.1.6 for Sage 500 ERP is now available for download. This version is compatible with Sage 500 ERP versions 2016, 2014, and 2013. To find it in Sage 500 knowledge base please search for the article 73887 or a string…
  • ap trial balance query

    does anyone have a query that returns the value of the AP trial balance? We want to extend that functionality to show line dist level detail of vouchers
  • We have 2 old pick lists that are stuck. The pick numbers show up in Explore-Pick Lists (show as status = pending) but when I type the pick list numbers no records are found.

    We have 2 old pick lists that are stuck. The pick numbers show up in Explore-Pick Lists (ship status = pending and there is a shipment number) but when I type the pick list numbers to reprint pick list, cancel pick list or confirm picks the pick numbers…
  • We want your input!

    We are conducting a quick survey of Sage 500 ERP companies to determine the AR payment options you offer to your customers. If you would like to participate, click here to access the form. Thanks for taking the time to respond!
  • Paying AP Invoices by Credit Cards

    Currently we enter AP Invoices under the company name then on the due date we pay by credit card and make a flip to remove from the vendors name into the appropriate Credit card AP account.. Is there an easier way to complete the flips without entering…
  • Error when trying to Post Order Entry screen and create invoice.

    When trying to create a new order in the order entry screen and shipping product from inventory with a price of more than $0. If we check create invoice and attempt to post we get the following error: Description: Incorrect procedure. Shipment cannot…
  • Electronic filing for 1099 from Sage 500, Does it work?

    I would like to electronically file my 1099 forms this year if possible. Does the process work in Sage 500?
  • Invoice for Purchase Order before Receipt of Goods

    In a lot of cases we prepay our vendors for all or a portion of the goods. The invoice is received and partial or all of the payment is made prior to the goods being shipped. We use purchase orders within the inventory process. How do I put in the invoice…
  • Ctrl-c in explorers

    On July 14 update(Version 7.60.3.0). Noticed when I try to copy some data from a BIE grid using Ctrl-C, the filter goes away and the highlighted data isn't copied to the clipboard. Keyboard shortcut to clear filter is Ctrl-Shift-C. Ctrl-C won't clear…