• 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!
  • TY 2019 and 1099's

    1099's for tax year 2019 should not require any updates to the Sage 500 ERP applications. You should expect Aatrix, our 1099 vendor, to send down some updates when Sage 500 launches their application when their updates are ready. Most of the time this…
  • 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?
  • 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…
  • Blank stock AP check printing and signature, Sage 500?

    Is there a way to print blank stock checks in Sage 500? My AP person doesn't want to use pre-printed checks. Also, how do I add a signature to the AP check print form, Sage 500? I'm so used to having source code, I was a former developer, so I'm having…
  • 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-…
  • 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?
  • Sage 500 Error 484 occurred at frmPrintDocuments in Procedure BuildPrintDeviceCombo

    Upgrading to Sage 500 7.80.2 on Windows 2016 app server using SQL 2016. Receive "Error 484 occurred at frmPrintDocuments in Procedure BuildPrintDeviceCombo" when trying to print documents from the 'Edit Shipment' screen, AP checks from the 'Check Printing…
  • 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
  • Multiple company needing to use Document transmittal in Sage500

    Can I use the same email server/configuration in both companies to send AR Invoices?
  • 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…
  • 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…
  • Sage 500 ERP, Accounts Payable Checks

    I have a question regarding the check cutting process and I cannot figure it out. Each check can hold 10 invoices, so if you are processing 35 invoices for a vendor, that means it cuts 3 void checks and 1 check with the total on it. Our Accounts Payable…
  • No error report printing with Intercompany GL entry

    We are having issues lately where the error that comes up when the GL string used is active, but the segment is past it's effective end date does not produce an error report, and we can't find the detail of what's causing the error. I think the only times…
  • Purchase Order Unit Cost Security

    We want users to be able to check on PO Statuses, PO Expected Dates, Quantities, etc, but not see the Unit Costs of each item. I looked at all the Security Events and module options but I don't see a way to do this. Any ideas? A question involving Explorer…
  • Transfer with Costs?

    We have some damaged goods for a transfer order. UPS wants an invoice to validate costs. Of course, this is a transfer, so no invoice available. I looked for any transfer document that has costs listed, but can't find one. Am I missing anything before…
  • 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…
  • Changes to 'Print Edit List' report

    We recently upgraded from SAGE ERP 500 v7.4 to SAGE ERP 500 v7.7 (2016) and have noticed a change to the 'Print Edit List' report in AP. The Crystal Report file name is APZRY001.rpt. In v7.4 this report included the Vendor ID and Vendor Name for each…
  • 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…
  • New Sally Series

    In a couple of days, we'll be releasing our next installment of the Sally Series, this time focusing on the Connector module and how to define your own data sets for your reports. If you haven't yet checked out the first and second series then why not…
  • Accounting and financial statements

    If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…
  • Pack List With Contents Not Printing Until Commit

    Hi, We have recently wanted to start using the Pack List With Contents for our shipments. The summary prints out fine, but the detail prints only the blank Crystal report. Once the shipment is committed, the details will print fine. This leads me to…