From a BOI script I would like to select individual orders so that a type "4" record will be added to "SO_SalesOrderPrint" table. The method "SelectOrder" calls for two separated string parameters: "hdrRec$" and "dtrRec$". This is confusing. Why would…
Looking to use the BOI to retrieve a quote as a PDF. Can see topics here about generating sales orders as PDF's, example:
Hi,
I want to loop through all my not-registered invoices.
What I do (in general) is:
dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession);
obj.nMoveFirst(); //To get to the first record
//Rest of code
The problem is that I have…
Hi,
I want to read and write data in sage100 database, so after some research I found out this course for reference.
But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not?
This is the…
I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?
I have a working event script tied to S/O detail that fires on post validation of quantity ordered. The script automatically creates a BOM Production Entry for the item entered, updates the production entry and updates the GL DTR. The problem I'm having…
Is there a way to paginate the GetResultSets() function in boi? I'm thinking sort of like how in SQL, you can use OFFSET and LIMIT to divide the query results into multiple pages. Is there a way to do that with the GetResultSets() function?
Has anyone been able to Rebuild Sort Files (and/or Key Files) using BOI? Last post on this topic from 12 years ago said no, but perhaps someone has figured it out since?
I see the objects SY_Rebuild_bus in the Object Reference but am not certain if that…
Hello all,
I wrote a script with the goal to delete sales orders with a specific condition. So I can delete sales orders just fine its just that when the orders are deleted the cancel reason code is not flowing to history it is staying blank. I am even…
I'm writing a BOI script to create Inventory Adjustment Transactions. I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script. What I can't figure out is what the "refNo$" needs to be.…
Is it possible from the Production Header panel, via a script, either tied to a button click event or on one of the table events, to open an existing UDT (so that the user can see the UDT), then get a value from it and set a textbox on the Production…
I am looking for a way to use a script in Sage to create an entry, e.g. a Bill of Materials Production entry, and then open the UI for this entry to have the user complete it. I know how to open the UI for a specific program, and I know that I can open…
I'm trying to accumulate the quantities of all the detail lines in an AR invoice, but only if the item is of a certain type. I defined a UDF for that checkbox, and put it in the Item Maintenance screen.
I would like the total to update whenever a user…
Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code:
using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…
I am trying to launch either BOM Inquiry or Maintenance using an InvokeProgram or Process User Defined Script, but any time I add the Bill I get the error "You do not have security rights to create the record" but I am not trying to create a record. Any…
Experts,
I have an issue with automating invoice emails through Paperless from the AR Invoice History Printing report. The code below works fine in my test environment but fails (without an error) in the target environment.
My test environment is v20…
Experts,
I got a tricky one here. I have a UDF in IM_ItemTransactionHistory that contains a file path. Now I would like to be able to place a button in Item Maintenance on the Transactions tab that allows me to open the file.
The code to open the file…
I know there are several posts about adding a line to an invoice to charge a fee. I've modified a script I found either here or in a Sage scripting class, but for some reason, I can't get it to work this time.
When I put it on the Pre-Write event…
I have scripts that show or hide a button added to the screen depending on certain conditions. When an order is brought up the button shows/hides correctly. The issue I am having is if a user brings up an order when the condition is met and the button…
I created a button script that sends out a Sales Order Form via Paperless Office. We are not using the regular printing interface because the users don't have to select the form code, and we are also writing the print/send date to UDF.
I built the…
I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…
Apologies for the large block of text but this is a strange one.
I have a script that recalculates the Unit Price of a parent Kit item based on the component items' standard prices, and recalculates whenever a Quantity Ordered is changed for any component…
Are we able to write on the Production table from the Sales Order Entry UI?
I have items that based on the S/O Entry need to be put on a Production Entry so was wondering if after they are entered in the SO and the Picking Sheet is printed, I can write…
A button script has been working for 8 years that writes 4 string UDF's and the TransactionDate started failing immediately after upgrading to 2020. After getting successful returns on all the SetValue statements, the Write fails (retVal = 0). The IM…
This UDS is a Column Pre-Validate on QuantityShipped against the SO Sales Order Tier Distribution table at version 2016 Std through 2020 Advanced. The SetError doesn't always trigger the error message, but it does fail (i.e. clear) the distribution number…
