x Want to participate? Join the group to interact

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

  • BOI for Sage100 ERP - BM Production Entry - How to Get BOI Logic to Explode Bill Components

    I am using BOI to automatically create production entries in BOM in Sage100 ERP. I realize Sage100 ERP support is obsolete, but it is what our company still has and we plan to update in the next year. I have some code I threw together below for testing…

  • Can I use table IM_ItemWarehouse to trigger script?

    Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…

  • Updating Batches via BOI

    Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…

  • BOI - Printing of Purchase Orders - Unattended

    Experts, I have a script that prints Purchase Orders to PDF through BOI. The script works fine when I manually run it. If I run it unattended through Windows Task Scheduler, it doesn't print the PDFs. My logfiles show that all the return values are…

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

  • VB Script to compare and update the date values for 2 date fields

    Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

  • Setting Default Value to Drop Down UDF oddities

    Hi everyone, I'm wondering if I could get your help on this. I have a simple Drop-Down Box UDF with 3 possible values in SO_Header (validated against its own list). At the creation of the UDF, the default value was set to the value "None", which I confirm…

  • AP Manual Check Entry screen with UDF from another business object

    Hello, Can anyone help me with example code on how to get a User Defined Field in another object? I'm used to using oSession and oLines to get the header values and details for AP_ManualCheckHeader and AP_ManualCheckDetail. But I'm trying to get one…

  • Script to transfer data to secondary company

    Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

  • Help with SO_Invoice_bus

    I'm trying to create a Sale Invoice via BOI and not doing something right, but not sure what. When I nSetKey, I get this error "You cannot use a credit card payment when credit card payment type is not set up." Thanks!

  • Entry exceeds available quantity

    Hi All, I am trying to enter a Sales order in Sage 100 using BOI with .Net program, I have the problem to handle the "Entry exceeds available quantity" pop up. I am searching for a method but I am not able to find it. Is anyone has an how I can…

  • Update SO field from PO button script

    I'm trying to write a button script that will copy a single line from a SO and "pull" it into the open PO. I've done this successfully for SO (copying from Invoice or SO/Quote History), but with PO, I'd like to be able to "tie" the SO and PO together…

  • Problem Creating Receipt of goods whit BOI in c#

    Good morning guys have a problem creating a receipt of goods over PO got Missing or invalid header. triying get olines this is mi code using (DispatchObject pvx = new DispatchObject("ProvideX.Script")) { // Replace the text "*PATH TO MAS90\HOME*"…

  • Updating UDF in SO Line

    i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…

  • SetError not displaying correctly and displaying error about credit cards only when processing credit memo via SO_InvoiceHeader

    I have BOI Script in the table pre-write events for SO_SalesOrderHeader and SO_InvoiceHeader that do regular expression searches in the ship to address fields for PO boxes when certain ship via types are used, as most of our ship to addresses should not…

  • BOI access of Sage 100 instance hosted on cloud server

    Looking at the C# example provided with the Object Interface course there is a portion of code that points to the MAS90\Home folder, pvx.InvokeMethod("Init", @"C:\_WORKING\90W420-0607\MAS90\Home"); how would I accomplish this if my Sage 100 instance…

  • Questions relative to invokelookup

    Hello, I am trying to write a script for lookup button in order to pull the salesperson data. I only want to pull the salesperson data whose division number is “00”. How can I pass ARDivisionNo as parameter? Here is the script which I am working on…

  • Integrate MAS 90 BOI with the C#.net for Delete record.

    Hi I am new in BOI integration with the C#, Can anyone share with me sample code for the delete a record from the Sage MAS 90 using C#.net? Or if you have any good reference document please, I google much about I did not find anything helpful. Please…

  • UI Script properties for control types

    Hi All, Is there a list of the properties for the various control types? I am trying to work with Text labels using oUIObj.SetControlProperty(ctlName, propertyName, value),. I would like to hide labels based upon data on the screen to display the…

  • Event Triggers

    I would like a piece of code to be executed when something happens in MAS. Primarily when a sales order is created, and invoiced. Also when an AR_Invoice is created. Is there a way to do this using the BOI?

  • BOM Header changes via BOI?

    Hello and thank you in advance for your help and advise. I am trying to create a program that uses the BOI to insert a RMA at the time of arrival. The issue I am running into is the BOM is set to "inactive" in Bill of Materials Maintenance. What…

  • <Error: 548 in Method SETKEY> in script to create new GL account

    Hi All, I'm receiving the following error when attempting to create a new GL account using a BOI script. The relevant code is below. Any ideas what might be causing this? I'm sure I have a syntax error somewhere.. <Error: 548 in Method SETKEY> is…

  • In scripting, how would you trigger an event in the parent object based on a change in the child object?

    Doing a sales order invoice and adding some point of sale functionality (amount tendered, change due, balance due, etc.). I have an event that computes the change, etc. that triggers based on entering the amount tendered, changing the freight, etc.…

  • Deleting AP Check Entries via script

    Hello all! I must be missing something with my code here because I'm getting an error 45 when running the script below. It's intended to delete all entries in AP Check Maintenance. Any suggestions? Thanks! ----------------------------------…

*Community Hub is the new name for Sage City