• About page print landscape and cutting off info

    I am changing my computer and am wanting to print off/save the about page showing info on but it is cutting off info and printing landscape. When trying to print as an A3 it still cuts off.
  • 2023 1099 Submission Error

    It seems like we inadvertently submitted 1099 (I was trying to test out for the new year). As a result, it seems like we are unable to match payment in AP and the invoices don't show up in 1099s. Is there anything we can do to reverse the submission?
  • 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…
  • Attach files with Document Transmittal?

    We're currently auto-sending invoices via email through document transmittal. I'd love to be able to attach additional documentation (remittance instructions, W-9, credit card auth form, etc.) with the invoices that are sent via email. However, it doesn…
  • Is there a way to reprint individual remittance advice?

    If I need to reprint a remittance advice, is it possible to do it individually? I don't want to reprint the entire batch, which is quiet large.
  • Attaching Invoices to blast emails/mail merge

    I'm new to using Sage 500. I've got a number of past due invoices to send out (talking hundreds). It would be helpful and more efficient if I could do a blast email via mail merge or another method. Is there a way to attach invoices from Sage to a blast…
  • 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…
  • New NACHA compliance changes in 2020

    Do we have any update on Sage 500 coming to meet the new NACHA requirements that are slated to take effect mid-2020? www.nacha.org/.../2020-brings-four-nacha-operating-rules-changes-are-you-ready
  • 2020 1099-MISC/NEC forms and data entry

    As some of you are aware, tax year 2020 will bring a new 1099 form, the 1099 NEC (NonEmployee Compensation). With it, will bring some new changes. Every couple of years the IRS doctors up existing forms by sometimes adding boxes, removing boxes, or…
  • 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.
  • 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…
  • Limit Account Lookup

    We are working on updating our security per user, and want certain users to only be able to see certain accounts in GL Transactions Reports. Is this possible by user?
  • Exporting the default Commission Plan for each customer

    I am interested in performing a Customer Explore and exporting the results to Excel. The problem I'm running into is that the field 'Commission Plan' doesn't seem to be a field that I can display or export from the Customer Explore function. I know that…
  • Add tpoPurchOrder.CreateUserID to the Blind Receiving Ticket (pozri001.rpt)

    I would like to add the PO Create User to the Blind Receiving Ticket. I've added tpoPurchOrder to the Crystal Report (pozri001.rpt) and have tried to add the CreateUserID field but have not had success. Maybe I just haven't found the proper linking in…
  • Historical inventory report showing qty-on-hand by item by month

    Has anyone created a report showing historical qty-on-hand by item by month (the end of each month)? If so, please share the approach that you used. The Inventory Valuation Crystal report provides it, but it's not convenient as it must be re-run for…
  • Inventory Cost Report phantoms

    Hello: We are running Sage 500 ERP 2014 January 2015 Update (Verson 7.60.5.0) - we recently closed a warehouse and transferred all inventory to another warehouse. Stock Status shows nothing in the old warehouse, I can't find any pending transactions…
  • Reportable Name for Form 1099

    Hello, my company is on MAS500, v.7.3 and file 1099s on paper. Does anyone know how to add vendor reportable name to 1099 Form that it will be printed first and payee name will be printed after? Please let me know. Thank you.
  • InvtTranLog table

    What is the difference between the tran date in the timinvttran table and the trandate in the invttranlog table? Pete Gentile The Robbins Company
  • Printers compatible with Sage 2013 version

    Hi, We have users looking to buy new printers for the Sage 2013 version. I was wondering if there is a listing of printers that are compatible with Sage 2013, specifically for printing checks and 1099 forms. In the past, there were some printers that…
  • Profit Report

    Is there a report, BIE, BIA, SEI that can show profit less commission and payment terms discount ?
  • RMA Return Type

    Hi when I print out a RMA, I found RMA line has return type like 'Credit","Not a Return", but I couldn't find where this come from? who and where user enter this information thanks
  • Crystal Reports XI Training

    We are looking for a good source for Crystal Reports XI training. Does anyone have recommendations?
  • 1099 Vendors

    It has been brought to my attention that a few vendors need to be switched to 1099's. I went under Maintain Vendors and changed the proper fields but when I run the Vendor 1099 Summary, the still do not appear. I even checked to see if the dollars spend…