Sage 100

I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…

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…

Hello, I am working on a script to change the payment type based on the terms code that is entered in the sales order. This script fires fine for setting the field to "None" or "Check", but when the script is supposed to change the value to "Credit…

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…

Hello, We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#: // Loop though AP invoices a batch foreach (var invoice in batch.NonInventoryInvoices) { try { service.Call("nCLEAR"); service…

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…

I'm stuck and can't quite figure out why. Below is a script I wrote to add a new line item to the CI module (I copied and pasted from several places). If SetSession("C/I", "CI_ItemCode_UI") Then writeLog("Connection Complete - Item Maintenance") Try…

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…

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…

Without going in to the whole story we are trying to update some fields for auditing purposes and don't want the user to have the option to not save the changes to the order thus not having a record of the auditing information we are looking for. I have…

Hello All, I'm trying to create a script that would look up the current customer by name in another company code and insert the corresponding customer number into a UDF. Is there code that could be used to run lines of a user defined script on another…

Hello All, I'm running the script below and attempting to update a couple of PO Receipt Header UDFs, but am receiving the error Invalid/Unknown Property Name. Object Required: oHeaderObj. I'm sure I need a bit of code to call the Receipt Header. Can…

I have created a script, and it does not seem to work. Do I put it under column validation, or some other mode. Here is the script. Retval=0 rExtcost rExtamount=0 rQtyship=0 rUnitcost=0 rLineGM=0 Set oLines = oBusObj.AsObject(oBusObj.Lines) oLines…

I am looking for the code to determine the event that fired off a script. Are there any methods to check to see if the event is post-read, pre-write, post write, pre delete, or post delete?

I have a UDT that is used to capture data during SO Invoice Data Entry. I want to copy data from this UDT into different UDT where data will be stored for historical purposes. Ideally I would like to have this automated during Sales Journal update but…

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…

Is there a way to do this? It seems like all of the information in File Layouts and Program Information points to that fact that AliasItemNo is required, therefore I can't use a setkeyvalue to assist in searching for a part. So say I have part ABC and…

Greetings, I am trying to use the following: retVAL = oPOOrder.nSetKeyValue("PurchaseOrderNo$", sPONumber) retVAL = oPOOrder.nSetKey() retVAL = oPOOrder.nSetValue("PurchaseOrderDate$", "20140529") retVAL = oPOOrder.nSetValue("OrderType$", "S") retVAL…