x Want to participate? Join the group to interact

  • Button Script to Add Comment Line to GD_Lines Table in SO Invoice Data Entry

    From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card. First I actually…

  • SO Invoice Data Entry: Button Script to get Invoice No from an SO No

    I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker. Essentially, instead of the user typing the invoice # they would type the sales order…

  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…

  • Script to retrieve altcountrycode not working

    I get an error whenever I try to set the Country Business object, either as a childhandle or asObject. I have no idea why this keeps getting an error 88. 'Title: UDF_Alt_Country_Code 'Desc: Autofill the UDF_Alt_Country_Code after selecting Country…

  • How to get Child or sub file (table) level data from Sage VB Script

    Hi All, I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....". On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write. …

  • Need help with a script invoked on the button click to validate the customer's open invoices

    Hi friends, We have a business requirement to have a vb script that would pop up a message box on the sales order entry as soon as we tab out of customer no field or set as a user-invoked button. If the customer has any open invoices that are past…

  • How to use Azalea software, provided with Sage 100 in EXCEL?

    I'm not finding any real instructions on how to generate Code 128 bar codes in excel using Azalea's add-ins. I see them in my workbook as VBA projects, but I can't figure out how to run/execute them. Any help would be appreciated.

  • How to run bat file followed by VI job and Sage Tasks from a single command

    I need to run all the following in sequence 1 Run MS Access Macro - I have a bat file that does this nicely 2 Import data into 'Production Entry'- I have a VI Import job that works 3 Launch 'Production Register Update' panel - I see this can be…

  • Script to Validate date - Need help

    Hello, I am trying to create a script to restrict users from entering a date too far into the future for invoice entries. I think I am close, but the date I am getting is in the wrong format, and is showing the date and the time. I have tried a few…

  • VB Script - Disable Fields - Date UDF

    I wrote a script to disable and enable certain UDF's based on certain conditions. These UDF's have different data types. when the script runs apart from the Date type UDF all others get disabled and enabled properly. Is there a special syntax to control…

  • Why using ADO DB connection is much slower if run directly by MAS?

    First of all, this is for Sage 100 ERP (5.00.2.0) and SQL Server 2008 R2 I've been scratching my head. I have a simple code that is triggered at post-write in SO_SalesOrderHeader, i.e. a user hitting "Accept" in Order Entry window to execute. The…

*Community Hub is the new name for Sage City