Sage 100

The default sort sequence on the Inventory Transaction tab is ascending Transaction Date. Can the default be changed to descending? Or, if that's not possible, can it be done with a user-defined script on the Panel post-load event and what would the code…

I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?

Hi all, I have done some scripting before where I write in lines to things like Sales order and Purchase order but have not ever tried cash receipts and it looks like it is a bit different based on what I am seeing! I am hoping someone here might have…

I am not well versed in scripting, but I know it can do a lot of wonderful things. I'm hoping this will be possible. I have a customer that creates credit memos but they do not always apply them. They would like a way to checking their customer's invoices…

Hello, I am scripting a button that, when clicked, opens up the sales order history lookup from the Invoice History Inquiry panel. I am trying to get this lookup to already have the sales order number entered that is shown on the current panel. For…

Hello, I am trying to create a button/link inside of AR Invoice History that pulls up the Sales Order and Quote History window. Basically, something that acts identical to the "Invoices" button at the top right of the screen on Sales order Quote history…

Does anyone have a script for over-riding the price on a sales order with the lowest price ? Some of our customers get product line discounts that result in a lower price than the current promo price. It might be like that for every SKU in the product…

I'm trying to add an MS Script button to the SO Invoice Data Entry panel. In the script I need to access the LOCAL cCurrentPaymentTypeMethod$ property inherited from Class SO_CommonEntry_UI. Can this be done and, if so, how would it be coded?

In AP Invoice Data Entry, when user selects invoice no, the invoice date will be auto populated. Is there way to turn this off? My business partner told me script might be required if I want to clear the invoice date. I did the similar thing in Sales…

Hi, I need to change Promise Dates on multiple Sales Order Lines for a range of item numbers. I wrote a little script that connects via ODBC into Sage and grabs the SalesOrderDetail information for the items that need to be changed and puts it into…

Hello, I have been working on a script that launches after a visual integrator job and have run into an issue with the Exit Sub function. I have seen other threads about how you have to define the Sub first when triggering like this but can't quite…

I'm trying to use a script to store the ShipToAddress1, 2, and 3 field values prior to having a script fire off a button click which does an address validation through a 3rd party plugin. I have the address validation working. However, I cannot get the…

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…

Hi all, I have a peculiar situation. I have a script set to run at Table Post-Write on BM_BillHeader to return the new values. But no matter what I can only get the old value. This is in VBscript/SQL Server 2012 environment. The process/script logic…

Business Problem: One of our inventory peeps needs to analyze and see when the PO Required Date changes for an inbound PO. We have a pulling schedule etc... with some partially pulled and staged orders. Those orders are waiting on inventory from inbound…

Hi All, I know I must be missing some basic concept here. I have a client that wants to insure that all items have an extended description. Here is what I have: sType = "" retVal = oBusObj.GetValue("ItemType$", sType) If sType <> "1" Then Exit Sub…

Hi All, I am working on what should be a pretty simple script. Got it to work but then changed the trigger for it and now I cannot get it to fire off. I have setup one of the categories in inventory as "Raw". I will enter Y in the items that I want…

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…

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…

We have some standard price level codes we use that are set up for each item, if you are a wholesaler you get X price, MSRP has its own price code, etc. The descriptions for these codes are universal, W always would be described as wholesaler for example…

Hi Folks We are working on a script to calculate a volume discount for sales orders. However it is not writing anything out to the order but we do know it is running. Any suggestions would be apprcieated. It is set for Table - pre totals. 'Init VARs…

Have a script that runs fine in Sage 100 2013 Standard: sFirst = "" : sLast = "" : sKey= "" : sCKey = "" retVal = oBusObj.GetValue("UserCreatedKey", sCKey) Set oUser = oBusObj.AsObject(oBusObj.GetChildHandle("UserCreatedKey")) retVal = oUser.getvalue…

I have a script that is triggered by a button on the Lines tab of Sales Order entry. I would like to type in the Extension Amount ("Labor $ Sold) and then trigger a script that uses a preset labor rate (in the script) to calculate the qty of labor hours…

Need to have a script run as soon as a user selects a field on a line in a grid. I'm not sure which event can control this or how. Any ideas? [I posted a similar question in the Customization section. I wasn't sure how to make it show up in this…

I have searched Sage City and cannot see to find this. I would like to fill the current PO # on the comment line as a default when creating a new PO. I have added script to default warehouse based on current user, but cannot seem to find how to access…