Browse By Tags

  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Positive Pay file generation

    When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.
  • I need a report to show me any AR that was billed but not paid

    I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …
  • Auto-emailing past due invoices

    Is it possible to automatically email our customers when their invoices become past-due? We are trying reign in our A/R and at 45 days after the invoice is issued, it would be awesome to have our system auto-send a notification/reminder to the debtor…
  • Script to rename report in Preview

    Hi I have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…
  • Adding new Document Type for Doc Transmittal

    Hello, Using customizer, we are able to add a new document type for document transmittal into the 'other contacts' window (from maintain customers). We have created a custom table to store the value and can join back to tcicontact through the cntctkey…
  • Invoice total and Final balance due on AR invoices don't match

    Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
  • How to add What's This? help to a custom field?

    I am missing the link (secret handshake) somewhere and would appreciate someone pointing me to the right direction. My goal is to enable What's This? right-click context-sensitive help for a new screen that I am building with the Sage 500 framework…
  • Is there a way to access the db connection(for temp tables) that Sage uses in vbscript?

    On the customization of the SO form, can we access the db connection that Sage is on for updating the temp tables, which otherwise are not accessible from another connection.
  • Looking for way to restrict labor progress entry to certain users.

    I'm looking for a method to restrict labor progress entries to certain users, user groups, ect... Possibly a vb script through customizer?
  • Cannot change script language from VBScript to JScript

    I would like to change the scripting language in an event in a Form Script Editor, when when I change the Language pulldown menu from VBScript to JScript, I get an error dialog with the text Script language changed. Modify existing script's syntax to…
  • Looking for Form_Save Event documentation

    I am trying to find documentation on what is in the oDM parameter ("data manager object") in the Form_Save subroutine in the Save Event, specifically in the Enter Receipt of Goods Form (PO Module). Can someone post info on what what I have available to…
  • Error calling DLL code from VBScript

    Back again with a specific bug... I have customized the Save Event in the frmBatch object in the Process Receipt of Good form: Sub Form_Save(oDM, bSave) Dim objApp, result Set objApp = CreateObject("LMNO.PrintNewLabel.FormSave") result = objApp.PrintBatchLabels…
  • When printing a posted invoice it's also emailing it to the customer.

    We are just setting up MAS to transmit invoices from the system. However, when I'm trying to print an older posted invoice it prints and it automatically transmits the invoice to the customer contacts. How can I fix it to only transmit when I tell it…
  • Change default PDF Attachment on Customer Statement

    Is there a way to change the default naming convention on the PDF attachments when performing document transmittals in the AR module? MAS500 by default uses the customer number. We would like to use the customer's name so that the email looks more business…
  • where can i fine the file layout overview for sage erp 500

    I'm trying to write some report, and i need to know where i can find information about the tables, would like to know about the list of tables.
  • How to implement Dashboards

    I'm new and would like to implement so i can learn, business insights dashboards. sage 500 7.40.8.0