• MRP Generation Report

    Hello, I've been in Supply Chain for many years now. I have used several ERP systems, but this is my 1st time with Sage500. I have tried to find resources on understanding the MRP Generation Report with no luck. Does anyone know where I can find some…
  • Data Type Conversion Errors in Explore - GL Transactions

    I was testing out the AP Module that we just acquired and posted a batch of vouchers. When attempting to run the GL Account Transactions task to view these posted transactions, I ran into two different errors: The varchar values it's referring to…
  • 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…
  • TempDB fills up while accessing vdvCustomerPayment

    Running an AR Report - the query errored as the TempDB filled up. Our DBA noted the following: This query below caused the tempdb to grow and fill up the D: drive. The issue for the is connected to the view below – vdvCustomerPayment - which joins…
  • Tip: missing objects in Crystal Database Expert

    If you ever find yourself attempting to modify a Crystal Report and you notice that some tables are missing from the 'Data' tab of the Database Expert tool within Crystal that shows you the tables that are available to be added to the report, it is most…
  • latitude, longitude - printing on customer statement

    We recently upgraded to 2021 (8.1) and on the customer statement, we see an odd default longitude and latitude near the bottom of the customer address. Is there any way to eliminate this without creating a custom crystal report?
  • AP CHECKS Printing with VOID on them

    AP Check form starting printng VOID watermark on the ENTIRE CHECK, the form has not been touched since 12/2/2015 and today it just starting printing VOID VOID VOD all over in very very light font - Is there a way to stop this from happening?
  • Is there a report that shows clients that are setup for email delivery of invoices and customer statements?

    Under the AR module, Customer Maintenance, Maintain Customers, doc transmittal you can elect to have invoices, credit memos, debit memos, customer statements, etc. setup for hard copy or email delivery. We're trying to get the majority of our clients…
  • Why do some report tasks have a .NET Configuration File?

    During discussion today the question came up "Why do some Sage 500 report tasks have a .NET Configuration file and others do not?" Since the report task is still written in VB 6 and there seems to be a necessity to interact with .NET because of the configuration…
  • 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…
  • Split Commission Invoice in vdvInvoice

    Hello! 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?
  • Crystal Reports

    I am having an issue with a workstation new Windows 10 computer, installed the Mas500 2019 client When the user tries to run the Aged Receivables, he gets an error "crystal print engine the system cannot find the file specified" I have reinstalled…
  • Getting errors in my MAS Intelligence Report Designer reports.

    On several of our Report Designer reports we are now getting #VALUE! or Object reference not set to an instance of an object errors when just the other day they were fine. I believe it is an Excel issue this time since I ran and saved the same reports…
  • Purchase Order printing

    I am using Sage 500 ERP 2013 and when I print a purchase order on one workstation I get a different printed purchase order than when I print the same purchase order from another workstation. I am using the same sage login name at both workstations
  • Voucher Register not displaying the comment section

    This may have been covered somewhere but I can not find it. We recently ungraded to Sage 2018. We did an update last year and the comment section on the voucher header disappeared. After the upgrade it came back, the IT guy did something and now we no…
  • Stock Valuation Report by Bins

    Is there a way to add bins to the stock valuation report. I need to know the value by bins. Thanks!
  • Printing 1099 Summary reports to include full Taxpayer ID

    I am having an issue with being able to report the full taxpayer ID on Vendor 1099 activity report? Is there a way to unmask this field as it is currently only showing the last 4 of the taxpayer id.
  • On Time Ship Metrics

    FormerMember
    FormerMember
    Greetings, We are currently in Sage 500 Version. 7.4. Does Sage 500 have a user friendly On Time Ship and Current Late Units reporting ability besides exporting and filtering data in an excel spreadsheet? I am super new to Sage 500 so any advise…
  • SMI equivalent of the FRx reporting tree?

    What is the equivalent in SMI of the reporting tree in FRX? How do you duplicate that functionality?
  • I am looking for a good OFAC Compliance tool that works with Sage 500 ERP

    FormerMember
    FormerMember
    I need a recommendation for OFAC Compliance tool that works with sage
  • Export work order shipping reports to an excel template file or see if this is possible?

    FormerMember
    FormerMember
    Looking to export work order shipping reports to an excel template file or see if this is possible? We currently barcode a significant amount of inventory and want to be able to convert workorder #'s and locations to barcodes One thought was to export…
  • Drill Into missing in BI-Explore for Vendors

    We have a specific user that (according to the user) suddenly was missing some Drill Into options from the Explorer window for Vendors. She's looking to analyze payment info, but can't see the Vendor Payment Drill into option. If she navigates to AP-…
  • Is Sage 500 Finra Compliant?

    I need a 17a-4 letter letter from FINRA but haven't been able to find out if 500 is FINRA compliant
  • Looking for help on finds the material Item field name/ table in maintain router

    I am trying to do a crystal report that I need to pull the field that is"material Item"(SEE THE YELLOW HIGHLIGHED that is located in Maintain Router, Detail, then material. The Operation type is Outside Processing. Does anyone know the table or view…