• Update UDT whenever Sales Orders are printed

    Greetings all, I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script. I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…
  • 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…
  • Copy invoice from AR_InvoiceHistory to flat file

    I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…
  • Launch Sales Order Entry to create new order from Customer Maintenance and pass Customer Number

    Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…
  • Forcing Cancellation Code when deleting Sales Orders into history through BOI

    Good morning all, So I figured this would have been a relatively easy script but I can't seem to find a way of accomplishing what I need. I have a customer that would like to force a cancellation reason whenever you delete a Sales Order into history…
  • Is it possible to create records in AR_CustomerDocuments and AR_CustomerDocumentContacts via BOI?

    Hi forum folks and Happy Friday! I have a customer that would like to CC a specific inbox any time we send SO Invoices and orders via Paperless Office. We have been doing this by adding this CC email to the "To Additional Email Addresses" Field under…
  • run script without admin (COM exception failed to initialize provideX library)

    I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…
  • Set Sage field equal to UDF (user script?)

    Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…
  • Create Purchase Order Invoice via BOI

    Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…
  • Accessing Business Objects with a Client side script?

    Hello, I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query. This needs to be run on the Client…
  • Unable to get previous Sales Order Lines on table - Pre Write?

    Hello, I'm simply wanting to write the previous item code to a UDT when the line is changed in a sales order. For example, if the item code was abc123 and a user changed it to def456, I want to write abc123 to the UDT. However, each time I try to access…
  • oScript.InvokeButton("xxx") Alternative in BOI Script

    I am using a BOI script to check if the Unattended Barcode Import Task is running. If it is not running, the script starts up the UI for Unattended Barcode Import. But I need to programmatically press the "Proceed" Button in the UI. Any ideas? Is…
  • Unable to use paperless office from an external BOI script yet the same script will work when launched from a button or table script

    Hi community, running sage 100 advanced version 2015. I've got a puzzling scenario. If i attempt to launch a rpt business object from a button script, i can leverage and send the document to paperless office. Yet if i run the same code formatted…
  • Is AP_VendorElectronicPayment_bus available through BOI?

    I am having trouble trying to create a new record using BOI for AP_VendorElectronicPayment. It is in the Object Reference, but I get a 200 error when I attempt to instantiate it. I have it typed correctly, and the user account I am using has access to…
  • Need Sales Order Header Script to compute Standard Cost based Margin on ENTIRE Order, on totals tab.

    I'm looking for existing script I can use to simplify our need to run a custom report during our quoting process for every order. Can anyone help me create a script that will calculate the entire Gross Profit/Margin for the whole Sales Order and display…
  • BOI for Volume Pricing Check

    Hello All, I'm using the code below to determine whether volume pricing exists for an item, but I'm getting a retval of 0 when I know there is pricing configured. My code and the record from Data File Display and Maintenance are below. Also, I have…
  • AR Invoice Data Entry Copy From Functionality

    Has anyone ever retrieved values from the AR_InvoiceHistory Header & Detail tables from inside a vb script? At the end of the day I am trying to duplicate the logic behind the "Copy From" button on the sales order header screen so that when a user creates…
  • Unattended Electronic Sales Order Invoice Delivery

    Sage MAS 100 ERP Premium 4.50.7.0 running on MS Windows Server 2008 R2 We are attempting to convert a script that prints a Sales Invoice to a physical printer to instead output the Invoice as an e-mail with PDF attached. For the user we have successfully…
  • Script to track changes to a field in PO

    I've written a script to write field values out to a UDT and record a Date, User, and time so that we can have an audit trail of these fields in PO Header. The audit trail is written whenever a there is a change to the PO. This works fine for manual…
  • Looking up value in Item Cost

    I need to look up an item while entering a sales order and determine whether there are any FIFO tiers over 90 days old. So far I've been able to use the .movefirst and .movenext methods to accomplish this, but performance is poor. Is there a way to jump…
  • Advanced GetResultSets()

    Hello, Been a while since I posted anything, and I think I may have posted this example before, but another question on GetResultSets just reminded me of it, and I thought someone might find it a useful reference. It is basically a VB .NET console app…
  • Double quote

    HI All, I'm trying to export out the field values in double quotes.I was testing out something The code is retval = obusobj.GetValue("InvoiceNo$",InvoiceNo) InvoiceNo = """InvoiceNo""" msgbox InvoiceNo Let's say the invoice no is 0000001…