• Customizer - How to Preview Crystal Report

    I am able to generate a custom report to printer via Button Click using the following code dim CRApp dim Rept dim RptFile RptFile = "<ReportPath>" Set CRApp = CreateObject("CrystalRunTime.Application") Set Rept = CRApp.OpenReport(RptFile) With…
  • Picking list by company

    I need a separate picking list form for each company. Where is this setup? I cannot find the picking list in business forms in Common Info.
  • 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…
  • Need additional files created during check printing process

    We would like to create a process within Sage that will allow us to create a secondary run of the Check Printing process. The result of running the process is to create PDF files of each check, and at the same time, generate a file containing the data…
  • 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…
  • Troy Printer Signature in Crystal Reports

    Has anyone out there been successful getting a signature to print using Troy Group's signature chip? With the Altec solution, the signature required the use of a text field ~&f131Y~&f3X that would trigger the printing of the signature from the chip…
  • AR Commission Report by Line Item

    Our AR department is asking IT for a way to calculate commissions by line item from the invoice. We cannot find a way to customize a report that pulls both Sales History and Invoice History. Is there anyone out there that has accomplished this or is it…
  • Conditional Script?

    I have a script that populates the Commission Plan on the Invoice detail line from what is selected on the header. The script is quite simple: Form.Controls("cboCommPlanDtl").text = Form.Controls("cboCommPlan").text and works perfectly as long as…
  • Use vbscript to pass the number of copies to print as a variable when printing Crystal labels

    In Customizer, am scripting to allow user to click a button to print package labels at PO receiving. Works fine except I want the user to be able to specify the number of copies to print for each label (have that part done) and then pass that info to…
  • 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.
  • Reports - Tracking

    I'm new with Sage 500 ERP and I am trying to implement some reports to monitor for tracking purposes. The main report I'd like to use is one that has some type of list of all the batches created in one day that I can pull on a daily basis. Is there a…