• Sales Order Ship To Address

    Hello, When updating the ship to address from the header on an SO, a prompt is displaying saying that in order to proceed, you will load default FOB, Ship Via, STax schedule, STax amount, req date, schedship date, and promised date. We just want to…
  • 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…
  • Populate text box

    Hello! We would like to have a textbox on Enter Sales Orders and Quotes that populates once a customer, and subsequently a salesperson, is selected. I've added the box and binded it to the appropriate field, but it doesn't populate until we save and…
  • 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…
  • 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…
  • Knowledgesync - Custom Crystal Reports - Date Ranges

    I'm having trouble getting Knowledgesync to generate reports for date ranges. The date range parameter is hard coded in the crytal report but I need to have the parameters coded in knowledgesync. I need the date range to be for a month timeframe. I tried…
  • 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…
  • what are Dashboards

    I would like to know what are Dashboards and how can I configure them?
  • Crystal Reporting Beginner

    I'm trying to setup new reports, but where could i find the table references for current reports.
  • tU_tsoSOLineDist

    Hello, I recently made a similar post to this one regarding the insert version of this trigger, tI_tsoSOLineDist. Our issue was resolved and we are now able to save the original ShipDate entered so when the date changes, we can see by how much. However…
  • tI_tsoSOLineDist

    Hello! We wanted to capture the original shipdate (tsosolinedist.shipdate) entered into the system, so that when this value gets updated we can track how many days out from the original date we are. So near the end of the insert trigger for tsosolinedist…
  • 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…
  • How to pass session.UserId into a shortcut task?

    Using Sage MAS 500 August 2010 Update (Version 7.30.4.0) Created a shortcut task that calls an .exe. I wish to pass session.UserID as an argument, so that the exe can use it to verify if the user has the authority to use certain features within the…