• Has anyone used an external requisition software?

    Has anyone used a software package that integrated with Sage 500 ERP for creating Requisitions outside of Sage and then generating Purchase Orders in Sage? What software did you use? How did that process go? Any recommendations or precautions?

  • 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…

  • 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…

  • How to find out exactly what an application is doing in Sage 500 without source code?

    Our company wants to write its own labor entry screen outside of Sage 500 (ITAR compliance for a government contract), but integrate it by writing/updating/selecting from the Sage files. Basically mimic what Sage 500 is doing. How do I do this without…

  • 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.…

  • Sage500 API Documentation

    I am new to Sage and we are looking for Sage500 API documentation because we need to pull data from Sage into a different receivables application.  I have been looking around on the website and cannot find anything and I have made 10 calls to 10 different…

  • 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…

  • 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…

  • Creating customer through API aka stored procedures

    I have been trying to create a customer in Sage 500 by means of sage provided stored procedures. To start with, I have my own stored procedure which creates a record in staging table, ie. stgCustomer. Thereafter, I invoke a stored procedure(api by Sage…

  • Importing customer payment for existing invoice

    We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details and offer customer payment through other means. Now I need to bring the payment information…

  • 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…

  • Are there any stored procedure to create/update customer and customer contact?

    I recently started working with sage 500 api which is really a set of stored procedures. At this stage, I want to create/update a customer as well as the corresponding contact. Does anyone have any idea of what stored procedures to use for this purpose…

  • 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

  • Sage 500 Validate GL Account SP?

    I've just requested the SDK documentation for V2014 as I seem to not have received it, but...

    Is there a straight-forward SP or sequence that I can use to accept a GL Account number and validate it against my live database? 

    I will probably want it…